• 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>