Share via

declare a variable with multiple items like an in for a where clause?

Jonathan Brotto 420 Reputation points
2024-08-08T14:19:55.0666667+00:00

Is it possible to declare a variable with multiple items like an in for a where clause?

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,225 questions
SQL Server Transact-SQL
SQL Server Transact-SQL
SQL Server: A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.Transact-SQL: A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
108 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,672 questions
SQL Server Training
SQL Server Training
SQL Server: A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.Training: Instruction to develop new skills.
14 questions
Accepted answer
  1. Viorel 118.6K Reputation points
    2024-08-08T14:32:43.9566667+00:00

    For example:

    declare @values varchar(max) = '100,250,30,700'

select *
from MyTable
where id in (select [value] from string_split(@values, ','))

-- OR:

select t.*
from MyTable t
inner join string_split(@values, ',') as v on v.value = t.id
    1 person found this answer helpful.

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.