CTEで日付の一覧を作る

gistfile1.sql

with l_date(salesdate) as (
    select convert(datetime, '2012/02/01', 111)
union all
    select dateadd(d, 1, salesdate)
    from l_date
    where salesdate <= convert(datetime, '2012/02/28', 111)
)
select * from l_date