MSSQL2008- pagin result via pagination class ( use changed _limit method )

[eluser]Krystian[/eluser]
Hi,

I`m starting developing web app using CI based on MSSQLSERVER2008 database engine.
The pagin problem regarding SQLSRV occurs several times in here.

I`ve found solution that fixes _limit method in mssql_driver class.

click

I would like to use the first code that Arasoi started the forum thread.

I`m a little bit confused how to use pagination class at the moment, because two params are changing every time ( SELECT bla, bla, bla FROM dbo.Table WHERE $start BETWEEN $stop ).
In MySql only offset is changing, limit every time is the same ( e.g. 10 records ).

I guess that many of you had such a need in the past? I would like to ask for a hint, maybe some of you can paste some code creating links or impoved pagination class... etc.
I didn`t find any solution in the net.

regard
Christian