Jeff,

My apologies for being slow on understanding your question.

Your question is a valid question. I am doing database development for the application teams. The teams services that take the "result set" from my sprocs and uses C# code to serialize the result set into an xml message to send over the network to other services.

They prefer having a result set of 1 row with multiple columns.

One of the columns happens to be the comma delimited string that I had asked for help. Both teams ( the sender service and the receiver service) prefer having:

<element1>xxxx</element1>

<element2>xxxx</element2>

...

<elementn>xxxx</elementn>

to easily shred the xml message.

Needless to say that the comma delimited string will be split to a table for processing....