|
Posted by Steven Blair on 11/14/05 17:15
My problem is trying to calcuate whether a room is booked during a date
period.
I have a table with two columns (Start and End date).
I need some SQL code to calculate whether a room is booked during a date
range.
e.g.
The booking entry is:
Start
21/11/2005
End
25/11/2005
Any help on this would be appreciated.
The End Date indicates the last night of the stay.
Regards,
Steven
*** Sent via Developersdex http://www.developersdex.com ***
Navigation:
[Reply to this message]
|