murthyvs (12/11/2012)
Hello all - I am having hard time to split an input string into multicolumn - multirows.Task - Create a stored procedure that reads an input string with pre-defined field and row terminators; splits the string into multicolumn - multirows; and inserts records into a table.
So, a couple of questions remain to solve this for you properly...
1. Can you use CLR on your servers or not?
2. If not, what is the guranteed absolute maximum length of your delimited parameters?
--Jeff Moden
Change is inevitable... Change for the better is not.