摘要:
最近看了看Sql Server2008的Pivot 的行列转换sql帮助文档的实例:PIVOTSELECT VendorID,[250], [251], [256], [257], [260] FROM ( SELECT PurchaseOrderID , EmployeeID , VendorID FROM Purchasing.PurchaseOrderHeader ) p PIVOT( COUNT(PurchaseOrderID) FOR EmployeeID... 阅读全文