
August 30th, 2002, 12:08 AM
|
|
Gödelian monster
|
|
Join Date: Jul 1999
Location: Central Florida, USA
|
|
|
I don't understand how this is a problem. Any modern DBMS can do on-the-fly calculations in a query. So, if you have a formula that you use to populate your static lookup table, just translate that into the SQL query. The output can look identical to the end user, (make the Rates table a VIEW, instead of a static table). Now you don't have to update your Rates table every time you change a parameter.
|