Need SQL to perform Repeater paging

I want to build some paging functionality into my repeater (b4 you ask, datagrid not providing flexibility required for presentation).

I will have no problem with the VB logic but I will need to execute SQL that only returns results from x to y (e.g. results 21 thru 40 for page 2). I know I can do something like 'SELECT TOP 20 * FROM...', or something like it, for page 1. But, I'm not sure if it's possible to build SQL for the pages greater than 1. Any suggestions.

Thanks
MartinSorry to waste your time, I found a solutionhere.

Thanks anyway,
Martin

Need SQL Server 2005, for SSRS 2005 to work ?

Can SQL Server 2005 Reporting Service be purchased seperately or need to buy
SQL Server 2005 license also.
In other way, SSRS 2005 database required to be on the SQL Server 2005 or it
can even be on SQL Server 2000 ?
Thanks,Licensing and running are two different things. With release, RS 2005 will
run with SQL Server 2000. However, you will need a 2005 license.
RS is not purchased separately.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"JDS" <JDS@.discussions.microsoft.com> wrote in message
news:BFD47857-F9DD-4DDE-8EC7-942A8B381C24@.microsoft.com...
> Can SQL Server 2005 Reporting Service be purchased seperately or need to
> buy
> SQL Server 2005 license also.
> In other way, SSRS 2005 database required to be on the SQL Server 2005 or
> it
> can even be on SQL Server 2000 ?
> Thanks,
>
>