>Easy :-)
>You just need to join two table by Trucks.Overweight BETWEEN MinWeight AND Maxweight
>And then to sum that additional column to (Trucks.Overweight - MinWeight + 1) * FineRate
>
>Something like this (NOT TESTED!!! and all in T-SQL, sorry)
>

>DECLARE @Truck TABLE (id int, overweight int);
>insert @truck values (1,3500);
>insert @truck values (1,2500);
>insert @truck values (2,1500);
>insert @truck values (2,500);
>insert @truck values (1,500);
>
>DECLARE @ttt table (minweight int, maxweight int, fineamount numeric(8,4), PreviousAmount numeric(8,4));
>insert @ttt values (   1,     1000,0.005, 0)
>insert @ttt values (1001,     2000,0.01 ,1000*0.005)
>insert @ttt values (2001,     3000,0.015,1000*0.005+1000*0.01)
>insert @ttt values (3001,     4000,0.02 ,1000*0.005+1000*0.01+1000*0.015)
>insert @ttt values (4001,     5000,0.025,1000*0.005+1000*0.01+1000*0.015+1000*0.02)
>insert @ttt values (5001,999999999,0.03 ,1000*0.005+1000*0.01+1000*0.015+1000*0.02+1000*0.025)
>
>SELECT Truck.*, TestMe.PreviousAmount + (Truck.overweight-TestMe.minweight+1)*fineamount AS Something
>FROM @Truck Truck
>INNER JOIN @ttt TestMe ON Truck.overweight BETWEEN TestMe.minweight AND TestMe.maxweight
>

>

The inner join condition is incorrect in this code, but the idea is good....