SQL variable to hold list of integers

by

I’m trying to debug someone else’s SQL reports and have placed the underlying reports query into a query windows of SQL 2012.

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 where clause e.g.

select *
from TabA
where TabA.ID in (@listOfIDs)

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.

e.g. 

declare @listOfIDs int
set listOfIDs  = 1,2,3,4

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?

8 Answers
8

Leave a Comment