Sql2005 Stored Procedure

[cuterita7]

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

[wild_bill]

Rather than nvarchar(255), use xml:

--for example only, these would be your input parms
declare @articleId int; set @articleId = 987
declare @personNames xml; set @personNames = 
'<Persons>
	<Name>John</Name>
	<Name>Paula</Name>
	<Name>Robert</Name>
</Persons>'

select @articleid, NAME.value('.','varchar(60)')
from @personNames.nodes('/Persons/Name') as Data(NAME)