select convert(varchar(10),dateadd(day,number,dateadd(day,-9,getdate())),120) as [date] from master..spt_values 
where datediff(day,dateadd(day,number,dateadd(day,-9,getdate())),getdate())>=0 and number>=0 and type=‘p‘