Assign a list of integers to an @var
- by justSteve
I can:
declare @idOrder int
set @idOrder = 21319
I want:
declare @idOrder int
set @idOrder = (21319, 21320)
for use in a series of statements where the 'WHERE' clause uses the IN operator
delete Orders where idOrder in @idOrder
instead of
delete Orders where idOrder in (21319, 21320)
