here it is the query using F_TABLE_DATESELECT execution = d.[DATE], [CHECK] = DATEADD(DAY, n.num, d.[DATE]) FROM F_TABLE_DATE('2008-01-01', '2020-12-31') d CROSS JOIN ( SELECT num = 0 UNION ALL -- same DAY (Wed) SELECT num = 3 UNION ALL -- the sat SELECT num = 7 UNION ALL -- 1 week FROM Wed SELECT num = 10 UNION ALL -- 1 week FROM Sat SELECT num = 28 UNION ALL -- 4 week FROM Wed SELECT num = 31 -- 4 week FROM Sat ) nWHERE d.WEEKDAY_NAME = 'Wed'ORDER BY execution, [CHECK]
KH[spoiler]Time is always against us[/spoiler]