Combining multiple condition in single case statement in Sql Server
Posted
by swetha
on Stack Overflow
See other posts from Stack Overflow
or by swetha
Published on 2010-06-15T07:06:48Z
Indexed on
2010/06/15
7:12 UTC
Read the original article
Hit count: 232
sql-server
|sql-server-2005
According to the following description i have to frame a case ...End statement in Sql server ,help me to frame a complex case..End statement to fulfil the following condition.
if PAT_ENT.SCR_DT is not null and PAT_ENTRY.ELIGIBILITY is null then display display 'Favor'
if PAT_ENT.SCR_DT is not null and PAT_ENTRY.EL is equal to No, display 'Error'
if PAT_ENTRY.EL is Yes and DS.DES is equal to null or OFF, display 'Active'
if DS.DES is equal to N, display 'Early Term'
if DS.DES is equal to Y, display 'Complete'
Thanks in advance.
© Stack Overflow or respective owner
