title: Combining multiple condition in single case statement in Sql Server
body: <p>According to the following description I have to frame a <code>CASE...END</code> statement in SQL server , help me to frame a complex <code>CASE...END</code> statement to fulfill the following condition.</p>
  
  <pre><code>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'
  </code></pre>
  
  <p>Thanks in advance.</p>