As a few others have said, you aren't being exactly clear as to what it is that you are actually trying to do.
Perhaps if you explain a little about what you are trying to do, we might be able to help more.
You seem to be leading us down a path, but it is your path. It might be that a different path is much more efficient.
It sounds like you are trying to page though some data. Top 10, then 11-20, 21-30 etc. right?
Ok that's fine, but WHY? This sounds like application level issues, not DB issues. Is there a reason why you think you can only process 10 rows at a time?