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‘
原文：http://www.cnblogs.com/hllive/p/7120383.html