title: Is there any Alternative to "IN" statement in T-SQL?
body: <p>Consider this code snippet:</p>
  
  <pre><code>SELECT 
      vbs.SKUID, SKUName, SUM(vbs.Quantity) AS Qty
  FROM   
      BatchStocks AS vbs
  WHERE  
      vbs.SKUID IN (Here i have almost 12000 SKU)
      AND vbs.StoreID IN (%q)
      AND vbs.StockType = %n
  GROUP BY
      vbs.SKUID, vbs.SKUName
  </code></pre>
  
  <p>In the <code>where</code> condition, i have almost 12000 SKUID which take much time to execute statement. Can you please suggest how I can improve this query?</p>