title: alternative to IN clause SQL SERVER
body: <p>I am running the following query which is taking too much time:</p>
  
  <pre><code>select a.id, b.name 
  from temp.dbo.COLD a with (NOLOCK)
  inner join temp.dbo.FIVE b with (NOLOCK)
  on a.id = b.cid
  where a.proc_flag ='C'
  and b.dt &gt;= dateadd(D,-(cast('60' as int)),cast(GETDATE() as date))
  and b.cCode in 
  (
  'ADC',
  'BUNE',
  'DD',
  'HUUP',
  'INER',
  'MNER',
  'NCIT',
  'NOG',
  'TRON',
  'WRUM',
  'XFNA',
  'BL', 
  'DIO', 
  'DOM', 
  'HU',
  'ILL',
  'INKT',
  'LB',
  'NOM',
  'PE',
  'RF',
  'SE',
  'XER',
  'Pge',
  'dd',
  'CC');
  </code></pre>
  
  <p>let me know if I can use something else instead of IN clause.
  I would appreciate your help.</p>