SQL 报表 生成月份临时表
1 if OBJECT_ID(‘tempdb..#temptblAllYearMonth‘) is not null 2 drop table #temptblAllYearMonth 3 4 declare @StartDate DATE = ‘20210101‘ 5 declare @EndDate DATE = ‘20211201‘; 6 7 WITH cte as ( 8 select @StartDate dateCol union all select DATEADD(MONTH, 1, dateCol) 9 from cte where dateCol < @EndDate 10 ) 11 select CONVERT(varchar(6), dateCol, 112) dateCol, 0 as ToTal 12 13 into #temptblAllYearMonth from cte; 14 15 --查询数据 16 select * from #temptblAllYearMonth
原文：https://www.cnblogs.com/allen-zqw/p/15150993.html