select *
into #temp
from calendar
select yr, row_number() over (order by start_dt) as rowNumber into #dt from #temp
declare @max int
select @max = count(rowNumber)
from #dt
declare @rowNum int
set @rowNum = 1
while @rowNum <= @max
begin
--print @rowNum
select yr + @rowNum as yr from #dt
set @rowNum = @rowNum + 1
end
drop table #temp
drop table #dt
go
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/23155850/viewspace-631460/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
【原创】T-SQL SP 中常见设置
请登录后发表评论
登录
全部评论
