Dynamic sorting and paging in SQL Server with the CASE expression

Demonstrates how to write T-SQL queries that implement dynamic sorting and paging without using dynamic SQL, and which have the same performance characteristics as statically sorted queries. I bet you didn't know you could use the CASE expression like this...