Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2004
    Posts
    7

    finding available seats in booking system

    Hello,

    I have a custom system, that's comparable to booking people on buses. What I need is some sort of tool for finding available time/date for buses, so a person afterwards manually can book a group of people on one or more buses.

    I have a fixed number of buses, say 30, which all have the same amount of seats, say 50. These buses can be booked by any group of people (1-nearly infinite) for anything from an hour up to many days.

    Currently I'm using a solution from TransactionSQL Cookbook from O'Reillys, which basically uses a Pivot table for each day and then chews through every bus for every single day. It works very well, but when the number if buses, seats or days in the report increases, it's no longer an optimal solution.

    I feel I'm re-inventing the wheel here, there are zillion of systems like this in airlines, trains etc, so there must be some algorithms for this out there.... :-)


    Thanks in advance for your time!
    Nikolai

  2. #2
    Join Date
    Dec 2003
    Location
    Canada
    Posts
    710

  3. #3
    Join Date
    Jan 2004
    Posts
    7
    thanks!! :-)

Posting Permissions

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