sql - 具有额外列名的动态数据透视表

Question

我需要数据透视表，按月对数据列进行分组，并提前 +6 个月添加。我的代码如下。Pivot 应该[TrE_TwrKod], [TrE_TwrNazwa], [TrN_RokMiesiac] 作为列名返回，其中[TrN_RokMiesiac]是 range -18 to +12 months。{[201911], [201912], ..., [202203], [202204]}值应该是SUM([TrE_Ilosc]) group by [TrE_TwrKod] and month。有什么提示吗？亲切的问候，L。

SELECT [TrE_TwrKod], [TrE_TwrNazwa] ,SUM([TrE_Ilosc]) AS Sprzedaz_TrE_Ilosc,
    [TrN_RokMiesiac]
FROM [xl_pst].[CDN].[TraElem]
INNER JOIN [CDN].[TraNag]
ON TrN_GIDTyp=TrE_GIDTyp AND TrN_GIDNumer=TrE_GIDNumer
WHERE [CDN].[TraNag].[TrN_RokMiesiac] 
BETWEEN cast(convert(varchar(6),DATEADD(MM,-18, GETDATE()),112)AS INT)
AND cast(convert(varchar(6),
    DATEADD(MM, +6[enter image description here][1], GETDATE()),112)AS INT) 
AND [TrE_Ilosc] > 0
GROUP BY [TrE_TwrKod], [TrE_TwrNazwa],[TrN_RokMiesiac]
ORDER BY [TrE_TwrKod], [TrN_RokMiesiac];

标签： sqldynamicpivotnamesextra