Hi Jacob,

How to add a complex element in XML.

For ex:

Let say i have my XML like this

<Business>

<Business_ID>12345</Business_Id>

<Account>

<ACCOUNT_NUMBER>1122334</ACCOUNT_NUMBER>

<ACCOUNT_DESCRIPTION>Tesr acct</ACCOUNT_DESCRIPTION>

<ACCOUNT_TYPE>C</ACCOUNT_TYPE>

</Account>

<Account>

<ACCOUNT_NUMBER>0004455</ACCOUNT_NUMBER>

<ACCOUNT_DESCRIPTION>Bank Test Account</ACCOUNT_DESCRIPTION>

<ACCOUNT_TYPE>S</ACCOUNT_TYPE>

</Account>

</Business>

And i want the result to look like this

<Business>

<Business_ID>12345</Business_Id>

<Accounts>

<Account>

<ACCOUNT_NUMBER>1122334</ACCOUNT_NUMBER>

<ACCOUNT_DESCRIPTION>Tesr acct</ACCOUNT_DESCRIPTION>

<ACCOUNT_TYPE>C</ACCOUNT_TYPE>

</Account>

<Account>

<ACCOUNT_NUMBER>0004455</ACCOUNT_NUMBER>

<ACCOUNT_DESCRIPTION>Bank Test Account</ACCOUNT_DESCRIPTION>

<ACCOUNT_TYPE>S</ACCOUNT_TYPE>

</Account>

</Accounts>

</Business>

I have added here complex type Accounts. Can you tell me how to change my T sql to add this complex element.