Home Forums SQL Server 2008 T-SQL (SS2K8) Order by with case RE: Order by with case

  • September 6, 2012 at 8:33 am

    #1534511

    mssqlsrv (9/6/2012)

    I think you can not use variable in order by clause.

    Variables are only allowed when ordering by an expression referencing a column name.

    Yeah you can. Just tried this and it works:

    declare @index int = 4

    select top 10 * from information_schema.COLUMNS

    order by (case @index when 4 then TABLE_SCHEMA else COLUMN_NAME end)