title: SQL variable to hold list of integers
body: <p>I'm trying to debug someone else's SQL reports and have placed the underlying reports query into a query windows of SQL 2012.</p>
  
  <p>One of the parameters the report asks for is a list of integers.  This is achieved on the report through a multi-select drop down box.  The report's underlying query uses this integer list in the <code>where</code> clause e.g.</p>
  
  <pre><code>select *
  from TabA
  where TabA.ID in (@listOfIDs)
  </code></pre>
  
  <p>I don't want to modify the query I'm debugging but I can't figure out how to create a variable on the SQL Server that can hold this type of data to test it.</p>
  
  <p>e.g. </p>
  
  <pre><code>declare @listOfIDs int
  set listOfIDs  = 1,2,3,4
  </code></pre>
  
  <p>There is no datatype that can hold a list of integers, so how can I run the report query on my SQL Server with the same values as the report?</p>