I had a long discussion with the client, that helped clarify the relationship on the tables, and it worked out fine.

Part of my original question was the appearance of multiple...

Thanks for this. I'll move it into production.

I've used the separate call to calculate @MinWeight immediately. That was a "well, duh" moment for me, that I should have seen earlier. Thanks.

I'm not certain about where you changed...