recursive CTE to get next 10 days

readme.md

unfortunately you can't fill in 2-3 years worth of days with CTE in sql server

postres.sql

;with recursive t(n) as (  SELECT now() n  union all  select n + '1 day'  from t where n < '2033-01-01') select * from t limit 10;

-- also this works
;with recursive t(n) as (  SELECT now() n  union all  select n + '1 day'  from t) select * from t limit 1000;

sqlserver.sql

;with t as (  SELECT getdate() n  union all  select DATEADD(dd, 1, n)  from t where n < '2033-01-01') select TOP 10 * from t;

-- interesting that this works:
;with t as (  SELECT getdate() n  union all  select DATEADD(dd, 1, n)  from t  ) select TOP 101 * from t;
-- but this not
;with t as (  SELECT getdate() n  union all  select DATEADD(dd, 1, n)  from t  ) select TOP 102 * from t;