Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
thanksfor help
Posting Yak Master
106 Posts |
 Posted - 2006-06-27 : 19:51:15
|
| Hi,I have to create a table with rules to calculate certain values.Please advice me designing in the table and calling the function.I have materialcost and total overHead cost from a different table for each product and here is the rule for other cost. productid fixedoh(FOH) variableoverhead(VOH) Freightcost xyz TOH - FOH 42%*VOH 4%*MaterialcostABC 10%* TOH 90% * TOH 5%*MaterialCostFGH 4.5% * Materialcost 10%* MC 2%* MCI have some 100 products.Please advice me in implementing this in a efficient way.thanks in advance |
|
|
|
|
|
calculate formula