I retired from personal blogging in July 2008 but you can find me over at blog.xero.com
Follow @roddrury
Posted by rod@drury.net.nz 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

Thanks a ton! Rod, i have been looking for this since so long.
I owe you a beer man, anytime coming to India, just let me know, i’ll treat you at a palace.
Thanks
Brij