Hi,
I have a xml data like below
<Activity>
<ID>2</ID>
<Start>01/01/2012 13:00</Start>
<Quantity>1</Quantity>
<Observation>
<Code>14</Code>
<Value>5</Value>
</Observation>
<Observation>
<Code>76</Code>
<Value>5</Value>
</Observation>
</Activity>
<Activity>
<ID>3</ID>
<Start>01/01/2012 13:00</Start>
<Quantity>1</Quantity>
<Observation>
<Code>14</Code>
<Value>10</Value>
</Observation>
</Activity>
<Activity>
<ID>4</ID>
<Start>01/01/2012 13:00</Start>
<Quantity>1</Quantity>
</Activity>
I have two table like 'Activity' as primary table and 'Observation' as a foreign key table.
How to read the above xml and insert into these two tables?
Thanks