Dynamic SQL, Dynamic Ordering and Paging

In some of our previous posts, we have covered both Paging of recordsets as well as conditional ordering using the CASE statement in the Order By clause. In today’s post, we will address one of the questions that a reader had recently asked. She wanted to know how to support dynamic ordering in a procedure that does paging using one of the techniques that we had presented here (using the ROW_NUMBER() function).