SQL - FOR XML EXPLICIT

Soldato
Joined
23 Jul 2009
Posts
8,920
Location
Cayman Islands
Hi

Anyone have any experience with this? Have hit a brick a query that I'm trying to produce.
 
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?
 
Back
Top Bottom