thank you very much Jack! that helps,

Matt, NYC

Wow - thanks!! didn't know about COALESCE. YOU GUYS ROCK!

Thanks!

lol - i wish i could have developed this solution!! - all you guys

Yeah! Got it working in SQL Server! Thanks to Barry, Matt, Jeff, and this forum!

DECLARE @sql nvarchar(4000)

SET @sql = 'SELECT ID, Name, Address

FROM

(SELECT ID,...

I believe:

The .Net Datagrid with custom paging WILL need to connect to the DB every time the user changes the page. In fact, with "default" paging the Datagrid still...

ok, sorry about that - I will revisit the thread.. tx again,matt

ALTER PROCEDURE [dbo].[Paging1]

(

@startRowIndex int,

@maximumRows int

)

AS

DECLARE @first_id int, @startRow int

-- A check can be added to make sure @startRowIndex isn't > count(1)

-- from...

Yes, Barry, it is the same - my mistake.. i was comparing it to the code of Matt Miller earlier in this thread - his code seems quite a bit...

Another forum posted this (for SQL Server 2005 only):

CREATE PROCEDURE dbo.ShowLog

@PageIndex INT,

@PageSize INT

AS

BEGIN

WITH LogEntries AS (

SELECT ROW_NUMBER() OVER...

Thanks for the info Matt: I've whittled it down to this:

CREATE PROCEDURE Paging_Cursor (

@PageNumber int = 1,

@PageSize int = 10)

AS

--===== Declare the local variables

DECLARE @PageNum INT --What page...

Thank you very much for your help Matt!

p.s. is there any part of the above sql that i don't need? e.g. /*Find the @pk type*/ ...

Well, you guys are way more advanced than me!! It's impressive. I'm trying to code an ASP.NET datagrid page with custom paging, table only will have 10,000 records...

Thanks Jeff - would be good to see that thread..

thanks a lot Barry!