XML Path 1

[Cobby1812]

Hi there,
I have been trying to create a sql script to allow me to take data out of sql and into another system. I am about 70% there when I hit this.

The XML I need to create should show thus
<Section SectionCode="CL">

However I can only get mine to show as
<SectionSectionCode>CL</SectionSectionCode>

This is the sql

'CL' as [Case/CaseInformation/Section/SectionCode]

I cant think how to get it like this
<Section SectionCode="CL">

Any one any idea's

 

[tsuji]

With that kind of abstraction, you may have a better chance to get understood and grilled in mssql forum:

http://www.tek-tips.com/threadminder.cfm?pid=183

 

[tsuji]

This is the correct path construction.
[tt] 'CL' as [Case/CaseInformation/Section/[blue]@[/blue]SectionCode][/tt]