Declare @FullDateRange table(d datetime)
Declare @DayStart datetime
Declare @DayEnd datetime

set @DayStart = '2012-04-05' --DATEADD(day, -day(getdate())+1, getdate() )
set @DayEnd = '2012/4/20'

While @DayStart <= @DayEnd
Begin
    Insert into @DateRange values (@DayStart)
    set @DayStart[email protected]DayStart+1
End
Select d from @DateRange