I retired from personal blogging in July 2008.
But you can find me over at http://blog.xero.com.
Posted by Rod in Old-blog-archives at 4:28 pm on Friday, 15 April 2005
Useful article on the power of the CASE statement in TSQL….
CREATE PROCEDURE getEmployees ( @ColumnName varchar(100) )
AS
SELECT
EmployeeID,
FirstName,
LastName,
SSN,
Salary
FROM
Employees
ORDER BY
CASE
WHEN @ColumnName=’LastName’ THEN LastName
WHEN @ColumnName=’Salary’ THEN CONVERT(varchar(50), Salary)
WHEN @ColumnName=’SSN’ THEN SSN
END
