SQL Server 2008 R2的枢轴

Question

是否有可能以提供实施例：

1. 基本：具有预定义
数据和列
2. 更先进：随着动态数据和列预先定义
3. 专家用法：带动态数据和动态列

谢谢

Answer 1

1. 基本例子：

   USE AdventureWorks2008R2; GO SELECT DaysToManufacture, AVG(StandardCost) AS AverageCost FROM Production.Product GROUP BY DaysToManufacture;

2. 更高级的例子

   -- 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;

3. 专家举例：

   USE AdventureWorks2008R2; GO SELECT VendorID, [250] AS Emp1, [251] AS Emp2, [256] AS Emp3, [257] AS Emp4, [260] AS Emp5 FROM (SELECT PurchaseOrderID, EmployeeID, VendorID FROM Purchasing.PurchaseOrderHeader) p PIVOT ( COUNT (PurchaseOrderID) FOR EmployeeID IN ([250], [251], [256], [257], [260]) ) AS pvt ORDER BY pvt.VendorID;

希望它可以帮助