Re: Pricing Matrix

You can probably put this into a look-up table somethng like this:

CREATE TABLE Pricing
(start_distance INTEGER NOT NULL,
 end_distance INTEGER NOT NULL,
 CHECK (start_distance < end_distance),  skill_level INTEGER DEFAULT 0 NOT NULL

      CHECK(skill_level IN (0,1,2),
 attempt_cnt INTEGER DEFAULT 1 NOT NULL,  reward_amt DECIMAL(8,2) DEFAULT 0.00 NOT NULL,  item_price DECIMAL(8,2) DEFAULT 0.00 NOT NULL);

Fill out some of the table, and then add more rows as you get actual situations. I did something like this for packing & shippng mail order BBQ (Google the artcile at DM REVIEW). Received on Fri Oct 28 2005 - 15:32:09 CEST