SQL Server 2008 Pagination -


after viewing examples of creating pagination function sql, have managed write following working code:

select *  services order servicedateupdated desc    offset @offset rows fetch next @recordsperpage rows only; 

today, after working line of code on year, have realized not used earlier versions of sql server 2012. current sql server version 2008.

how can re-write make work sql server 2008?

thanks in advance.


Comments