ansaurus

Question

Concatenate multiple xml columntype rows in SQL

Answer 1

A:

Take a look at this page, which lists quite a number of ways to concatenate rows of data.

lc 2010-07-20 02:48:18

There's probably a neater way than string concatenation though seeing as the input rows and desired output are both XML.

Martin Smith 2010-07-20 03:15:15

Have looked at XML AUTO etc, but the best I can get is <Root><ApplicationForm><ApplicationForm></ApplicationForm></ApplicationForm>. The xml data has the "root" node already, which the column is adding in as well

mickyjtwin 2010-07-20 03:17:24

@mickyjtwin: In your `FOR XML AUTO`, you could probably add a `, ROOT('Applications')` and thus define what that root node should be called

marc_s 2010-07-20 05:11:29

@marc_s, yes I have tried that, which is great, but it is the replication of the ApplicationForm elements, as it is written in the original xml value, and it is also the column name. I only need it once.

mickyjtwin 2010-07-20 07:03:59

ansaurus

tags:

views:

answers:

Concatenate multiple xml columntype rows in SQL

related questions