Can I use a variable ORDER BY clause? It is rejected by the syntax parser as it wants the name of a column. Is there a way other than creating a different query for each?
Maybe using an ugly CASE WHEN in ORDER BY?

This is a very simplied stored proc to illustrate:

CREATE PROCEDURE dbo.sp_getWhatever
(
   @SortOrder char(10)
)
AS

SET NOCOUNT ON

SELECT o.Org_Name, c.CtryNm  -- extra sortable columns here
FROM Orgs AS o
INNER JOIN Countries AS c ON o.ctry_code = c.Ctry_Cd
ORDER BY @SortOrder

Still learning T-SQL :)