July 31, 2009 at 2:51 pm
Hello All,
This must be an age old issue but I cannot find any information in any of my searches......
I am needing to design a db that will calculate the costs associated with varying products. Conceptually very simple except that most the products have multiple tiers based on the running total of the product you have previously ordered. In other words if I have order 10K or 20K or 30K (etc) of product X this year, I will recieve an associated % volume discount.
I am debating over storing all the tiers (and associated discounts) in one table and work the math through SQL or to have "Tier" tables (ie. Tier1, Teir2, etc...)
Any advice?
Thank you,
lmeinke
August 3, 2009 at 8:55 pm
Looks like you are wanting to calculate the volume discount for each customer in real-time as orders are processed, is this correct?
Could you provide us with DDL for your tables, some sample data, and expected results? If you need help with this, please read the first article in my signature block and follow the instructions. I'm sure you will get help quickly along with some tested code to help you out.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply