>Hi, Glenn,
>
>I decided to give this a crack - I'm guessing you're getting an error message on the second CTE.
>
>The first CTE (InvRows) can be used in a SELECT, or INSERT/UPDATE/DELETE statement - but I'm not sure a CTE can be used in a subsequent CTE. (The problem is that the error message I'm getting is a general syntax one, so I can't tell for certain).
>
>Anyway, instead of the code that starts with "With InvRecs AS"....you might want to try:
>
>

>SELECT * FROM (
>      SELECT uidclient, uid, description, 
>            ROW_NUMBER() OVER (order by uid) as RowNumber 
>       FROM  Invrows ) InvRowsTemp
>  Where RowNumber >= @RowStart and RowNumber <= @RowEnd 
>

>
>
>There are probably multiple ways to solve this, but let me know if that helps...
>Kevin

Hi Kevin,

I'm looking right now for your article about pagination in SQL Server & ASP.NET and could not quickly find it. Could you please give a link?

Thanks.