<div>
Thanks for the help. &nbsp;I had to add some isnull statements because some of the columns had null values...
</div>


Thanks for the help.  I had to add some isnull statements because some of the columns had null values...

<div>
<div class="content wysiwyg-content">
Hello,<br />
<br />
I have a table (see below) that contains a series of name/value pairs for a document. &nbsp; The document is identified by the DocumentId column. &nbsp;The name and values are given by the FieldName and FieldValue columns. &nbsp;There is also a column called Changed (which is true when the FieldValue has been changed).<br />
<br />
I need to produce an XML document like that shown below the table. &nbsp; The elements are the name/value pairs. &nbsp;Note that Changed must be an attribute of the element.<br />
<br />
Do i need to pivot the data first, and then generate the xml?<br />
<br />
How should the query look like? <br />
<br />
<br />

<pre><code id="code-10-28486794-1">Id	DocumentId	FieldName	FieldValue	                       Changed
161	9	                 text1		 Another form.	                        0
163	9	                 text2		 Soon it is time for lunch.!.	       1
165	9	                 colour		 3	                                          0</code></pre>
<br />

<pre><code id="code-10-28486794-2">&lt;Dataset&gt;
&lt;DocumentId&gt;9&lt;/DocumentId&gt;
&lt;text1 changed=”0”&gt;Another form&lt;/text1&gt;
&lt;text2 changed=”1”&gt; Soon it is time for lunch.!&lt;/text2&gt;
&lt;colour changed=”0”&gt;3&lt;/color&gt;
&lt;Dataset&gt;</code></pre>
</div>
</div>


Hello,

I have a table (see below) that contains a series of name/value pairs for a document.   The document is identified by the DocumentId column.  The name and values are given by the FieldName and FieldValue columns.  There is also a column called Changed (which is true when the FieldValue has been changed).

I need to produce an XML document like that shown below the table.   The elements are the name/value pairs.  Note that Changed must be an attribute of the element.

Do i need to pivot the data first, and then generate the xml?

How should the query look like? 


(CODE)

(CODE)

Query syntax

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.

Microsoft SQL Server 2008

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.