Thank you in advance for your help.
Newb needs help...
I have a select statement that is not being formatted as I like. Here is my sql:
where Notes.EntityID = Entities.ID
and Notes.IsPrivate = 1
for xml path('private')
) as xml) as 'notes'
where Entities.ID = @EntityID
for xml path('entity')
The above is producing this:
name="Office of the Secretary of Defense">
<addressLine2>1400 Defense Pentagon</addressLine2>
<!-- Don't want this -->
<Note>I'd rather have Rumsfeld back</Note>
<Note>Just another private note</Note>
View Complete Post