Post reply

place all rows into one row

  • April 29, 2016 at 9:33 am

    #400092

    After some sql code earlier in this script, i end up with a temp table as below:

    oap

    ------

    apple1</br>

    apple2</br>

    What I'm trying to do is place all of the rows into a single row so I tried the following:

    select stuff((select oap from @OAP for xml path('')),1,1,'') as myApples

    this returns:

    oap>apple1</br ></oap><oap>apple2</br ></oap>

    What I'm tring to get is:

    apple1</br>apple2</br>

    How do I get all rows from the temp table into a single row? I sort of like the stuff with xml path minus the broken the first tag and the converted tags.

  • April 29, 2016 at 9:42 am

    #1875625

    Try this...

    select stuff((select ' ' + oap from @OAP for xml path('')),1,1,'') as myApples

  • April 29, 2016 at 9:47 am

    #1875630

    that produced:

    apple1</br > apple2</br >

    so how do i get to:

    apple1</br>apple2</br>

  • April 29, 2016 at 9:50 am

    #1875633

    think this will work:

    select replace(stuff((select ' ' + oap from @OAP for xml path('')),1,1,''),'</br >', '</br>')

Viewing 4 posts - 1 through 3 (of 3 total)

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