concatenate xml values in multiple rows into one row in SQL server 2012

  • I have attached the sample file for your reference.

    The column TEXT VALUE  contains  values of a xml file.I need to concatenate it as one row and report it.

    But  i don't know how to implement it.

    Can anyone please help me on this.

    Thanks.

  • You might want to post your data as (formatted) text in your post, rather than an excel spreadsheet. You'll find people are often not inclined to download excel documents from a complete stranger on the internet.

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • The contents of Text_Value does not look like xml
    Can you put this into text?

    Russel Loski, MCSE Business Intelligence, Data Platform

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

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