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 do you mean by provider?
It is possible to access Text (x.txt) files? Explain.
Is a foo VBX/DLL available as shareware/freeware?
What is the difference between adodc and adodb in vb?
what is the property to resize a label control according to your caption?
What are the types of API Types?
what is different from edit and updates?
Which language is used in visual basic?
How to declare Dll Procedure?
Is visual basic c#?
Which property of textbox cannot be changed at runtime?
How would you define and use a Boolean in VB?
2 Answers Asteroid Software Services, Microsoft,