Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-12-02 : 08:15:43
|
| mbryant24 writes "I am trying to create meeting room booking system. I have to find overlapping dates for multi-day events. For example, I have a meeting that is scheduled for a certain for Three straight days at the same time - 11/22-11/24 3:00-3:30 on each day.I would like to be able find the overlap for a certain room for either one day or multiple days at those times when inserting a new meeting room request." |
|
|
Bustaz Kool
Master Smack Fu Yak Hacker
1834 Posts |
Posted - 2004-12-04 : 15:45:16
|
| Can you clarify your requirements? I'm not clear on what it is you want.Also, can you supply the schema you are using for this data?HTHLet X = {All sets s such that s is not an element of s}(X element of X) ==> (X not element of X)(X not element of X) ==> (X element of X)(Bertrand Russell Paradox) |
 |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2004-12-04 : 15:58:33
|
i think he wants to see if the room he needs is already booked for that time.but we'd need table structure to give him a correct answer...Go with the flow & have fun! Else fight the flow  |
|
|
|
|
|
|
Meeting Room Booking for Multi-Day Events