finding time slot

J

js

Hi,

I have an appointment table:
ID, UserID, ApptDate, ApptStart, ApptEnd, Status

and it will hold the appointment info for each user.

how to write a query so it will return the user's avaiable time slot in a
can customize duration(10 min or 15 min)?

Thansk....
 
Top