Dynamic SQL statement passing comma seperated values into table
Posted on 2008-10-07
I have a stored procedure that accepts two input parameters:
topic_id is a comma separated list of ID values coming in from an HTML form.
I have a table study_topic which relates study_id [1:N] topic_id
so for each value in topic_id, I need to insert a new row study_id, topic_id
What's the proper way to do that?