CTE as a sequence generator

CteSequence.sql

declare @start int = 0;
declare @end int = 1000;

with numberSequence
as (
    select @start as nextValue
    union all
    select nextValue + 1
    from numberSequence
    where nextValue + 1 < @end
)

select *, dateadd(day, nextValue, cast('2000-01-01' as date)) as dateValue
from numberSequence
option (maxrecursion 32767);