case statement column's used in order by , show error 'Invalid Column in the context'

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • jetlight8
    New Member
    • May 2013
    • 1

    case statement column's used in order by , show error 'Invalid Column in the context'

    Hi ,
    I have query with order by clause having customised column using case statement , when this column is used on order by clause , its showing error 'Invalid Column in the context' .

    If I try to use the entire case statement in the order by clause it's working fine, the problem i have using this solutions is performance degrade.Even this customised columns have reference columns as well.
    Please anyone could suggest a solution how to proceed with this
  • Rabbit
    Recognized Expert MVP
    • Jan 2007
    • 12517

    #2
    We need to see the query in addition to the definition of the calculated column.

    Comment

    Working...