我正在尝试在SQL Server 2012中运行我的第一个动态透视。
我用于动态透视的临时表#temp
如下所示。
YearMonth Agreement nr Discount
------------------------------------
201303 123 1
201303 12 0
201304 1 0
我运行这段代码,但它不起作用:
DECLARE @DynamicPivotQuery AS NVARCHAR(MAX)
DECLARE @ColumnName AS NVARCHAR(MAX)
--Get distinct values of the PIVOT Column
SELECT @ColumnName = ISNULL(@ColumnName + ',', '') + QUOTENAME(YearMonth )
FROM (SELECT DISTINCT YearMonth FROM #FINAL) AS Courses
--Prepare the PIVOT query using the dynamic
SET @DynamicPivotQuery =
N'SELECT [Agreement nr],YearMonth , ' + @ColumnName + '
FROM #FINAL
PIVOT(
COUNT(agreement nr)
FOR YearMonth IN (' + @ColumnName + ') AS PVTTable'
--Execute the Dynamic Pivot Query
EXECUTE @DynamicPivotQuery;
我收到的错误信息是:
我错过了什么吗?'FOR YearMonth IN ([201403]) AS PVTTable'不是一个有效的标识符。