Results 1 to 9 of 9
  1. #1
    Join Date
    Dec 2015
    Posts
    4
    Provided Answers: 1

    Answered: Split string and insert to table

    I have table follow:
    Click image for larger version. 

Name:	cap2_zpsbpake1yj.png 
Views:	6 
Size:	8.6 KB 
ID:	16890
    I want use procedure or function is return resurt as show
    Help me. Thanks
    Attached Thumbnails Attached Thumbnails cv.png  

  2. Best Answer
    Posted by haocaocu

    "I used function DelimitedSplit8K and it's working"


  3. #2
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,794
    Provided Answers: 11
    There are plenty of string splitting functions posted around the internet. In SQL 2016, there will even be a built in function to split strings on a given delimiter.

  4. #3
    Join Date
    Dec 2015
    Posts
    4
    Provided Answers: 1
    You can provide details

  5. #4
    Join Date
    May 2005
    Location
    South Africa
    Posts
    1,365
    Provided Answers: 1
    Look at split

  6. #5
    Join Date
    Dec 2007
    Location
    Richmond, VA
    Posts
    1,328
    Provided Answers: 5
    years ago I used an instead of trigger to insert multiple rows when the development team issued a single insert statement. Even though it was on DB2, the same principle applies. here's a link to a thread I sent out at the time, still doesn't work on Z/OS, but works on UDB just fine.
    http://www.idug.org/p/fo/et/thread=43488
    Dave

  7. #6
    Join Date
    Dec 2015
    Posts
    4
    Provided Answers: 1
    I used function DelimitedSplit8K and it's working

  8. #7
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,422
    Provided Answers: 10
    Quote Originally Posted by MCrowley View Post
    There are plenty of string splitting functions posted around the internet. In SQL 2016, there will even be a built in function to split strings on a given delimiter.
    SPLIT_STRING()
    https://msdn.microsoft.com/en-us/library/mt684588.aspx
    Last edited by gvee; 05-18-16 at 15:50.
    George
    Home | Blog

  9. #8
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,794
    Provided Answers: 11
    Spit string? Ew.

  10. #9
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,422
    Provided Answers: 10
    Whoops
    George
    Home | Blog

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •