May be it helps you..
SELECT slot_no , entry_date, exit_date
FROM TBMORDER
WHERE (entry_date < '10/12/2012') AND (exit_date > '10/12/2012') AND (slot_no = 9;)
Using above query you can check for slot no 9 is booked for not and its entry date and exit date also for your given date
Thanks
Asp.Net/C#.Net Help[
^]
Hemant Singh