How to sort the SQL results dynamically (dynamic ORDER BY)
by mahpour on May.08, 2007, under Uncategorized
The solution is using CASE statement in your select query .
Here’s a sample:
DECLARE @sortColumn VARCHAR(255)
SELECT @sortColumn = ‘title’
SELECT * FROM asset
ORDER BY
CASE
WHEN @sortColumn = ‘title’ THEN title
WHEN @sortColumn = ’start_date’ THEN start_date
WHEN @sortColumn = ‘asset_id’ THEN asset_id
ELSE title
END
