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?
Try:
select top 1 case STATUS
instead of
select case top 1 STATUS