回答:declare @index intset @index = 11while @index >= 0begininsert into #tmpygzlselect cast(month(DATEADD(MONTH, DATEDIFF(MONTH, 0, dateadd(month,-@index,getdate())), 0)) as varchar(50)) +'月' as 月份,'全市' 县区,count(distinct(工单编号)) as "故障量",(13-@index) as 序号from #tmpgj where 1=1and 字段 >=DATEADD(MONTH, DATEDIFF(MONTH, 0, dateadd(month,-@index,getdate())), 0)and 字段< DATEADD(MONTH, DATEDIFF(MONTH, 0, dateadd(month,-@index+1,getdate())), 0)set @index = @index -1end这个是月趋势图的代码