T-SQL code:
T-SQL代码：
SELECT iCarrierInvoiceDetailsID, [1],[2],[3]
FROM [GroundEDI].[dbo].[tblCarrierInvoiceDetails]
PIVOT(MAX(dTotalCharge) FOR iCarrierInvoiceHeaderID IN ([1],[2],[3]))AS P
SELECT iCarrierInvoice
阅读背景：
PIVOT不工作'）'附近的语法不正确
来源：互联网
分享到：
