Code :
;with cte10 (n) AS ( SELECT 1 union ALL SELECT 1 union ALL SELECT 1 union ALL SELECT 1 union ALL SELECT 1 union ALL SELECT 1 union ALL SELECT 1 union ALL SELECT 1 union ALL SELECT 1 union ALL SELECT 1 ), cte100 (n) AS (SELECT 1 FROM cte10 a, cte10 b), cte10k (n) AS (SELECT 1 FROM cte100 a, cte100 b), cte100m (dte) AS (SELECT top 50000 CONVERT(datetime,ROW_NUMBER() OVER (ORDER BY a.n) - 1) FROM cte10k a, cte10k b) SELECT a.dte, b.nombre FROM cte100m a LEFT JOIN @tmpTable b ON b.date = a.dte WHERE a.dte BETWEEN '2011-01-29' AND '2011-02-03'
|