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!