Blog

-- 2024년 달력 생성 및 요일 포함 쿼리
DECLARE @StartDate DATE = '2024-01-01';
DECLARE @EndDate DATE = '2024-12-31';

WITH DateCTE AS (
    SELECT @StartDate AS [Date]
    UNION ALL
    SELECT DATEADD(DAY, 1, [Date])
    FROM DateCTE
    WHERE [Date] < @EndDate
)

SELECT
    Convert(varchar(10),[Date],112) AS [sdate],
    --DATENAME(WEEKDAY, [Date]) AS [DayOfWeek]
    DATEPART(WEEKDAY, [Date]) AS [yoil],
    'N' AS del_yn, '' AS date_text
FROM DateCTE
OPTION (MAXRECURSION 366); 

등록

INSERT INTO [holiday_tbl] (sdate, yoil, del_yn, date_text) 
SELECT
    Convert(varchar(10),[Date],112) AS [sdate],
    --DATENAME(WEEKDAY, [Date]) AS [DayOfWeek]
    DATEPART(WEEKDAY, [Date]) AS [yoil],
    'N' AS del_yn, '' AS date_text
FROM DateCTE
OPTION (MAXRECURSION 366);