;with c
as
(select 0 as col
union all
select col+1 from c where col<100)
select
convert(varchar(7),dateadd(m,-col,getdate()),120)
from C
inner join t1 on c.col<=t1.bb
as
(select 0 as col
union all
select col+1 from c where col<100)
select
convert(varchar(7),dateadd(m,-col,getdate()),120)
from C
inner join t1 on c.col<=t1.bb
from 表1 a,(
select 1 as n union all
select 2 union all
select 3 union all
select 4 union all
select 5 union all
select 6 union all
select 7 union all
select 8 union all
select 9 union all
select 10 union all
select 11 union all
select 12
) as t
where a.bb<= t.n