[thelist] SQL Dates Problem

[Ken Schaefer]

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
: From: thelist-bounces at lists.evolt.org [mailto:thelist-
: bounces at lists.evolt.org] On Behalf Of Burhan Khalid
: Subject: Re: [thelist] SQL Dates Problem
: 
: Ken Schaefer wrote:
: >
: >
: > : As if this wasn't causing me enough problems -- there is a new
: > : requirement that an event can span more than one hall.  So if there is
: > : an event that is going to be two weeks long and takes place in halls
: > : 5,6,7 -- I need to find the earliest date where all three halls have
: 14
: > : days free.  So now I'm back to square one.
: >
: > I think this can be added to the above.
: >
: > You'll need to do the test for all three halls (using an AND) and you'll
: need
: > to test to ensure that a.EndDate (end of an event for one hall) and
: > b.StartDate (start of the next event for the given hall) happens to be
: within
: > or greater than the span for the other two tests.
: 
: Ken:
: 
:    As I chew on your SQL, can you explain the above bit? What do you
: mean by "happens to be within or greater than the span for the other two
: tests"? What other two tests?
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

One for each hall. 

Now that I think about it, this could be a little bit trickier, but I'm not
sure. I'll need to whip up a test, and get back to you, but that's a job for
tomorrow.

Cheers
Ken

--
www.adOpenStatic.com/cs/blogs/ken