September 23, 2011 at 12:43 pm
Sean Lange (9/22/2011)
TheOxblood (9/22/2011)
Yes i am planning to merge it..Yes it is for hotel reservation! 🙂
How can I allow per each room their status?
For example, RoomNo 10 is RESERVED at 7:00am-12:00pm
but 12:00pm onwards, the room is VACANT
How can i make status like that only for a period of time?
Well if there is no reservation during a certain block of time is MUST be vacant right? Do you really rent rooms by the hour? Most hotels have a standard checkin/checkout time. For example checkout is by 10am on your departing date and checkin time is after 3pm. This gives a nice block of time for house cleaning. Now conference rooms are a different animal entirely and should have their own data structure due to the drastic differences in renting guest rooms and conference rooms.
It's very common for hotels near airports to have no standard checkin and checkout times and to aim at letting a room more than once per day when there's a lot of traffic; a system that didn't cater for this would be restricting its range in the marketplace, many large groups want to use the same system in all their hotels and if you can't cope with the high turn over airport hotels you can't sell to that group even if it has only one or two such hotels amongst the hundreds that it runs (or, sometimes, if it only has ambitions to build or acquire such hotels but doesn't actually have any yet).
Tom
September 23, 2011 at 12:47 pm
L' Eomot Inversé (9/23/2011)
Sean Lange (9/22/2011)
TheOxblood (9/22/2011)
Yes i am planning to merge it..Yes it is for hotel reservation! 🙂
How can I allow per each room their status?
For example, RoomNo 10 is RESERVED at 7:00am-12:00pm
but 12:00pm onwards, the room is VACANT
How can i make status like that only for a period of time?
Well if there is no reservation during a certain block of time is MUST be vacant right? Do you really rent rooms by the hour? Most hotels have a standard checkin/checkout time. For example checkout is by 10am on your departing date and checkin time is after 3pm. This gives a nice block of time for house cleaning. Now conference rooms are a different animal entirely and should have their own data structure due to the drastic differences in renting guest rooms and conference rooms.
It's very common for hotels near airports to have no standard checkin and checkout times and to aim at letting a room more than once per day when there's a lot of traffic; a system that didn't cater for this would be restricting its range in the marketplace, many large groups want to use the same system in all their hotels and if you can't cope with the high turn over airport hotels you can't sell to that group even if it has only one or two such hotels amongst the hundreds that it runs (or, sometimes, if it only has ambitions to build or acquire such hotels but doesn't actually have any yet).
Excellent point Tom. It just proves that my mind must be in the gutter when dealing with motels renting rooms by the hour. 😛
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
Viewing 2 posts - 16 through 16 (of 16 total)
You must be logged in to reply to this topic. Login to reply