Could you please elaborate on how you were able to solve this? I have a scenario with XML similar to the following:

<jobs>

<job>

<jobCode>12345</jobCode>

<title>.NET Developer</title>

<locations>

<location>

<description>New York</description>

</location>

<location>

<description>Philadelphia</description>

</location>

</locations>

</job>

<job>

<jobCode>67890</jobCode>

<title>Database Administrator</title>

<locations>

<location>

<description>New York</description>

</location>

<location>

<description>Denver</description>

</location>

</locations>

</job>

</jobs>

Basically I need to get each job into a parent Job table where jobCode is the primary key, with each corresponding location going into a Location table that contains a jobCode foreign key pointing back to the Job table.