software development blog
WITH
DATE_RANGE as (
SELECT
[date]=GETDATE()
UNION ALL
SELECT DATEADD(day,1,[date])
FROM DATE_RANGE
WHERE DATEADD(day,1,[date])<=DATEADD(day,10,GETDATE())
)
SELECT * FROM DATE_RANGE
Hiç yorum yok:
Yorum Gönder