TSQL @Var with multiple lines to table
Posted on 2012-03-26
I have a storage Procedure that receives a Parameter (@Par2) with a string with multiple lines.
each line contain a serial number which is alphanumeric.
How can I run an insert a line into a table per each line on the @Par2
Example the @Par2 as the following information:
I want to insert each of these lines into a #TEMP table with 1 column only
I know this cant be done with a BULK INSERT but honestly not sure how to parse the text per line.