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);