I'm writing a conference room booking system for our corporate intranet and
I want to create a stored procedure that takes the start datetime, finish
datetime and room number as input parameters and then either returns a table
showing the conflicting reservations or adds the data into the table.
The problem that I have is encapsulating the logic to find if there are any
conflicting reservations. I've tried several methods with temp tables and
all sorts but one always slips through and at this point my head is nearly
Has anyone done something like this before ? ...