The sum of all SQL Server matter that exist,
and the space in which all SQL Server events
occur or could occur.
Welcome to SQL Server Universe.com Sign in | Join | Help
in
Home SS SLUG Forums Articles Photos Downloads
SQL Server Universe.com » SQL Server Components » T-SQL » Re: Need help to write SQL

Need help to write SQL

Last post 10-30-2007, 18:34 by Chandana N. Athauda. 1 replies.
Sort Posts: Previous

  • Need help to write SQL

    		 08-28-2007, 23:20

    Hungry_Minder
    • Joined on 07-02-2007
    • Posts 3
    • Points 0
    • Top 50 Contributor
    Reply Quote

    Hi,

    I have a hotel reservation system.I need to implement Check availability (Room checking) function for the project.But I dont understand how do I start and write SQL for this.

    Here is table structure


    TblRooms
    ------------
    RoomsID
    RoomName
    Note
    unitPrice
    SeasonalOffers

    TblReservation
    ----------------
    ReservationID
    ArrivalDate
    DepartureDate
    ArrivalFrom
    FlightNo
    PurposeOfVisit

    TblRoomsInventory
    -------------------
    RoomsInventoryID
    TotalRooms
    BookedRooms

     

    Should I add more fields or table to implement this or this is enough .please any body can help me

     

  • Re: Need help to write SQL

    		 10-30-2007, 18:34

    Chandana N. Athauda
    • Joined on 03-27-2007
    • Colombo
    • Posts 48
    • Points 0
    • Top 10 Contributor
      Male
    Reply Quote
    Are you still looking for the answer? If so, then I can give a try… Wink
    My Logo


    If we were supposed to write perfect code, debugger wouldn’t have been created.

View as RSS news feed in XML

(Best viewed with a resolution of more than 1024 * 768)
Powered by Community Server, by Telligent Systems