>>>
>>>Because of BETWEEN you're using. You need to use > MinWeight as George did.
>>
>>
>>Hmmm, And what if you have exact 5001?
>>The range is always one + the previous higher.
>
>>=MinWeight.
>
>The point was that your solution
>
>INNER JOIN @ttt TestMe ON Truck.overweight BETWEEN TestMe.minweight AND TestMe.maxweight
>
>used wrong INNER JOIN condition. You wanted to put PriorWeight here as well.
No, I don't want :-)
Why should I?
I want to get to this range where the Overweight belongs.
the PreviousAmount column contains the total of ALL previous ranges and I need to calculate only difference between the Overweight and MinRange.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.