>>
>>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.