Thank you, Kevin. I will read the article and see if it applies.
>Dmitry, this article is a bit dated, but back in 2007 I wrote about this topic and presented an approach for paging result sets.
>
>Now...at the time, SQL Server didn't have an OFFSET/FETCH like it does in 2012 - but I presented an approach using an ASP.NET GridView and a stored proc that received an offset index and a count of # of rows to fetch. I have a full example, if you want to read through it.
>
>
http://www.codemag.com/Article/0703041>
>Don't know if it will solve your problems...but if you're looking to only show a certain # of rows, and allow someone to jump forward or backward (N) number of rows at a time based on an order, you might want to give it a read.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham