I retired from personal blogging in July 2008 but you can find me over at blog.xero.com

Specifying a sort parameter for a TSQL stored procedure
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

Trackback uri |

Comments(1)

    Comment by brij at 5:11 pm on 28 June 2009

    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