select identity(int,0,1) as num into # from sysobjects
select
a.fullname,
dateadd(mm,a.numMonth*b.num) as [date],
a.countvalue
from
表 a,
# b
where
dateadd(mm,a.numMonth*b.num,a.startdate) between a.startdate and a.enddate
select identity(int,0,1) as num into # from sysobjects
select
a.fullname,
dateadd(mm,a.numMonth*b.num) as [date],
a.countvalue
from
表 a,
# b
where
dateadd(mm,a.numMonth*b.num) between a.startdate and a.enddate