Booking

[zeroonea]

i have a "Booking" table with 3 Column: BookingID (numeric - primary key) CheckInDate (datetime) CheckOutDate (datetime) - With input are indate and outdate, i want select out free date range in Booking table, like find free room for hotel booking Thanks.

[Christian Graus]

I don't see how you can do it with this, you don't have a room number in the table. Otherwise, you need to use the date functions in SQL to find which rooms are booked on a given date, or a given range, and return the other room numbers.

Christian Graus - Microsoft MVP - C++ Metal Musings - Rex and my new metal blog "I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )

[zeroonea]

Can you show me some db design and algorithm about hotel booking? i tried search a hours but... Thanks.

[Christian Graus]

I'm not really sure what to say. You should work through a book on database design, and think your problem through. The SQL Server help has all the info you need on how to use date functions.

Christian Graus - Microsoft MVP - C++ Metal Musings - Rex and my new metal blog "I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )

[dayanandip]

 :-O  :zzz:  :-\  :((  :-O  :omg: :mad::confused::~ :doh: