DECLARE @startDate DATE
DECLARE @endDate DATE
SET @startDate = '1/27/2014'
SET @endDate = '1/31/2014'
;WITH dates AS 
(
    SELECT @startdate as Date 
    UNION ALL
    SELECT DATEADD(d,1,[Date])
    FROM dates 
    WHERE DATE < @enddate
)
SELECT Date from dates

Watch live