Talvin Singh - Thursday, February 15, 2018 2:00 PM
There is nothing in your table to guarantee the processing order within an ID. Without such a thing, this is doomed to failure.
If the goal is to process in order by both the ascending order of both the ID and the Value, then such a thing can be done quite easily but if you're trying for something like load balancing, then that won't work.
What is this for? Load Balancing? Packing Boxes/Bins? Assigning tasks by duration? What?
--Jeff Moden
Change is inevitable... Change for the better is not.