サンプルページ

;WITH days AS
(
    SELECT '2026-05-01' AS kado_dt UNION ALL
    SELECT '2026-05-02' UNION ALL
    SELECT '2026-05-03' UNION ALL
    SELECT '2026-05-04' UNION ALL
    SELECT '2026-05-05' UNION ALL
    SELECT '2026-05-06' UNION ALL
    SELECT '2026-05-07' UNION ALL
    SELECT '2026-05-08' UNION ALL
    SELECT '2026-05-09' UNION ALL
    SELECT '2026-05-10' UNION ALL
    SELECT '2026-05-11' UNION ALL
    SELECT '2026-05-12' UNION ALL
    SELECT '2026-05-13' UNION ALL
    SELECT '2026-05-14' UNION ALL
    SELECT '2026-05-15' UNION ALL
    SELECT '2026-05-16' UNION ALL
    SELECT '2026-05-17' UNION ALL
    SELECT '2026-05-18' UNION ALL
    SELECT '2026-05-19' UNION ALL
    SELECT '2026-05-20' UNION ALL
    SELECT '2026-05-21' UNION ALL
    SELECT '2026-05-22' UNION ALL
    SELECT '2026-05-23' UNION ALL
    SELECT '2026-05-24' UNION ALL
    SELECT '2026-05-25' UNION ALL
    SELECT '2026-05-26' UNION ALL
    SELECT '2026-05-27' UNION ALL
    SELECT '2026-05-28' UNION ALL
    SELECT '2026-05-29' UNION ALL
    SELECT '2026-05-30' UNION ALL
    SELECT '2026-05-31'
),
candidate AS
(
    SELECT
        x.shokuin_no,
        d.kado_dt
    FROM m_xxx x
    CROSS JOIN days d
),
target AS
(
    SELECT TOP (1200000)
        c.shokuin_no,
        c.kado_dt
    FROM candidate c
    WHERE NOT EXISTS
    (
        SELECT 1
        FROM m_work w
        WHERE w.shokuin_no = c.shokuin_no
          AND w.kado_dt = c.kado_dt
    )
    ORDER BY
        CHECKSUM(c.shokuin_no, c.kado_dt)
)
INSERT INTO m_work
(
    shokuin_no,
    kado_dt
)
SELECT
    shokuin_no,
    kado_dt
FROM target;

;WITH days AS
(
    SELECT '2026-05-01' AS kado_dt UNION ALL
    SELECT '2026-05-02' UNION ALL
    SELECT '2026-05-03' UNION ALL
    SELECT '2026-05-04' UNION ALL
    SELECT '2026-05-05' UNION ALL
    SELECT '2026-05-06' UNION ALL
    SELECT '2026-05-07' UNION ALL
    SELECT '2026-05-08' UNION ALL
    SELECT '2026-05-09' UNION ALL
    SELECT '2026-05-10' UNION ALL
    SELECT '2026-05-11' UNION ALL
    SELECT '2026-05-12' UNION ALL
    SELECT '2026-05-13' UNION ALL
    SELECT '2026-05-14' UNION ALL
    SELECT '2026-05-15' UNION ALL
    SELECT '2026-05-16' UNION ALL
    SELECT '2026-05-17' UNION ALL
    SELECT '2026-05-18' UNION ALL
    SELECT '2026-05-19' UNION ALL
    SELECT '2026-05-20' UNION ALL
    SELECT '2026-05-21' UNION ALL
    SELECT '2026-05-22' UNION ALL
    SELECT '2026-05-23' UNION ALL
    SELECT '2026-05-24' UNION ALL
    SELECT '2026-05-25' UNION ALL
    SELECT '2026-05-26' UNION ALL
    SELECT '2026-05-27' UNION ALL
    SELECT '2026-05-28' UNION ALL
    SELECT '2026-05-29' UNION ALL
    SELECT '2026-05-30' UNION ALL
    SELECT '2026-05-31'
),
candidate AS
(
    SELECT
        x.shokuin_no,
        d.kado_dt
    FROM m_xxx x
    CROSS JOIN days d
),
target AS
(
    SELECT TOP (1200000)
        c.shokuin_no,
        c.kado_dt
    FROM candidate c
    WHERE NOT EXISTS
    (
        SELECT 1
        FROM m_work w
        WHERE w.shokuin_no = c.shokuin_no
          AND w.kado_dt = c.kado_dt
    )
    ORDER BY
        CHECKSUM(c.shokuin_no, c.kado_dt)
)
INSERT INTO m_work
(
    shokuin_no,
    kado_dt
)
SELECT
    shokuin_no,
    kado_dt
FROM target;