Hi there!

Here a sample code:

CREATE PROCEDURE test

@par tinyint

AS

select *

from TABLE

order by

case @par WHEN 1 THEN field1 ELSE NULL END,

case @par WHEN 2 THEN field2 ELSE NULL END