• You could add the parameter to your select statement, for example:

    SELECT [id],[description],(CASE WHEN @Parameter = ...etc ) AS [order]

    FROM tablename

    ORDER BY [order]

    The logical instruction order of SQL (from -> where -> group by -> having -> select -> order by) allows you to use an alias in the order by. You can also write out the case statement as described in the solution above, check your query execution plan to determine which option provides the best performance for your environment.