Pagination In Mssql 2008

I am able to do pagination with Yii and MySQL by doing something like this:

However, this does not work in MSSQL 2008 as it does not have support for LIMIT. Can you please advise how to do pagination with MSSQL? Note that using TOP is not interesting as that will only return the N defined number of results. What I need is to retrieve results between 1-10, 11-20 etc.

Check out this forum entry :