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

Filed under:

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

Related posts about sql