• The problem you have there is lack of a root node. Not to serious though.

    To get exactly what you want, have a look at EXPLICIT. You can do it with that.

    There is an example in BOL which does that useing Pubs DB. That is what I used and hacked it apart.

    Another solution for you could be using attributes. Not sure if the required document is cast in stone yet.

    Just remove the , Elements and you'll have

    <ROOT>

    <Client ClientID="1" FirstName="Crispin"/>

    <Client ClientID="2" FirstName="Crispin2"/>

    </ROOT>

    Is this what you are after.

    Cheers,

    Crispin

    Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!