What i have ?
I table which contains reservation schdules for some given set of Items.
The Reservation schdules will be in the form of Data range i.e. start
date and end date. So i will have 3 field in the database Items, StDate,
EndDate. There can be multiple reservations for a single Item.
I am trying to write a stored operations which gets three input
parameters Item, D1, D2 for placing reservation on Item from D1 to D2.
For this purpose i have to parse through existing reservation scehdules
and verify if the i can reserve the Item between D1 and D2 or will it
overlap with existing schdules.
My stored procedure should return OK if there is no overlap otherwise
RESERVED if there is a overlap.