22,209
社区成员
发帖
与我相关
我的任务
分享
CREATE TABLE dbo.#b(col varchar(20),starttime int,endtime int)
insert into #b(col,starttime,endtime) VALUES(1,2,8);
drop table #b;
CREATE TABLE dbo.#b(col varchar(20),starttime int,endtime int)
insert into #b(col,starttime,endtime) VALUES(1,2,8);
SELECT col ,
b.number AS starttime ,
endtime
FROM #b
JOIN ( SELECT *
FROM master.dbo.spt_values
WHERE type = 'P'
) b ON b.number BETWEEN starttime AND endtime
drop table #b;