title: Exists function within a Case Statement within a Select Statement takes FOREVER
body: <p>I commented out the offending code. When I comment this part out, it takes about 5 seconds to run.</p>
  
  <p>With the extra conditions in, it takes about a year (okay like 10 mins).</p>
  
  <p>Thanks for your help guys!</p>
  
  <pre><code>SELECT  t.account as fstrAccount,
          t.idno as flngID,
          CASE    
          WHEN t.fstrType = '' THEN '' 
  
          WHEN wd.fstrWorkType    = 'SUSIN1'
          AND wd.fstrOwner        =  ' ' 
          AND wd.flngworkkey      =  wr.flngworkkey 
          AND wr.fstrAccountType  &lt;&gt; '007' 
          AND wr.fblnOpen         =  1 
          --AND   EXISTS  
          --  (SELECT 1 
          --  FROM    tblIndicator id
          --  WHERE   id.fstrIndicator   = 'EIWTCH' 
          --  AND id.flngVer         = 0 
          --  AND id.flngAccountKey  = wd.flngAccountKey)
          THEN 'Suspended for Audit Indicator - EIC Watch For'
          ELSE    t.fstrTaskSource + '_TYP_' + t.fstrType 
          END AS fstrType,
  </code></pre>