PIVOT无法正常工作'''附近的语法不正确 [英] PIVOT not working Incorrect syntax near ')'

问题描述

T-SQL代码:

SELECT iCarrierInvoiceDetailsID, [1],[2],[3]
FROM [GroundEDI].[dbo].[tblCarrierInvoiceDetails]
PIVOT(MAX(dTotalCharge) FOR iCarrierInvoiceHeaderID IN ([1],[2],[3]))AS P

错误:

第15级，州1，第3行的消息102，
')'附近的语法不正确.

Msg 102, Level 15, State 1, Line 3
Incorrect syntax near ')'.

知道为什么我会收到此错误吗?

Any idea why I am getting this error?

推荐答案

您似乎正在尝试直接从表本身而不是数据透视表中选择数据透视表列.您将需要执行以下操作:

It looks like you are trying to directly select the pivot columns from the table itself and not the pivot. You will need to do something like this:

SELECT p.[1],p.[2],p.[3] 
FROM 
(SELECT iCarrierInvoiceHeaderID
       ,dTotalCharge
FROM [GroundEDI].[dbo].[tblCarrierInvoiceDetails]) t
PIVOT(MAX(dTotalCharge) FOR iCarrierInvoiceHeaderID IN ([1],[2],[3])
)AS P;

这篇关于PIVOT无法正常工作'''附近的语法不正确的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！