Date: Sat, 06 Jan 2001 14:15:48 -0800
Message-ID: <3A579914.9A793330_at_grad.csee.usf.edu>
[Quoted] 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.
Problems ?
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.
Result ?
My stored procedure should return OK if there is no overlap otherwise RESERVED if there is a overlap. Received on Sat Jan 06 2001 - 23:15:48 CET