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 use of Active Control Property?
how to get printout between two dates informations in datareport in vb6.0
What does Query_unload event do in VB? Why we need Form _unload event?
What are the different types of Dialog Box?
Wat is d diff b/w API fns & Norm fns
Difference between Recordset and Resultsets.
How can objects on different threads communicate with one another?
What is the use of property page Wizard in ActiveX Control?
What is the use of Visual Basic Document file?
Different types of Passing Value?
HTML stands for What? Use of HTML ?
How would you create Visual basic Document file?
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)