I'm having a bit of problems with these tables...
TableCost ( TableCostId int, Cost numeric, MonthsId int )
Taxes ( Percentt numeric, MonthsId int )
I have to calculate a new value by getting the biggest
Taxes.MonthsId that do not exceed the
TableCost.MonthsId (for each row).
For example, if I have the following registers:
(1,10,1), (2,5,3), (3,12,7), (4,17,8), (5,22,11)
(55,1), (60,2), (65,6), (70,10), (75,12)
To calculate the TaxedCost of the
first row of the TableCost -> 10*55 Second row -> 5*60 Third row ->12*65 Fourth row -> 17*65 Fifth row -> 22*70
The select must return the following fields
I've tought of declaring a table variable... storage the Taxes values on it, runs a normal select on the TableCost table and looping each of its rows calculating the TaxedCost after the select.
Any ideas of improve this query?