CTE - Sample

Declare @start int, @end int
Select @start=1, @end=999
;With NumberSequence( Number ) as
(
Select @start as Number
union all
Select Number + 1 from NumberSequence where Number < @end
)
Select * From NumberSequence Option (MaxRecursion 1000)