By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,842 Members | 2,368 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,842 IT Pros & Developers. It's quick & easy.

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

P: 2
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,EnTime 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,EnTime 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
Aug 29 '08 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.