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 |