Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
dude131
Starting Member
6 Posts |
Posted - 2005-06-29 : 14:51:58
|
Hello - I've been trying for the last couple days to revise this MS KB article (http://support.microsoft.com/?kbid=245074) code to work for my database.Their tables are:Room -- table nameIDRoomNumBookingIDRoomArrivalCheckoutStatements are:Rooms ReservedPARAMETERS [Please enter arrival date] DateTime, [Please enter checkout date] DateTime;SELECT Booking.Room, Booking.Arrival, Booking.CheckoutFROM BookingWHERE (((Booking.Arrival) Between [Please enter arrival date] And [Please enter checkout date]-1)) Or ((([Checkout]-1) Between [Please enter arrival date] And [Please enter checkout date])) Or (((Booking.Arrival)<[Please enter arrival date]) And (([Checkout]-1)>[Please enter checkout date]-1));Rooms AvailableSELECT Rooms.RoomNumFROM Rooms LEFT JOIN [Rooms Reserved] ON Rooms.RoomNum=[Rooms Reserved].RoomWHERE ((([Rooms Reserved].Room) Is Null));My Tables Are:BookingBookDateStartBookDateEndBookCustIDBookPropID >> Same as Room Number (Unique)BookHotelIDBookSubTotalBookGSTBookPSTBookSurchargeBookAdultsBookChildrenBookNumberofRoomsBookNotesBookNumPropertyPropID >> Same as Room Number (Unique)PropTypeIDPropTypePropRatePropDescPropMaxAdultsPropMaxChildrenPropImg1PropImg2PropImg3PropImg4PropImg5PropRoomAmtPropHotelIDMy Statements Are:PARAMETERS [Please enter arrival date] DateTime, [Please enter checkout date] DateTime;SELECT Booking.BookPropID, Booking.BookStartDate, Booking.BookEndDateFROM BookingWHERE (((Booking.BookStartDate) Between [Please enter arrival date] And [Please enter checkout date]-1)) Or ((([BookEndDate]-1) Between [Please enter arrival date] And [Please enter checkout date])) Or (((Booking.BookStartDate)<[Please enter arrival date]) And (([BookEndDate]-1)>[Please enter checkout date]-1));SELECT Prop.PropIDFROM Property LEFT JOIN [Rooms Reserved] ON Property.PropID=[Rooms Reserved].PropIDWHERE ((([Rooms Reserved].PropID) Is Null));-- I cannot get it right -- any ideas where I'm going wrong? |
|
nathans
Aged Yak Warrior
938 Posts |
Posted - 2005-06-29 : 16:01:33
|
>> to work for my database.Access or SQL Server ? |
|
|
dude131
Starting Member
6 Posts |
Posted - 2005-06-30 : 12:55:33
|
access |
|
|
|
|
|