execute a stored procedure in a loop

Keep it simple and call the stored procedure for each string item in the list.

Passing an array to a store procedure isn't supported by SQL Server. The best you can do is create an XML string containing the array strings and let the stored procedure parse the XML. For most cases, this isn't worth it.