WITH NUMBERS(
DAYS
) AS (
SELECT CONVERT(DATE, '20100218') AS DAYS
UNION ALL
SELECT DATEADD(DAY, 1, DAYS)
FROM NUMBERS
WHERE DATEDIFF(DAY, DAYS, CONVERT(DATE, '20181015')) > 0
)
SELECT DAYS FROM NUMBERS ORDER BY DAYS DESC
OPTION (MAXRECURSION 4000)
날짜 뽑는 재귀쿼리 예제
'Coding > MSSQL' 카테고리의 다른 글
| [MSSQL] 페이징처리 (0) | 2018.10.24 |
|---|---|
| [MSSQL] MSSQL 날짜 변환표(GETDATE, CONVERT) (0) | 2018.10.24 |