Thanks Cadavre. This is cool stuff.
Can your code take two row terminators? pipe (|) and line break ()?
Example data:
field1;field2|
30;38469|
31;38469|
32;38469|
33;38469|
34;38469|
I didn't notice the line break in the original data. Very sorry.
The intent is that my user copies example data from excel and enters into a multiline text box in a webpage. He then hits a button that would transfer the input string (example data) to a stored proc that reads the data and splits into multiple column - multiple rows.
Thanks for all your help.