Dates that intersect
- by MikeAbyss
Hi everyone,
I've been researching this problem for awhile now and I can't seem to come to a solution, hopefully someone here can help.
Currently I'm working with Microsoft SQL server management, I've been trying to do the following:
Previously, the old query would just return the results that fit between two dates
Heres the previous query:
SELECT e.Name, o.StartDate, o.EndDate
FROM dbo.Name e, dbo.Date o
WHERE
where e.Name = o.Name
and o.StartDate <= '2010-09-28 23:59:59'
and o.EndDate >= '2010-9-28 00:00:00'
and e.Name like 'A'
Example table that is produced after the query runs (The real table has a lot more rows obviously :P) :
Name Start End
A 2010-09-28 07:00:00 2010-09-28 17:00:00
A 2010-09-28 13:45:00 2010-09-28 18:00:00
A 2010-09-28 08:00:00 2010-09-28 16:00:00
A 2010-09-28 07:00:00 2010-09-28 15:30:00
However we need to change this, so that the query does the following:
find the dates that intersect for a day x
find the dates that don't intersect for a day x
I've found a real useful site regarding this
http://bloggingabout.net/blogs/egiardina/archive/2008/01/30/check-intersection-of-two-date-ranges-in-sql.aspx
However the date to compare against is inputted, mine on the other hand has to all dates that intersect/don't intersect.
Thanks for the help everyone.
