I haven't check your code and not saying that is not right.

I am not comparing the Sort Column,

It is generic code for paging and sorting by any Column

comparing...

Resolution is specific to SQL SERVER

Explanation:

1. Ordering the row number on the basis of param

2. Againt ordering the row number in outer query

Try this code

DECLARE @PageNum int

DECLARE @PageSize...