MSSQL Pagination Holly Grial?

[eluser]whobutsb[/eluser]
Hi Gusa,
Thanks for posting up that MSSQL Hack, Pagination is definitely one of the biggest headaches in SQL hut:

I'm just trying to make sense of your example that you posted. How do you actually return a result from the inputs that you are using?

I tried to use:
$this->db->select('contactID');
$this->db->from('tblContact');
$this->db->limit($limit,$offset);
$query = $this->db->get();

And I guess the $this->db->get(); Method is throwing the error: Unsupported feature of the database platform you are using.

Any chance of a couple of pointers? Thanks for your help in advance!

Steve