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)