declare @sortColum int=1;
with x
as (Select 'textColumn' as textCol, 1 as intCol),
xx as (select x.IntCol, x.TextCol, case  @sortColum when 2 then x.intCol else x.textCol end as SortAttribute  from x)
select * from xx 
--order by x.SortAttribute

declare @sortColum int=2;
with x
as (Select cast(1 as int) as intcol,  cast(2.3 as decimal(2,1)) as  numericCol),
xx as (select x.intcol, x.numericCol, case  @sortColum when 1 then x.intcol else x.numericCol end as SortAttribute  from x)
select xx.* from xx