tsql - Beginner: Checking availability on a booking table in SQL -
I'm writing a job vacancy database for a little fun (and to learn and learn T-SQL / SQL Server) This is in my application table so far. application_id name from the interviewer location_ id ---------------------- ------------- ------------------------------------- ------------- ---------------------- 1 Blogs All Saunders 100 2008-12-25 00:00: 00 2008-12-26 00:00:00 2 Barry White Issac Hayes 100 2008-12-29 00:00:00 2008-12-30 00:00:00 It's easy enough to find out that for these dates Which booking has been done; A simple selection statement will easily get them well. I still have the only problem that it is to find out that bookings are not included during the day. I want to do a search on the following table to see what dates are available in the room with the location_ID 100 "2008-12- 25 00:00:00" and "2008-12-30 00:00:00" And have returned it that no interview is being conducted from 27th to 28th in the room. I'm sure this is very easy, b...