MSSqlServer 日期统计默认Count为0

1.数据Cout进行年月日查询一般有数据可以显示统计出来但是有的数据一个月统计每一天只有一两条 在页面显示的图表中进行展示绑定必须是30个 key value形式 没有对应时间的要给添加默认值

下面是具体sql:

a.年-12月

select * from 
(
select   CONVERT(varchar(7),  DATEADD(MM,-11,GETDATE()), 120 ) as 'Name' , 0 as 'Value'
union
select   CONVERT(varchar(7),  DATEADD(MM,-10,GETDATE()), 120 ) as 'Name' , 0 as 'Value'
union
select   CONVERT(varchar(7),  DATEADD(MM,-9,GETDATE()), 120 ) as 'Name' , 0 as 'Value'
union
select   CONVERT(varchar(7),  DATEADD(MM,-8,GETDATE()), 120 ) as 'Name' , 0 as 'Value'
union
select   CONVERT(varchar(7),  DATEADD(MM,-7,GETDATE()), 120 ) as 'Name' , 0 as 'Value'
union
select   CONVERT(varchar(7),  DATEADD(MM,-6,GETDATE()), 120 ) as 'Name' , 0 as 'Value'
union
select   CONVERT(varchar(7),  DATEADD(MM,-5,GETDATE()), 120 ) as 'Name' , 0 as 'Value'
union
select   CONVERT(varchar(7),  DATEADD(MM,-4,GETDATE()), 120 ) as 'Name' , 0 as 'Value'
union
select   CONVERT(varchar(7),  DATEADD(MM,-3,GETDATE()), 120 ) as 'Name' , 0 as 'Value'
union
select   CONVERT(varchar(7),  DATEADD(MM,-2,GETDATE()), 120 ) as 'Name' , 0 as 'Value'
union
select   CONVERT(varchar(7),  DATEADD(MM,-1,GETDATE()), 120 ) as 'Name' , 0 as 'Value'
union
select   CONVERT(varchar(7),  DATEADD(MM, 0,GETDATE()), 120 ) as 'Name' , 0 as 'Valu