[thelist] SQL Dates Problem

Burhan Khalid thelist at meidomus.com
Wed Apr 13 02:26:20 CDT 2005


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?


More information about the thelist mailing list