DECLARE @start INT, @end INT, @increment INT
SELECT @start=0, @end=100000000, @increment = 50000
;WITH NumberList ( Number ) AS
(
SELECT @start as Number
UNION ALL
SELECT Number + @increment
FROM NumberList
WHERE Number < @end
)
SELECT Number FROM NumberList OPTION (MAXRECURSION 0)
No comments:
Post a Comment