>>
>>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.
If it's not broken, fix it until it is.
My Blog