• 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.