SQL Server从当前日期获取最近的12个月统计没数据月份补0

with months as ( 
      select dateadd(day, 1, eomonth(getdate(), -1)) as yyyymm
      union all 
      select  dateadd(month, -1, yyyymm)
      from months m
      where yyyymm >= dateadd(month, -11, getdate())
     ) 
select CONVERT(VARCHAR(7),m.yyyymm) ym,coalesce(sum(ltp.productWeight),0) cn from months m
LEFT JOIN loader_four_check_task lt on (lt.inspectedTime >= m.yyyymm and lt.inspectedTime < dateadd(month,1, m.yyyymm))
left join loader_four_check_task_product ltp on lt.id = ltp.taskId
group by m.yyyymm
order by m.yyyymm;