我有以下查询,我的行总计将显示NULL作为标题和总和将是准确的。我尝试使用带有case语句的分组似乎没什么用。我在这个网站上的搜索没有提供有效的解决方案。如果我使用以下解决方案,它会给我一个错误,说“多部分标识符无法绑定”
CASE
WHEN GROUPING(B.Department) = 1 THEN 'Total'
ELSE [B.Department]
END [B.Department],
Select
B.Department
,
SUM(CASE datepart(month, [Created on]) WHEN 1 Then 1 ELSE 0 END) AS 'January'
SUM(CASE datepart(month, [Created on]) WHEN 2 Then 1 ELSE 0 END) AS 'February'
SUM(CASE datepart(month, [Created on]) WHEN 3 Then 1 ELSE 0 END) AS 'March'
.
.
SUM(CASE datepart(year, [Created on]) WHEN 2018 Then 1 ELSE 0 END) AS 'YTD'
FROM [Table Cases] A
left join [Table Departments] B
On A=Department = B.Dept
GROUP BY B.Department WITH ROLLUP
谢谢 :-)
发布于 2018-10-24 15:27:36
通常,这通过使用COALESECE()
或ISNULL()
例如来解决
选择
当你按部门进行汇总时,你真的需要一个左联盟吗?
https://stackoverflow.com/questions/-100005096
复制相似问题