SitePoint Sponsor

User Tag List

Results 1 to 2 of 2
  1. #1
    SitePoint Member
    Join Date
    Nov 2008
    Posts
    1
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Question Hotel Price Search Between 2 Dates

    Dear!

    i stuck on one place where i can't find any solution. i need help from you people.

    Tables tblHotel and tblPrice

    tblPriceHotel_ID
    RoomType_ID
    DateFrom
    DateTo
    Single_Price
    Double_Price
    Triple_Price
    Child_Price
    ExtraBed_Price
    MealPlan

    Data in Records are
    DateFrom DateTo Single_Price Double_Price
    11/02/2008 11/30/2008 200 400
    12/01/2008 12/30/2008 300 500

    if Customer need to book the Room from Specified the Hotel and Room Type what will be the query. if he need room from 11/28/2008 till 12/02/2008 single room .?

    Please figure out this problem i will be very thankful to you.

  2. #2
    SQL Consultant gold trophysilver trophybronze trophy
    r937's Avatar
    Join Date
    Jul 2002
    Location
    Toronto, Canada
    Posts
    39,251
    Mentioned
    59 Post(s)
    Tagged
    3 Thread(s)
    have a look at this thread, it should help you --
    http://www.sitepoint.com/forums/showthread.php?t=411579
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL
    "giving out my real stuffs"


Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •