I am working on schedule appointment booking application and want user want to schedule any appoint in between any time if any appoint already schedule.
For example one appoint is schedule from 10:30 to 11:30.
if new appoint is schedule like 11:00 to 11:30 than it should inform user time slot already book.
pls guide me how to write query to check time slot is available for new appointment or note. I have table which has start date/Time and end date/time filed.