>Hi All
>I am using a Sybase database but I would think the sql syntax should be almost the same. I have a requirement that I need to calculate fine for overweight trucks. The way the customer wants to do this is to have 1000 pound groups and each group has a progressively higher rate. For example, if a truck is 3500 lbs overweight then the calculation should be:
>
>1000 * .005 = $5.00
>1000 * .01 = 10.00
>1000 * .015 = 15.00
>500 * .02 = 10.00
>for a total of 40.00
>
>I tried to create a temp table to hold the rates but I I'm stumped on how to do a join. I was hoping for a SQL solution if it is possible.
>
>Thanks.
Check similar problem from my blog
http://blogs.lessthandot.com/index.php/DataMgmt/DataDesign/cte-and-hierarchical-queries (problem #1)
If it's not broken, fix it until it is.
My Blog