Finding an arbitrary number of records
As part of a more complicated workflow, I need to take a list of 250k items and split them up in 250 lists of 1000 items each. So how do you 'find' an arbitrary number of records? Is it possible to say find me the first thousand records that fit this other criteria (would likely have a marker field set to 1 for all records that have already been handled).
I can't even find anything close to get me started.