thanks Barry - I'm having trouble with all this stuff - i would think there has to be a generally best way to code custom paging in asp.net, but I'm...

someone in another forum said the dynamic sql version (the 2nd one) was clearly faster/better

another article compares four methods:

http://www.codeproject.com/KB/aspnet/PagingLarge.aspx

Conclusion: "The methods performed in the following order, starting from the best one - RowCount, Cursor, Asc-Desc and Subquery."

sorry, here is the code:

CREATE PROCEDURE [dbo].[usp_PageResults_NAI]

(

@startRowIndex int,

@maximumRows int

)

AS

DECLARE @first_id int, @startRow int

-- A check can be added to make...