mjmetz
07-30-02, 12:31
| Hi, I am looking for some help in a database I知 designing for SQL Server 2000. It is a straight forward payment application but the part I知 wrestling with is that is needs to user customizable so the end users be establish new math rules via the application on calculating payments. The math will be simple: (+, - , *, /) but different vendors may have multiple calculations performed in determining the final payment. I would like to have the calculations performed on the database side instead of in a component. I think they will be faster done in the database, correct me if I知 wrong. Abstractly speaking, I値l start with a VendorID and a base amount, apply calculations to that (could be 1, could 5 five) and have an end result. Between that and how best to handle the users adding their own calculations is what I知 struggling with. Could anyone point me in the right direction? Thanks Michael |