Welcome to XQuery Lab 47. In this lab, we will see how to generate an HTML table from an XML document, using XQuery.
Here is the source data:
<CUST COMPANY="Company1" CONTACT="Jacob" /><CUST COMPANY="Company1" CONTACT="Michael" /><CUST COMPANY="Company3" CONTACT="Steve" />
Here is the output required
<table> <tr> <td>Company</td> <td>Contact</td> </tr> <tr> <td>Company1</td> <td>Jacob</td> </tr> <tr> <td>Company1</td> <td>Michael</td> </tr> <tr> <td>Company3</td> <td>Steve</td> </tr></table>
Here is the TSQL code using XQuery to generate the required output.
DECLARE @x XMLSELECT @x = '<CUST COMPANY="Company1" CONTACT="Jacob" /><CUST COMPANY="Company1" CONTACT="Michael" /><CUST COMPANY="Company3" CONTACT="Steve" />'SELECT @x.query(' <table> <tr> <td>Company</td> <td>Contact</td> </tr> { for $r in CUST return <tr> <td>{data($r/@COMPANY)}</td> <td>{data($r/@CONTACT)}</td> </tr> } </table>')/*<table> <tr> <td>Company</td> <td>Contact</td> </tr> <tr> <td>Company1</td> <td>Jacob</td> </tr> <tr> <td>Company1</td> <td>Michael</td> </tr> <tr> <td>Company3</td> <td>Steve</td> </tr></table>*/
Next Lab: XQuery Lab 48 - Sorting Query files in SQL Server Management Studio (SSMS) Solution/Project
Previous Lab: XQuery Lab 46 – Extracting Zip Code from an Address Value
View All Labs: XQuery Labs - A Collection of XQuery Sample Scripts and Tutorials
Tags: XQuery-Functions, XQuery-Labs, XML, XQuery, XQuery Functions, SQL Server XQuery, XQuery in TSQL, XQuery Training, XQuery Tutorial,