I have multiple XML fields with the same schema. Is it possible to "concatenate" them in a select statement to generate a single XML field?
Table Schema:
CREATE TABLE Table1 (
ID INT
,XML1 XML
,XML2 XML )
Example:
XML Field 1:
<Response>
<Value>Idaho</Value>
<Result>ID</Result>
<Return>50</Return>
</Response>
XML Field 2:
<Response>
<Value>Texas</Value>
<Result>TX</Result>
<Return>50</Return>
</Response>
Resulting XML Field:
<Response>
<Value>Texas</Value>
<Result>TX</Result>
<Return>50</Return>
</Response>
<Response>
<Value>Texas</Value>
<Result>TX</Result>
<Return>50</Return>
</Response>