Another way you can generate a range of dates is by utilizing a Tally Table to create the dates between the range:
Declare   @FromDate   Date = '2014-04-21',
          @ToDate     Date = '2014-05-02'
;With 
   E1(N) As (Select 1 From (Values (1), (1), (1), (1), (1), (1), (1), (1), (1), (1)) DT...