By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
8 rows affected
| ID | StartDate_A | EndDate_A | StartDate_B | EndDate_B |
|---|---|---|---|---|
| 1 | 2024-01-01 | 2024-01-10 | null | null |
| 1 | 2024-01-10 | 2024-01-15 | 2024-01-10 | 2024-01-11 |
| 1 | 2024-01-10 | 2024-01-15 | 2024-01-12 | 2024-01-18 |
| 1 | 2024-01-15 | 2024-01-20 | 2024-01-12 | 2024-01-18 |
| 2 | 2024-01-01 | 2024-01-10 | 2024-01-10 | 2024-01-10 |
| 2 | 2024-01-10 | 2024-01-20 | 2024-01-10 | 2024-01-10 |