By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
SchId | FrequencyMinute |
---|---|
A | 480 |
B | 720 |
JobId | SchId | StartTime |
---|
JobId | SchId | StartTime |
---|---|---|
20210820120001 | A | 2021-08-20 08:00:00.000 |
20210820120002 | A | 2021-08-20 16:00:00.000 |
20210820120003 | A | 2021-08-21 00:00:00.000 |
20210820120004 | B | 2021-08-20 12:00:00.000 |
20210820120005 | B | 2021-08-21 00:00:00.000 |