Hi Davor,

I thank you very much for your quick replay.

I tried this algorithm with the Query builder and it worked like a charm.

Very brilliant.

I don't know if this is off topic but will try:

I have successfully implemented server side paging through a stored procedure using a CTE like it was explained in your...

Jacob,

I read your article what I found very useful.

Now I have a question related to joins. Please consider this two examples:

WITH EmployeesOrders AS (

 SELECT 

   Employees.EmployeeID,

   Employees.FirstName,

   Employees.LastName,

   Orders.OrderDate,

   Orders.ShippedDate,

   ROW_NUMBER()OVER (ORDER BY LastName) AS...