title: Select available times for each saved date in SQL
body: <p>I am having a system where user can book the rooms for different dates and time slots, where in database we will save the <code>bookingdate</code>, <code>StartTime</code> and <code>EndTime</code> as per below table design, where minimum interval between <code>startime</code> and <code>endtime</code> will be 30 minutes.                </p>
  
  <pre><code>MeetingDate -&gt; Date (values like '6/4/2014','6/5/2014')
  StartTime -&gt; Time (values like '10:00:00', '11:00:00')
  EndTime -&gt; Time (values like '13:00:00', '14:00:00')
  </code></pre>
  
  <p>I need to check periodically check the available time slots for all the dates considering a time limit of 08:00 AM - 06:00 PM, for that i have created the below cte table which will list out all the times slots with an interval of 30 minutes                     </p>
  
  <p>Now i want to filter the available times for each date by filtering
  booked times by matching it with the <code>'TimeSlots'</code> ste table created
  above, or if any other approach is also ok </p>
  
  <p>If any need further info pls do let me know</p>