Forum Replies Created

Viewing post 1 (of 2 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 2 total)