soozh

<div>
Very interesting solution. &nbsp;I have now solved it another way but i like what you have done. 
 
Thanks.
</div>

Very interesting solution.  I have now solved it another way but i like what you have done.

Thanks.

<div>
<div class="content wysiwyg-content">
i am trying to produce an xml from a table and i am having trouble when trying to include column values as child nodes. 
 
The table has many columns but I am having trouble with four columns that have to be nested in a child node. &nbsp;These are the columns and they are all of type bit. 
 
They are: 
 
[RiskInflam] 
[Vascularisation] 
[Glaucoma] 
[RiskAnnan] 
 
I need to produce the xml in the format 
&lt;RiskFactors&gt; 
&nbsp; &lt;RiskFactor&gt;&lt;/RiskFactor&gt; 
&lt;/RiskFactors&gt; 
 
So when the row has the following values: 
 
[RiskInflam] &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;1 
[Vascularisation] &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;0 
[Glaucoma] &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;1 
[RiskAnnan] &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;0 
 
I need to produce: 
&lt;RiskFactors&gt; 
&nbsp; &lt;RiskFactor&gt;RF_RiskInflam&lt;/RiskFactor&gt; 
&nbsp; &lt;RiskFactor&gt;RF_Glaucoma&lt;/RiskFactor&gt; 
&lt;/RiskFactors&gt; 
 
This is embedded in an xml document with other columns. 
 
&lt;LS2ECCTR xmlns:xsi=&quot;<a href="http://www.w3.org/2001/XMLSchema-instance" rel="ugc">http://www.w3.org/2001/XMLSchema-instance</a>&quot;&gt; 
&lt;Version&gt;1&lt;/Version&gt; 
&lt;LS-ID&gt;1234567890&lt;/LS-ID&gt; 
…. Risk factors….. 
&lt;/LS2ECCTR&gt; 
 
I am not sure of the sql/xml syntax to produce this. &nbsp;Can anyone help?
</div>
</div>

i am trying to produce an xml from a table and i am having trouble when trying to include column values as child nodes.

The table has many columns but I am having trouble with four columns that have to be nested in a child node. These are the columns and they are all of type bit.

They are:

[RiskInflam]
[Vascularisation]
[Glaucoma]
[RiskAnnan] 

I need to produce the xml in the format
<RiskFactors>
 <RiskFactor></RiskFactor>
</RiskFactors>

So when the row has the following values:

[RiskInflam]		1
[Vascularisation]	0
[Glaucoma]		1
[RiskAnnan] 		0

I need to produce:
<RiskFactors>
 <RiskFactor>RF_RiskInflam</RiskFactor>
 <RiskFactor>RF_Glaucoma</RiskFactor>
</RiskFactors>

This is embedded in an xml document with other columns.

<LS2ECCTR xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<Version>1</Version>
<LS-ID>1234567890</LS-ID>
…. Risk factors…..
</LS2ECCTR>

I am not sure of the sql/xml syntax to produce this. Can anyone help?

SQL statement to produced xml of table

Extensible Markup Language (XML) refers to the encoding of documents such that they can be read by both machines and humans. XML documents use tags to show the beginning and end of a set of data. XML is used extensively on websites to show volumes of data, and is the default for a number of office productivity suites. This topic includes discussions of XML-related technologies, such as XQuery (the XML Query language), XPath (the XML Path language), XSLT (eXtensible Stylesheet Language Transformations), XLink (the XML Linking language) and XPointer (the XML Pointer language).

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.