摘要: 最近看了看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... 阅读全文
posted @ 2012-08-18 10:40 Angkor--:-- 阅读(206) 评论(4) 推荐(0) 编辑