create table #T (产品名 nvarchar(20),次数 int) insert into #T values('A1',5) insert into #T values('A2',5) insert into #T values('A3',5)
create table #TT(计划开始日期 datetime) insert into #TT values('2022-01-01 08:00') insert into #TT values('2022-01-01 10:00') insert into #TT values('2022-01-01 12:00') insert into #TT values('2022-01-01 14:00') WITH T AS ( S ELECT 产品名,计划开始日期,次数 FROM #T, #TT union all s elect 产品名,计划开始日期,次数-1 from T where 次数 > 1 ) s elect * from t
|