how to check room availabilty in a hotel between two dates?

Question

I have a database of booking where we can book a room and new user want to check the room available between two dates or not?

Khargesh Rajput · Answer

thank u sir i got solution using your example

Hemant Srivastava · Answer

You could do something like in SQL : DECLARE @IS_ROOM_AVAIALABLE BIT; SET @IS_ROOM_AVAIALABLE = 0; IF NOT EXISTS ( SELECT ROOM_NUMBER FROM ROOM_BOOKING_TABLE WHERE BOOKING_DATE BETWEEN '2013-05-17 00:00:00.000' AND '2013-05-25 00:00:00.000' ) BEGIN @IS_ROOM_AVAIALABLE = 1 END above query is just an example. Modify the query as per your DB schema