I wouldn't do it that way as it puts business rules into the database. Create a CalculateShipping class. Pull back all the rates you may need and then loop through as needed locally.
>Hi,
>
>I need some help on how to calculate the freight charge on a package.
>
>I have a table like this :
>
>
ID, WeightLimit, FreightRate, FuelRate
>1, 1, 12, 1.2
>2, 50, 1, 0.1
>3, 99999, 0.5, 0.05
>
>If I have a package weighing 2 kgs, then the total freight is calculated as:
>
>1st kg = 12
>2nd kg = 1
>Total = 13
>
>or if I had a package weighing 52 kgs:
>1st kg = 12
>next 49 kgs = 49 * 1 = 49
>next 2kgs = 2 * 0.5 = 1
>Total = 62
>
>Is there a way to achieve this in SQL?
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer