That will be what I am after - I think I have that bit all sorted now.
Just one more question -
With Regard to the XML format, Is it possible to have Child Nodes as well as the root node ?
So ;
<?xml version="1.0"?>
<SalesData>
<Customer>NOV001 </Customer>
<Branch>ME</Branch>
<Year>2014</Year>
<Month>1</Month>
<NetSalesValue>2419.20</NetSalesValue>
<Customer>BOO001 </Customer>
<Branch>RH</Branch>
<Year>2014</Year>
<Month>1</Month>
<NetSalesValue>2419.20</NetSalesValue>
</SalesData>
Would look like this;
<?xml version="1.0"?>
<SalesData>
<SalesDataItem>
<Customer>NOV001 </Customer>
<Branch>ME</Branch>
<Year>2014</Year>
<Month>1</Month>
<NetSalesValue>2419.20</NetSalesValue>
</SalesDataItem >
<SalesDataItem>
<Customer>BOO001 </Customer>
<Branch>RH</Branch>
<Year>2014</Year>
<Month>1</Month>
<NetSalesValue>2419.20</NetSalesValue>
<SalesDataItem>
</SalesData>
________________________________________________________________________________________________
Regards
Steve
SQL 2008 DBA/DBD - MCTS/MCITP
Please don't trust me, test the solutions I give you before using them.