Is there a way to break a csv list into its separate values in Transact 

SQL like the Split function does in VBScript?



What I'd like to do is pass a CSV list of values (@EventIDs) to a stored 

procedure:



CREATE PROCEDURE spTEST 

	@EventIDs varchar(8000)

AS

SELECT * from Events

WHERE EventID IN (@EventIDs)



Thanks

I think what you need to do here is to dynamically build your statement 

and

then use the sp_ExecuteSQL procedure to execute the query



CREATE PROCEDURE spTest

(

	@EventIDs VARCHAR(3950)

)

AS

DECLARE @SQL   NVARCHAR(4000)

SET @SQL =3D N'SELECT * FROM events WHERE eventid IN (' + @EventIDs + 

')'

EXECUTE sp_ExecuteSQL @SQL









I hope this helps



=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D

=3D=3D=3D=3D=3D=3D=3D=3D=3D

Kyle M. Burns, MCSD

ECommerce Technology Manager

Centra Credit Union

kburns@c...









-----Original Message-----

From: April Vail [mailto:april.c.vail@b...]

Sent: Wednesday, August 22, 2001 4:06 PM

To: ASP Databases

Subject: [asp_databases] VBScript Split functionality in SQL





Is there a way to break a csv list into its separate values in Transact 



SQL like the Split function does in VBScript?



What I'd like to do is pass a CSV list of values (@EventIDs) to a 

stored

procedure:



CREATE PROCEDURE spTEST

	@EventIDs varchar(8000)

AS

SELECT * from Events

WHERE EventID IN (@EventIDs)



Thanks