SQL - FOR XML EXPLICIT

[DAIR]

Hi

Anyone have any experience with this? Have hit a brick a query that I'm trying to produce.

 

[davetherave2]

I have some experience with it. I still manage an application that uses sql to xml as it's main data passing process. What specifically do you need help with?

 

[DAIR]

I'm using IDs and IDREFs to nest groups of elements.

The group headings appear as follows
<heading ='element heading'/>

I don't want the value of the ID to be shown. Can it be hidden?

 

[davetherave2]

well if you don't want the id included in the output then don't include it.

Without seeing how you are building up the xml table (I know of two ways of doing this)
it's difficult to give you the most appropriate answer so if you can provide a sample code example that will help in providing you with an answer.

 

[Nash]

You could obfuscate it by naming the headings something obscure and unrelated but XML is hardly a cryptographically orientated language. Not sure what you mean, I second davetherave2's comments.