BryanHood Posted June 29, 2006 Share Posted June 29, 2006 I would like to pass into a SP a string containing a list of items, and then use that list in a Where clause.Example:exec sp_FindFromList '1, 2, 3, 4, 5' Create Proc dbo.FindFromList @paramList as VarChar(100)ASSelect *From myTableWhere column1 IN (@paramList)GO I would like to parse out the list into individual items.Thank you,Bryan Link to comment Share on other sites More sharing options...
aspnetguy Posted June 29, 2006 Share Posted June 29, 2006 try thishttp://www.devx.com/tips/Tip/20009 Link to comment Share on other sites More sharing options...
BryanHood Posted June 29, 2006 Author Share Posted June 29, 2006 That was it!Thanks ASPNetGuy! (Or would that make you SQLandASPNetGuy?) try thishttp://www.devx.com/tips/Tip/20009<{POST_SNAPBACK}> Link to comment Share on other sites More sharing options...
aspnetguy Posted June 30, 2006 Share Posted June 30, 2006 That was it!Thanks ASPNetGuy! (Or would that make you SQLandASPNetGuy?) <{POST_SNAPBACK}> Hey no problem...I think Your Majesty or Your Excellence will suffice Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now