Pagination In Mssql 2008

[yii_king (Micho23)]

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

// Use this for pagination

$criteria=new CDbCriteria();

$count=carManager::model()->count($criteria);

$pages=new CPagination($count);

// Results per page in pagination

$pages->pageSize=10;

$pages->applyLimit($criteria);

// SQL

SELECT id FROM cars LIMIT $criteria->offset,$criteria->limit

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.

[le_top (Ext Yiiframework Com)]

Check out this forum entry :

http://www.yiiframework.com/forum/index.php/topic/40054-mssql-sorting-problem/page__view__findpost__p__193772