By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
19 rows affected
M_ID | Y_ID | T_ID | E_ID | BeginDate | EndDate |
---|---|---|---|---|---|
123457 | 4 | 2 | 3 | 01/05/2017 00:00:00 | 31/10/2017 00:00:00 |
134560 | 5 | 8 | 3 | 01/04/2017 00:00:00 | 31/08/2017 00:00:00 |
134560 | 5 | 8 | 3 | 01/05/2017 00:00:00 | 31/08/2017 00:00:00 |
134560 | 5 | 8 | 3 | 01/10/2017 00:00:00 | 31/10/2017 00:00:00 |
134560 | 5 | 8 | 3 | 01/11/2017 00:00:00 | 30/11/2017 00:00:00 |
135678 | 3 | 6 | 2 | 01/01/2017 00:00:00 | 31/03/2017 00:00:00 |
135678 | 3 | 6 | 2 | 01/04/2017 00:00:00 | 30/06/2017 00:00:00 |
135678 | 3 | 6 | 2 | 01/10/2017 00:00:00 | 31/10/2017 00:00:00 |
135678 | 3 | 6 | 2 | 01/11/2017 00:00:00 | 31/12/2017 00:00:00 |
135709 | 2 | 7 | 1 | 01/01/2017 00:00:00 | 31/03/2017 00:00:00 |
135709 | 2 | 7 | 1 | 01/04/2017 00:00:00 | 30/06/2017 00:00:00 |
135709 | 2 | 7 | 3 | 01/01/2017 00:00:00 | 31/01/2017 00:00:00 |
135709 | 2 | 7 | 3 | 01/02/2017 00:00:00 | 30/04/2017 00:00:00 |
135709 | 2 | 7 | 3 | 01/05/2017 00:00:00 | 31/05/2017 00:00:00 |
135709 | 2 | 7 | 3 | 01/07/2017 00:00:00 | 31/08/2017 00:00:00 |
135709 | 2 | 7 | 3 | 01/10/2017 00:00:00 | 31/10/2017 00:00:00 |
135709 | 2 | 7 | 3 | 01/12/2017 00:00:00 | 31/12/2017 00:00:00 |
135709 | 5 | 8 | 1 | 01/02/2017 00:00:00 | 30/04/2017 00:00:00 |
135709 | 5 | 8 | 1 | 01/04/2017 00:00:00 | 31/07/2017 00:00:00 |
M_ID | Y_ID | T_ID | E_ID | StartDate | EndDate |
---|---|---|---|---|---|
123457 | 4 | 2 | 3 | 01/05/2017 00:00:00 | 31/10/2017 00:00:00 |
134560 | 5 | 8 | 3 | 01/04/2017 00:00:00 | 31/08/2017 00:00:00 |
134560 | 5 | 8 | 3 | 01/10/2017 00:00:00 | 30/11/2017 00:00:00 |
135678 | 3 | 6 | 2 | 01/01/2017 00:00:00 | 30/06/2017 00:00:00 |
135678 | 3 | 6 | 2 | 01/10/2017 00:00:00 | 31/12/2017 00:00:00 |
135709 | 2 | 7 | 1 | 01/01/2017 00:00:00 | 30/06/2017 00:00:00 |
135709 | 2 | 7 | 3 | 01/01/2017 00:00:00 | 31/05/2017 00:00:00 |
135709 | 2 | 7 | 3 | 01/07/2017 00:00:00 | 31/08/2017 00:00:00 |
135709 | 2 | 7 | 3 | 01/10/2017 00:00:00 | 31/10/2017 00:00:00 |
135709 | 2 | 7 | 3 | 01/12/2017 00:00:00 | 31/12/2017 00:00:00 |
135709 | 5 | 8 | 1 | 01/02/2017 00:00:00 | 31/07/2017 00:00:00 |