I'm especially stayed aware of the article and I will get many benefits from it. Subsequently, thank you for sharing it.
Huh? I don't understand what you're saying. It doesn't seem to answer any of the questions asked.
Anyway, you might gain some insights into how to do "paging" in a select by reading this article:
https://www.microsoftpressstore.com/articles/article.aspx?p=2314819
However, this is no substitute for the insights you may be gaining by allowing us to help you with your particular problem. But to help you we need more information about your scenario than you have provided thus far.