我有以下脚本来生成枢轴输出,但是我正在努力处理 2 个元素:
1- 在输出的左侧显示所有用户 ID 的输出。
2- 在脚本中放置一个 where 子句来限制输出。尝试了 100 个选项。任何帮助,将不胜感激
SELECT 'invoices.USERID' AS totalvalue,
[1], [2]
FROM
(SELECT invoices.USERID, [total],PAYERCODE
FROM invoices
where invoices.userid = 41
) AS SourceTable
PIVOT
(
SUM([total])
FOR PAYERCODE IN ([1], [2])
) AS PivotTable;
所以我希望它看起来像
在我整个周末搞砸之前,任何帮助将不胜感激。
Y 轴是一个字符串 'invoices.USERID'
并删除 WHERE invoices.userid = 41
SELECT USERID AS totalvalue,[1],[2]
FROM
(SELECT invoices.USERID, [total],PAYERCODE
FROM invoices
--where invoices.userid = 41
) AS SourceTable
PIVOT
(
SUM([total])
FOR PAYERCODE IN ([1], [2])
) AS PivotTable;
本文收集自互联网,转载请注明来源。
如有侵权,请联系[email protected] 删除。
我来说两句