I have a set of dates. These dates are not continuous. Any ideas for designing a query for the required output? I have a list of “From Date” to set of “To Dates” as listed below.
The earliest From Date is 18-Feb-08
The last To Date is 11-Sep-08
Date From ----- Date To
18-Feb-08 ----- 30-Apr-08
01-May-08 ----- 03-Sep-08
04-Sep-08 ----- 11-Sep-08
13-Mar-08 ----- 30-Apr-08
01-May-08 ----- 11-Sep-08
02-Mar-08 ----- 04-Mar-08
15-Mar-08 ----- 19-Mar-08
02-Jun-08 ----- 11-Jun-08
09-Jul-08 ----- 11-Jul-08
18-Jul-08 ----- 20-Jul-08
27-Jul-08 ----- 29-Jul-08
31-Mar-08 ----- 30-Apr-08
01-May-08 ----- 05-Sep-08
18-Feb-08 ----- 29-Apr-08
31-Mar-08 ----- 30-Apr-08
01-May-08 ----- 01-Jun-08
12-Jun-08 ----- 08-Jul-08
12-Jul-08 ----- 17-Jul-08
21-Jul-08 ----- 26-Jul-08
30-Jul-08 ----- 04-Aug-08
I want a query that will output the dates as shown in the order below without a break from 18-Feb-08 to 11-Sep-08
Date From Date To
18-Feb-08 ----- 01-Mar-08
02-Mar-08 ----- 04-Mar-08
05-Mar-08 ----- 12-Mar-08
13-Mar-08 ----- 14-Mar-08
15-Mar-08 ----- 19-Mar-08
20-Mar-08 ----- 30-Mar-08
31-Mar-08 ----- 29-Apr-08
30-Apr-08 ----- 30-Apr-08
01-May-08 ----- 01-Jun-08
02-Jun-08 ----- 11-Jun-08
12-Jun-08 ----- 08-Jul-08
09-Jul-08 ----- 11-Jul-08
12-Jul-08 ----- 17-Jul-08
18-Jul-08 ----- 20-Jul-08
21-Jul-08 ----- 26-Jul-08
27-Jul-08 ----- 29-Jul-08
30-Jul-08 ----- 04-Aug-08
05-Aug-07 ----- 03-Sep-08
04-Sep-08 ----- 05-Sep-08
06-Sep-08 ----- 11-Sep-08
Any help will be appreciated. Thanks in advance.