Home Forums SQL Server 2005 SQL Server Newbies Split input string into multicolumn - multirows RE: Split input string into multicolumn - multirows

  • December 22, 2012 at 10:43 am

    #1571149

    Jeff Moden (12/21/2012)

    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?

    Wow .. lots of activity when I wasnt around :). Thanks a lot gurus! I certainly learned a whole lot in the last one hour of reading the entire thread.

    Here are my answers:

    1. Sorry. I have no clue on CLR - I am a newbie with serious appetite to learn new things.

    2. The max characters for field1 = 10; field2 = 20; possible field delimiters = ";", " tab "; row delimiters = "|", "new line".

    The total string lenght is at the max 50K although 100K is nice to have.

    Thanks to everyone.