I retired from personal blogging in July 2008.
But you can find me over at http://blog.xero.com.

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

Trackback uri |