What is pivot table and how to create a pivot table
Answers were Sorted based on User's Feedback
Answer / prasanna s chitale
HI, GUYS
PIVOT TABLE IS ADVANCE FEATURE BY SQL ANSI WITH TRANSFORM
STATEMENT. THIS REPRESENTING THE DATA IN CONSOLIDATE WAY.
FOR EXAMPLE IF WE WANT THE PRODUCT V/S MONTHLY SALE ANALYSIS
THEN IT IS POSSIBLE WITH PIVOT TABLE.
MONTH APRIL-07 MAY-07 JUN-07
PRODUCT
MARUTI-800 700 800 550
MARUTI ZEN 100 120 90
ETC
THIS IS TYPICAL PIVOT TABLE
| Is This Answer Correct ? | 8 Yes | 6 No |
what is the Difference between DDE and OLE?
What is the use of Data Form Wizard?
Is it possible to Access BackEnd procedures? Explain.
What is ado data control in vb?
How many types of Instantiations are there and what are they?
what is differece b/w Module and class Modules in vb6? thanks
what is the Max size allowed for label caption length?
what controls have you used in your project?
How can we call Stored procedure of Back End in RDO and ADO ?
What are 3 main differences between flexgrid control and dbgrid control?
What is ActiveX Dll and ActiveX Exe?
How would you attach an ActiveX control in Your Application?
Visual Basic (800)
C Sharp (3816)
ASP.NET (3180)
VB.NET (461)
COM+ (79)
ADO.NET (717)
IIS (369)
MTS (11)
Crystal Reports (81)
BizTalk (89)
Dot Net (2435)
Exchange Server (362)
SharePoint (720)
WCF (340)
MS Office Microsoft (6963)
LINQ Language-Integrated Query (317)
WPF (371)
TypeScript (144)
Microsoft Related AllOther (311)