Hi all,
i would like to split and create new records by predefined time ranges. I got two tables, one for the periods, one for the actions.
New records should be created when an action overlaps with one or more time ranges (see table below)!
QVW is attached.
I'm grateful for any ideas!
Best regards!
| ID_NEW | StartTime | EndTime |
| 1_1 | 05:37:00 | 08:00:00 |
| 1_2 | 08:01:00 | 09:10:00 |
| 2_1 | 08:45:00 | 12:00:00 |
| 2_2 | 12:01:00 | 12:15:00 |
| 3_1 | 13:05:00 | 14:00:00 |
| 3_2 | 14:01:00 | 18:00:00 |
| 3_3 | 18:01:00 | 21:10:00 |
