SQL Server PIVOT

PIVOT: CONVERT the table into a new table 

Example

USE AdventureWorks2008R2 ;

GO

SELECT DaysToManufacture, AVG(StandardCost) AS AverageCost

FROM Production.Product

GROUP BY DaysToManufacture;

Result

DaysToManufacture          AverageCost

0                          5.0885

1                          223.88

2                          359.1082

4                          949.4105

-- Pivot table with one row and five columns

SELECT 'AverageCost' AS Cost_Sorted_By_Production_Days,

[0], [1], [2], [3], [4]

FROM

(SELECT DaysToManufacture, StandardCost

    FROM Production.Product) AS SourceTable

PIVOT

(

AVG(StandardCost)

FOR DaysToManufacture IN ([0], [1], [2], [3], [4])

) AS PivotTable;

Result

Cost_Sorted_By_Production_Days    0         1         2           3       4       

AverageCost                       5.0885    223.88    359.1082    NULL    949.4105

Pasted from: <http://technet.microsoft.com/zh-cn/library/ms177410(v=sql.105).aspx>