sqlt-sqlcasetop-n

top 1 case in select statement on TSQL


I am having problem on this query. How can I fix this:

select (select case top 1 STATUS 
       when 'Inprocess' then 'Processing' 
       when 'Inworkbin' then 'Waiting In Draft' 
       end 
    from ICS_EMAIL_CONNECTIONS_TRX A    
    where A.SESSIONID = B.SESSIONID 
    and STATUS <> 'Completed'
    order by A.CREATE_DATE desc) as LAST_STATUS 

I am getting this error:

Incorrect syntax near the keyword 'top'.

Any suggestions?


Solution

  • Try:

    select top 1 case STATUS
    

    instead of

    select case top 1 STATUS