By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
6 rows affected
Technician | IntervalStart | IntervalEnd | WorkedMinutes |
---|---|---|---|
Tech1 | 2023-10-30 08:00:00.000 | 2023-10-30 08:15:00.000 | 10 |
Tech1 | 2023-10-30 08:15:00.000 | 2023-10-30 08:30:00.000 | 20 |
Tech1 | 2023-10-30 08:30:00.000 | 2023-10-30 08:45:00.000 | 5 |
Tech1 | 2023-10-30 09:00:00.000 | 2023-10-30 09:15:00.000 | 10 |
Tech1 | 2023-10-30 09:15:00.000 | 2023-10-30 09:30:00.000 | 15 |
Tech1 | 2023-10-30 09:30:00.000 | 2023-10-30 09:45:00.000 | 15 |
Tech2 | 2023-10-30 08:30:00.000 | 2023-10-30 08:45:00.000 | 15 |
Tech2 | 2023-10-30 08:45:00.000 | 2023-10-30 09:00:00.000 | 15 |
Tech2 | 2023-10-30 09:00:00.000 | 2023-10-30 09:15:00.000 | 10 |
Tech3 | 2023-10-30 08:00:00.000 | 2023-10-30 08:15:00.000 | 5 |
Tech3 | 2023-10-30 08:15:00.000 | 2023-10-30 08:30:00.000 | 5 |
Tech3 | 2023-10-30 08:30:00.000 | 2023-10-30 08:45:00.000 | 15 |
1000001 rows affected
TimeBlockStart | TimeBlockEnd |
---|---|
2000-01-01 00:00:00.000 | 2000-01-01 00:15:00.000 |
2000-01-01 00:15:00.000 | 2000-01-01 00:30:00.000 |
2000-01-01 00:30:00.000 | 2000-01-01 00:45:00.000 |
2000-01-01 00:45:00.000 | 2000-01-01 01:00:00.000 |
2000-01-01 01:00:00.000 | 2000-01-01 01:15:00.000 |
2000-01-01 01:15:00.000 | 2000-01-01 01:30:00.000 |
2000-01-01 01:30:00.000 | 2000-01-01 01:45:00.000 |
2000-01-01 01:45:00.000 | 2000-01-01 02:00:00.000 |
2000-01-01 02:00:00.000 | 2000-01-01 02:15:00.000 |
2000-01-01 02:15:00.000 | 2000-01-01 02:30:00.000 |
TaskID | Technician | StartDate | EndDate | TimeBlockStart | TimeBlockEnd |
---|---|---|---|---|---|
1 | Tech1 | 2023-10-30 08:05:00.000 | 2023-10-30 08:25:00.000 | 2023-10-30 08:00:00.000 | 2023-10-30 08:15:00.000 |
1 | Tech1 | 2023-10-30 08:05:00.000 | 2023-10-30 08:25:00.000 | 2023-10-30 08:15:00.000 | 2023-10-30 08:30:00.000 |
2 | Tech1 | 2023-10-30 08:20:00.000 | 2023-10-30 08:35:00.000 | 2023-10-30 08:15:00.000 | 2023-10-30 08:30:00.000 |
2 | Tech1 | 2023-10-30 08:20:00.000 | 2023-10-30 08:35:00.000 | 2023-10-30 08:30:00.000 | 2023-10-30 08:45:00.000 |
3 | Tech2 | 2023-10-30 08:30:00.000 | 2023-10-30 09:10:00.000 | 2023-10-30 08:30:00.000 | 2023-10-30 08:45:00.000 |
3 | Tech2 | 2023-10-30 08:30:00.000 | 2023-10-30 09:10:00.000 | 2023-10-30 08:45:00.000 | 2023-10-30 09:00:00.000 |
3 | Tech2 | 2023-10-30 08:30:00.000 | 2023-10-30 09:10:00.000 | 2023-10-30 09:00:00.000 | 2023-10-30 09:15:00.000 |
4 | Tech1 | 2023-10-30 09:05:00.000 | 2023-10-30 09:45:00.000 | 2023-10-30 09:00:00.000 | 2023-10-30 09:15:00.000 |
4 | Tech1 | 2023-10-30 09:05:00.000 | 2023-10-30 09:45:00.000 | 2023-10-30 09:15:00.000 | 2023-10-30 09:30:00.000 |
4 | Tech1 | 2023-10-30 09:05:00.000 | 2023-10-30 09:45:00.000 | 2023-10-30 09:30:00.000 | 2023-10-30 09:45:00.000 |
5 | Tech3 | 2023-10-30 08:10:00.000 | 2023-10-30 08:20:00.000 | 2023-10-30 08:00:00.000 | 2023-10-30 08:15:00.000 |
5 | Tech3 | 2023-10-30 08:10:00.000 | 2023-10-30 08:20:00.000 | 2023-10-30 08:15:00.000 | 2023-10-30 08:30:00.000 |
6 | Tech3 | 2023-10-30 08:30:00.000 | 2023-10-30 08:45:00.000 | 2023-10-30 08:30:00.000 | 2023-10-30 08:45:00.000 |
TaskID | Technician | Minutes | StartDate | EndDate | TimeBlockStart | TimeBlockEnd |
---|---|---|---|---|---|---|
1 | Tech1 | 10 | 2023-10-30 08:05:00.000 | 2023-10-30 08:25:00.000 | 2023-10-30 08:00:00.000 | 2023-10-30 08:15:00.000 |
1 | Tech1 | 10 | 2023-10-30 08:05:00.000 | 2023-10-30 08:25:00.000 | 2023-10-30 08:15:00.000 | 2023-10-30 08:30:00.000 |
2 | Tech1 | 10 | 2023-10-30 08:20:00.000 | 2023-10-30 08:35:00.000 | 2023-10-30 08:15:00.000 | 2023-10-30 08:30:00.000 |
2 | Tech1 | 5 | 2023-10-30 08:20:00.000 | 2023-10-30 08:35:00.000 | 2023-10-30 08:30:00.000 | 2023-10-30 08:45:00.000 |
3 | Tech2 | 15 | 2023-10-30 08:30:00.000 | 2023-10-30 09:10:00.000 | 2023-10-30 08:30:00.000 | 2023-10-30 08:45:00.000 |
3 | Tech2 | 15 | 2023-10-30 08:30:00.000 | 2023-10-30 09:10:00.000 | 2023-10-30 08:45:00.000 | 2023-10-30 09:00:00.000 |
3 | Tech2 | 10 | 2023-10-30 08:30:00.000 | 2023-10-30 09:10:00.000 | 2023-10-30 09:00:00.000 | 2023-10-30 09:15:00.000 |
4 | Tech1 | 10 | 2023-10-30 09:05:00.000 | 2023-10-30 09:45:00.000 | 2023-10-30 09:00:00.000 | 2023-10-30 09:15:00.000 |
4 | Tech1 | 15 | 2023-10-30 09:05:00.000 | 2023-10-30 09:45:00.000 | 2023-10-30 09:15:00.000 | 2023-10-30 09:30:00.000 |
4 | Tech1 | 15 | 2023-10-30 09:05:00.000 | 2023-10-30 09:45:00.000 | 2023-10-30 09:30:00.000 | 2023-10-30 09:45:00.000 |
5 | Tech3 | 5 | 2023-10-30 08:10:00.000 | 2023-10-30 08:20:00.000 | 2023-10-30 08:00:00.000 | 2023-10-30 08:15:00.000 |
5 | Tech3 | 5 | 2023-10-30 08:10:00.000 | 2023-10-30 08:20:00.000 | 2023-10-30 08:15:00.000 | 2023-10-30 08:30:00.000 |
6 | Tech3 | 15 | 2023-10-30 08:30:00.000 | 2023-10-30 08:45:00.000 | 2023-10-30 08:30:00.000 | 2023-10-30 08:45:00.000 |
Technician | TimeBlockStart | Minutes |
---|---|---|
Tech1 | 2023-10-30 08:00:00.000 | 10 |
Tech1 | 2023-10-30 08:15:00.000 | 20 |
Tech1 | 2023-10-30 08:30:00.000 | 5 |
Tech1 | 2023-10-30 09:00:00.000 | 10 |
Tech1 | 2023-10-30 09:15:00.000 | 15 |
Tech1 | 2023-10-30 09:30:00.000 | 15 |
Tech2 | 2023-10-30 08:30:00.000 | 15 |
Tech2 | 2023-10-30 08:45:00.000 | 15 |
Tech2 | 2023-10-30 09:00:00.000 | 10 |
Tech3 | 2023-10-30 08:00:00.000 | 5 |
Tech3 | 2023-10-30 08:15:00.000 | 5 |
Tech3 | 2023-10-30 08:30:00.000 | 15 |