July 17, 2007 - SQL Authority with Pinal Dave

SQL SERVER – CASE Statement in ORDER BY Clause – ORDER BY using Variable

July 17, 2007

SQL, SQL Performance, SQL Server, SQL Tips and Tricks

This article is as per request from Application Development Team Leader of my company. His team encountered code where application was preparing string for ORDER BY clause of SELECT statement. Application was passing this string as variable to Stored Procedure (SP) and SP was using EXEC to execute the SQL…