Générer une liste de valeurs arbitraires (format date)

DECLARE @start date = '20150525' ;
DECLARE @end date = getdate() ;

WITH dates AS (
    SELECT   CONVERT(VARCHAR(10), @start, 112)  AS date
    UNION ALL
    SELECT   CONVERT(VARCHAR(10), dateadd(DD,1,date) , 112)
    FROM  dates
    WHERE date < @end
)
SELECT *
FROM dates
OPTION (MAXRECURSION 0);