SqlServer 统计1-12月份 每个月的数据 放一行（用于图表展示）

SqlServer 统计1-12月份 每个月的数据 （用于图表展示）

图标插件 的 X 轴展示月份 Y 轴 展示数据

SELECT 
SUM(CASE WHEN datepart(month,emr_createTime) =1 THEN 1 ELSE 0 END ) AS '1月',
SUM(CASE WHEN datepart(month,emr_createTime) =2 THEN 1 ELSE 0 END ) AS '2月',
SUM(CASE WHEN datepart(month,emr_createTime) =3 THEN 1 ELSE 0 END ) AS '3月',
SUM(CASE WHEN datepart(month,emr_createTime) =4 THEN 1 ELSE 0 END ) AS '4月',
SUM(CASE WHEN datepart(month,emr_createTime) =5 THEN 1 ELSE 0 END ) AS '5月',
SUM(CASE WHEN datepart(month,emr_createTime) =6 THEN 1 ELSE 0 END ) AS '6月',
SUM(CASE WHEN datepart(month,emr_createTime) =7 THEN 1 ELSE 0 END ) AS '7月',
SUM(CASE WHEN datepart(month,emr_createTime) =8 THEN 1 ELSE 0 END ) AS '8月',
SUM(CASE WHEN datepart(month,emr_createTime) =9 THEN 1 ELSE 0 END ) AS '9月',
SUM(CASE WHEN datepart(month,emr_createTime) =10 THEN 1 ELSE 0 END ) AS '10月',
SUM(CASE WHEN datepart(month,emr_createTime) =11 THEN 1 ELSE 0 END ) AS '11月',
SUM(CASE WHEN datepart(month,emr_createTime) =12 THEN 1 ELSE 0 END ) AS '12月'
FROM TbaleA  AS a
INNER JOIN TbaleB AS b ON a.id= b._Id
WHERE datepart(year,emr_createTime) =datepart(year,getdate())
group BY b.eql_Location