SELECT CONVERT(NVARCHAR(10), DateAdd(day,number,'2014-09-29'),120) AS GroupDay FROM master..spt_values WHERE type = 'p' AND number <= DateDiff(day,'2014-09-29','2014-10-29')
GroupDay 2014-09-29 2014-09-30 2014-10-01 2014-10-02 2014-10-03 2014-10-04 2014-10-05 2014-10-06 2014-10-07 2014-10-08 2014-10-09 2014-10-10 2014-10-11 2014-10-12 2014-10-13 2014-10-14 2014-10-15 2014-10-16 2014-10-17 2014-10-18 2014-10-19 2014-10-20 2014-10-21 2014-10-22 2014-10-23 2014-10-24 2014-10-25 2014-10-26 2014-10-27 2014-10-28 2014-10-29