SQL Server August 8th, 2012 Conditional Order By See how you can dynamically drive sort column and sort order.