-
Comparing Date Spans
I need to write a query that would compare 2 pairs of dates.A start and end date for both rows. The second start date needs to be >= to the first end date. That is, there should be no gaps between the second start date and first end date.
ex: Good Scenario
First Start: 10/01/2006 First End: 12/31/2007
Second Start: 11/30/2007 Second End: 01/31/2008
ex: Bad Scenario
First Start: 10/01/2006 First End: 12/31/2007
Second Start: 02/01/2008 Second End: 04/30/2008
-
Can you post table schema?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|