Tom Knowlton
asked on
custom ORDER BY clause
How do I pass in parameters to customize the ORDER BY statement?
My attempt:
My attempt:
CREATE PROCEDURE UNAdmin.unsp_JOClassTypesList
(
@OrderByColumn nvarchar(100),
@OrderByType nvarchar(4)
)
AS
SELECT ID,
Name,
Abbreviation,
IsOnlineClass,
IsActive
FROM UNAdmin.TrainingClassTypes
ORDER BY CASE WHEN @OrderByColumn = 'EmployerName' AND @OrderByType = 'DESC' THEN EmployerName END DESC)
CASE WHEN @OrderByColumn = 'EmployerName' AND @OrderByType = 'ASC' THEN EmployerName END)
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER