title: Pass multiple values to stored procedure
body: <p>What is the correct way to run the following in SQL Server?</p>
  
  <pre><code>Execute myStore @dept='dept1',@dept='dept2'
  </code></pre>
  
  <p>or </p>
  
  <pre><code>Execute myStore @dept in ('dept1','dept2')
  </code></pre>