Excellent! You were correct, the PATH parameter caused FOR XML to interpret the @ sign to indicate an attribute.
I had to add a descriptor to instruct PATH to use...

Hi Drew,
you are correct that I missed that change in the code.
Here are the results with AS [@name]

<OtherFields>
<key>
  <_x0040_name>OFcAddress_1</_x0040_name>
 ...

Adding the ELEMENTS parameter changes it to the standard XML elements notation, not the Name/value pair
<OtherFields>
<key>
  <name>OFcAddress_1</name>
  <value>1621 NE Winter</value>
...

the folks at Stack Overflow helped me.  Here is the solution:

    DECLARE @cMOBId varchar(50);
    SELECT @cMOBId = cMOBClientID FROM xdMOBOthPay GROUP BY cMOBClientID;

    WITH XMLNAMESPACES(DEFAULT 'http://someURL.com/core/xml/payment')

I have worked from home for over 17 years. (SQL Server 6.5!!!) Much of that time I have been the multi-hat person: technical responsibilities combined with people/project management.

When I...

We use a hosted data center. It turns out that they had turned on the SQL backup functionality on their nightly backup system - so it was an external...

No external programs that I am aware of.

Sorry for the delay. Got pulled several directions at once. Everything checked OK, but now we'll not know, because the jobs were switched to a 3rd party scheduler and the...

Like several of my posting compatriots, I often read, but rarely post.

Good luck with the barn. Intersting that several posters have a rural bent. I, too, have livestock. Horses, llamas...

Can application roles be implemented in 6.5?

the machine has 2.5GB memory. By using 1000000 blocks for SQL, that left around 600MB for NT - more than enough. Unless NT can't address more than 2GB?

I've got...

What problem did you have with the 10GB table?

We appear to have found the problem - in spite of the published information from MS stating that 6.5 can address up to GB of memory, it doesn't. I finally...

It is starting with a valid domain account

I need to increase the master. We believe the problem to be the SQL Setup GUI code running under WIN2k. So we removed 6.5 and reinstalled with a properly sized...