What is the use of PIVOT Table in Sql server with suitable examples?

Posted by Prabu_Spark under Sql Server on 5/2/2013 | Points: 10 | Views : 3574 | Status : [Member] | Replies : 2
Hi sir,
Tell me the use of PIVOT Table in Sql server with suitable examples. Kindly give me the solution for this problem.

With regards,
J.Prabu.
[Email:prbspark@gmail.com]



Responses

Posted by: Satyapriyanayak on: 5/2/2013 [Member] [MVP] Silver | Points: 25

Up
0
Down
http://blog.sqlauthority.com/2008/05/22/sql-server-pivot-table-example/
http://www.codeproject.com/Articles/22008/C-Pivot-Table
http://www.sqlmag.com/article/tsql3/create-pivoted-tables-in-3-steps
http://chandoo.org/wp/2009/08/19/excel-pivot-tables-tutorial/
http://msdn.microsoft.com/en-us/library/ms177410%28v=sql.105%29.aspx
http://www.simple-talk.com/sql/t-sql-programming/creating-cross-tab-queries-and-pivot-tables-in-sql/

If this post helps you mark it as answer
Thanks

Prabu_Spark, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Niladri.Biswas on: 5/2/2013 [Member] Platinum | Points: 25

Up
0
Down
Please read: http://msdn.microsoft.com/en-us/library/ms177410(v=sql.105).aspx

Best Regards,
Niladri Biswas

Prabu_Spark, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response