SQL Server XML Export With Repeating Complex Sequences

I have an export from SQL Server 2005 to XML using BCP.  I need to add some data to the export that will add repeating complex sequences to the XML output.

For example:

<Family>
<Father Name>Joe</Father Name>
<Mother Name>Jane</Mother Name>
<Child>
<Child Name>Jack</Child Name>
<Child Gender>M</Child Gender>
</Child>
<Child>
<Child Name>Jill</Child Name>
<Child Gender>F</Child Gender>
</Child>
<Child>
<Child Name>Jen</Child Name>
<Child Gender>F</Child Gender>
</Child>
</Family>

I have made an attempt at this;  I think that it created three seperate 'Family' records.

Any help in addressing this would be greatly appreciated.

Thanks In Advance
mjs082969Asked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
mjs082969Connect With a Mentor Author Commented:
I was able to work through this.  If anyone is wondering how to this, the key lies with the TAG, PARENT, and ELEMENT functionality in SQL Server.  These constructs will allow you to create the XML in the format that you want.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.