how to display display available or unavailable time slots in SQL Server

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • IndSaif
    New Member
    • Sep 2007
    • 2

    how to display display available or unavailable time slots in SQL Server

    Hi,
    I have a query to ask, please if possible try to answer it.
    I have one table contails all booking records that contain ID,StartTime,En Time and Value. here my StartTime default started from 8:00 A.M and EndTime will be 23:45 ,My query is if i have a booking slot from
    ID,StartTime,En Time and Value
    1- 9:15 - 10:30 - XYZ
    2- 14:45 - 16:15- XYZ
    etc.. data can be vary in real application..
    Can we dispaly available time slot for value XYZ .. since time started from 8:00 and Ended 23:45 ..
    Thank in Adv
    saif
Working...