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.
16 rows affected
Employee StartDate EndDate Position PosType
1 2016-12-10 2017-01-30 30 P
1 2017-01-31 2017-02-02 20 A
1 2017-02-03 2017-03-28 30 P
1 2017-03-29 2017-03-31 20 A
1 2017-04-01 2017-04-18 30 P
1 2017-04-19 2017-04-21 20 A
1 2017-04-22 2017-06-21 30 P
1 2017-06-22 2017-06-23 20 A
1 2017-06-24 2017-06-28 30 P
1 2017-06-29 2017-06-30 20 A
1 2017-07-01 2017-10-02 30 P
1 2017-10-03 2017-10-06 20 A
1 2017-10-07 2018-02-11 30 P
1 2018-02-12 2018-03-02 20 A
1 2018-03-03 2018-07-18 30 P
1 2018-07-19 2018-07-20 20 A
1 2018-07-21 2018-09-03 30 P
1 2018-09-04 2018-09-05 20 A
1 2018-09-06 2018-11-11 30 P
1 2018-11-12 2018-11-13 20 A
1 2018-11-14 2018-11-18 30 P
1 2018-11-19 2018-11-20 20 A
1 2018-11-21 9999-12-31 30 P