SQL - Stored Procedure with Select Statement using IN (@Variable_CommaDelimitedListOfIDS)
Posted
by GigaPr
on Stack Overflow
See other posts from Stack Overflow
or by GigaPr
Published on 2010-04-06T13:08:58Z
Indexed on
2010/04/06
13:13 UTC
Read the original article
Hit count: 154
sql
Hi I am creating a stored procedure to which i want to pass as variable a comma delimited list of Ids
I want to use the Ids into a select statement
something like
Create Procedure up_TEST
@Ids VARCHAR(MAX)
AS
SELECT * FROM ATable a
WHERE a.Id IN(@Ids)
Obviously i get the error that @Ids is a varchar and not an INT but how can i convert the comma delimited list I am using SQL Server 2008 Thanks
© Stack Overflow or respective owner