• declare

    @StartDate date = '2015-01-01',

    @EndDate date = '2015-01-05'

    ;

    SELECT dateadd(DAY, x.rn, @StartDate)

    FROM

    ( SELECT (ROW_NUMBER() OVER(ORDER by object_id))-1 AS rn FROM sys.objects) AS x

    WHERE

    x.rn <= DATEDIFF(DAY,@StartDate,@enddate )

    ;