title: Should table-valued parameters be used here?
body: <p>I have following query:</p>
  
  <pre><code> @"UPDATE students SET IsDeleted = 1 WHERE StudentId IN (
           SELECT StudentId FROM Class where PassId IN (
                SELECT Id FROM ClassValueTable WHERE IsDeleted &lt;&gt; 1" 
                  + activeIds)))";
  </code></pre>
  
  <p>where activeIds = string of some numbers for example: 1,2,3,4... </p>
  
  <p>I want to convert this query into stored procedure. My question is what is the best way to pass activeIds as a parameter to this stored procedure? </p>
  
  <p>*Code is in C# and am using SQL Server 2008</p>