By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
13 rows affected
| id1 | id2 | flag | startdate | enddate | rank_t |
|---|---|---|---|---|---|
| 1 | 1 | y | 2007-01-10 00:00:00.000 | 2007-02-12 00:00:00.000 | 1 |
| 1 | 1 | y | 2007-02-13 00:00:00.000 | 2007-08-04 00:00:00.000 | 1 |
| 1 | 1 | y | 2007-08-05 00:00:00.000 | 2008-10-04 00:00:00.000 | 1 |
| 1 | 1 | n | 2008-10-05 00:00:00.000 | 2008-11-14 00:00:00.000 | 2 |
| 1 | 1 | n | 2008-11-15 00:00:00.000 | 2008-12-02 00:00:00.000 | 2 |
| 1 | 1 | n | 2008-12-08 00:00:00.000 | 2008-12-20 00:00:00.000 | 3 |
| 2 | 2 | y | 2012-01-10 00:00:00.000 | 2012-02-12 00:00:00.000 | 4 |
| 2 | 2 | y | 2012-02-13 00:00:00.000 | 2012-08-04 00:00:00.000 | 4 |
| 2 | 3 | y | 2012-01-10 00:00:00.000 | 2012-02-14 00:00:00.000 | 5 |
| 2 | 4 | y | 2012-08-14 00:00:00.000 | 2013-01-10 00:00:00.000 | 6 |
| 2 | 4 | y | 2013-01-15 00:00:00.000 | 2013-01-26 00:00:00.000 | 7 |
| 2 | 4 | y | 2013-01-27 00:00:00.000 | 2013-02-04 00:00:00.000 | 7 |
| 2 | 4 | n | 2016-03-14 00:00:00.000 | 2016-04-12 00:00:00.000 | 8 |