To insert multiple records in SQL

I want to insert records in a table in such a way that, i have a string of comma seperated values which is an input parameter to the procedure for this insert. This comma seperated values has to be split into a array of values and each value has to be sent to the select statement selecting one value from a table with where where condition of the one array value each time. a value which is found from this select has to be inserted into another table. For each value of the array a record need to be inserted into this table. Can this be done. Thanks.  ...