DECLARE @order int

SET @order = 3

SELECT*

FROM dbo.ICD10_DIAGNOSIS_temp

ORDERBYCASE

                  WHEN @order = 1

                        THEN ICD10_DIAG_CD

            ENDDESC,

            CASE

                  WHEN @order = 2

                        THEN PAR_ICD10_DIAG_CD

            ENDASC,

            CASE

                  WHEN @order = 3

                        THEN ICD10_DIAG_CD_LVL_NBR

            ENDDESC,

            CASE

                  WHEN @order = 4

                        THEN ICD10_DIAG_DESC

            ENDASC

DECLARE @order intSET @order = 3

SELECT*

FROM dbo.ICD10_DIAGNOSIS_temp

ORDERBYCASE

                  WHEN @order = 1

                        THEN ICD10_DIAG_CD

                  WHEN @order = 2

                        THEN PAR_ICD10_DIAG_CD

                  WHEN @order = 3

                        THEN ICD10_DIAG_CD_LVL_NBR

                  WHEN @order = 4

                        THEN ICD10_DIAG_DESC

            ENDASC