Post reply

Split Function

  • February 11, 2011 at 2:12 am

    #245104

    hi all,

    i have string like '12,23,56,78' n 12,56,7' should insert every data insingle rows(cross join) using split funtion... So help me out how to do perform this function...

    example

    column name1 column name2

    12 12

    12 56

    12 7

    23 12

    23 56

    23 7

    56 12

    like this i need to insert the string

    Thanx in advances

  • February 11, 2011 at 4:21 am

    #1285604

    The last link in my signature will point you at a split function to be known as one of the best performing solutions using T-SQL.


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply