>>BTW, looks like you may use much simpler idea than my cte solution was doing. Just divide the difference in weights by 1000 and join (cross apply) with numbers table to produce records and also use rate*Number to get the rate increase.
>>
>>Do you see the idea or need more information to work it out?
>
>Are you sure Sybase has CTEs and/or CROSS APPLY?
>I don't :-)
No, I don't think they do (or I can try to google), but we can use a join for the N.Number between 1 and ceiling(Overweight/1000) as our join condition.
Do you see the idea I have for the problem - I haven't thought it through completely, but I see how it should work.
If it's not broken, fix it until it is.
My Blog