Hi

I want to create a stored procedure in SQL Server 2005 that takes 2 parameters:ArticleId int,and PersonNames nvarchar(255).
PersonNames are something like "John,Paula,Robert".

What I want is ,for each person in PersonNames ,to insert it into a table PersonsMentioned

so if ArticleId=987 and PersonNames ="John,Paula,Robert" so

PersonsMentioned(which has 3 fields ID,ArticleID,PersonMentioned) will have the following data

1 987 John
2 987 Paula
3 987 Robert

Any help

thanks