Showing posts with label Use of Pivot in SQL Server. Show all posts
Showing posts with label Use of Pivot in SQL Server. Show all posts

Thursday, 21 March 2013

Use of Pivot in SQL Server

Written By:- Isha Malhotra
Our Website:-Tech Altum
Use of Pivot in SQL Server
When we need to format the result according to user‘s need then we use pivot. Pivot provides us facilities to use the column data as column.
For example:-
Check the following data in table:-


Figure 1