Forum Replies Created

Viewing post 1 (of 1 total)

  • RE: Conditional Order By clause?

    If the columns are not the same datatype, then you can use:

    select * from

    where selectColumn=@SelectValue

    order by case when @SortParm='column1' then column1 end,

    case when @SortParm='column2' then column2 end,

    case when...

Viewing post 1 (of 1 total)