Thanks for the great suggestion Kevin. This technique looks VERY promising. Yes the second common table expression was giving me fits.

By the way the National Cherry Festival is in full swing. The town is full of visitors and guests and all are having a great time. The only problem however has been the weather. First beastly HOT, then rain and now cool. I sure would not want to dip my toes in the bay when it is no warmer than 70.

My wife and I have been so busy this year preparing our weekly rental home here on Duck Lake that we have not had much of an opportunity to participate in the festivities. Maybe next year we can enjoy the cherry spitting contest :>

Thanks

>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