I have 5 records as below
Code: Select all
Id Date End date
1234 2017-08-09 2017-08-10
1234 2017-08-10 2017-08-11
1234 2017-08-11 2017-08-12
1234 2017-08-12 2017-08-13
1234 2017-08-13 2099-12-31
Moderators: chulett, rschirm, roy
Code: Select all
Id Date End date
1234 2017-08-09 2017-08-10
1234 2017-08-10 2017-08-11
1234 2017-08-11 2017-08-12
1234 2017-08-12 2017-08-13
1234 2017-08-13 2099-12-31