pivoting ????? sounds new or sounds old am pretty much sure all of us DO NOT knw the true power of "PIVOTING'. infact when d is question was questioned on us hardly ne one was able ta answer n believe me der were about 65 students who were gr8 technology freaks! so i hope u find this post interesting and useful coz even if you do nt find it useful NOW , u ll be using a lot of PIVOTING once u get EMPLOYED (pivoting helps you ta finish your job with gr8ter efficiency n yaaay tats one way ta impress ur boss !)
ll post how to pivot soon ( sorry yaar bc with semester exams :))
so b4 we go n learn how pivoting is done lets look on what it is ???
SO HEY WHAT IS PIVOTING ??
The pivot transformation operator enables you to transform a single row of attributes into multiple rows in an efficient manner.
TRANSLATION (LOL)
so pivoting is a mechanism by which u can get the information you need from huge collection of data by jus few intelligent clicks n manipulation of rows :)
SO WHEN TO DO PIVOTING????
so lets suppose you have a record which has about 100 coloums but just looking at the first 20 data records, you can see the data is boring. It’s enough to make you roll your eyes and fall asleep.
so here when your problem is just to anwer questions related to the table of data and you want to represent them in a easy to understand manner you go for PIVOTING.
ll post how to pivot soon ( sorry yaar bc with semester exams :))

