By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
19 rows affected
PID | StartTime | EndTime |
---|---|---|
13570 | 2018-03-01 00:00:00.000 | 2018-06-30 00:00:00.000 |
13570 | 2018-11-01 00:00:00.000 | 2019-01-31 00:00:00.000 |
13579 | 2018-04-01 00:00:00.000 | 2018-04-30 00:00:00.000 |
13579 | 2018-10-01 00:00:00.000 | 2018-11-30 00:00:00.000 |
PID | EID |
---|---|
13570 | 16 |
13570 | 23 |
13579 | 1 |
13579 | 2 |
13579 | 4 |
13579 | 5 |
13579 | 6 |
13579 | 7 |
13579 | 8 |
13579 | 13 |
13579 | 19 |
PID | EID | Source | ScheduleDate |
---|---|---|---|
13570 | 16 | StartDate | 2018-02-01 00:00:00.000 |
13570 | 23 | StartDate | 2018-03-01 00:00:00.000 |
13570 | 23 | EndDate | 2018-06-30 00:00:00.000 |
13570 | 16 | EndDate | 2018-06-30 00:00:00.000 |
13570 | 16 | StartDate | 2018-08-01 00:00:00.000 |
13570 | 16 | EndDate | 2018-08-31 00:00:00.000 |
13570 | 16 | StartDate | 2018-10-01 00:00:00.000 |
13570 | 23 | StartDate | 2018-11-01 00:00:00.000 |
13570 | 23 | EndDate | 2019-01-31 00:00:00.000 |
13570 | 16 | EndDate | 2019-02-28 00:00:00.000 |
13579 | 13 | StartDate | 2018-01-01 00:00:00.000 |
13579 | 1 | StartDate | 2018-01-01 00:00:00.000 |
13579 | 8 | StartDate | 2018-01-01 00:00:00.000 |
13579 | 5 | StartDate | 2018-02-01 00:00:00.000 |
13579 | 2 | StartDate | 2018-02-01 00:00:00.000 |
13579 | 4 | StartDate | 2018-02-01 00:00:00.000 |
13579 | 19 | StartDate | 2018-03-01 00:00:00.000 |
13579 | 7 | StartDate | 2018-03-01 00:00:00.000 |
13579 | 6 | StartDate | 2018-04-01 00:00:00.000 |
13579 | 5 | EndDate | 2018-04-30 00:00:00.000 |
13579 | 8 | EndDate | 2018-04-30 00:00:00.000 |
13579 | 2 | EndDate | 2018-05-31 00:00:00.000 |
13579 | 6 | EndDate | 2018-05-31 00:00:00.000 |
13579 | 8 | StartDate | 2018-06-01 00:00:00.000 |
13579 | 2 | StartDate | 2018-07-01 00:00:00.000 |
13579 | 19 | EndDate | 2018-07-31 00:00:00.000 |
13579 | 6 | StartDate | 2018-09-01 00:00:00.000 |
13579 | 19 | StartDate | 2018-10-01 00:00:00.000 |
13579 | 5 | StartDate | 2018-10-01 00:00:00.000 |
13579 | 6 | EndDate | 2018-11-30 00:00:00.000 |
13579 | 8 | EndDate | 2018-12-31 00:00:00.000 |
13579 | 2 | EndDate | 2019-01-31 00:00:00.000 |
13579 | 4 | EndDate | 2019-01-31 00:00:00.000 |
13579 | 19 | EndDate | 2019-02-28 00:00:00.000 |
13579 | 13 | EndDate | 2019-03-31 00:00:00.000 |
13579 | 7 | EndDate | 2019-03-31 00:00:00.000 |
13579 | 1 | EndDate | 2019-03-31 00:00:00.000 |
13579 | 5 | EndDate | 2019-03-31 00:00:00.000 |