add batch remove batch split batch comment selection show hidden batches hide batch highlight batch
db<>fiddle
donate feedback about
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