17.4.13

Create a HTML Table with TSQLXML - SQLServer

Just a simple query to return a HTML Table from a recordset using SQLXML in SQLServer.

Lets take this table as example:


  Issue  | Status  | 

----------------------
  one    | Active  | 
  two    | Active  |  

And this query:


SELECT (SELECT 'Issue' AS 'TH' FOR XML PATH(''),TYPE),
       (SELECT 'Status' AS 'TH' FOR XML PATH(''),TYPE)
UNION ALL         
SELECT (SELECT IS.ISSUE AS 'TD' FOR XML PATH(''),TYPE),
       (SELECT IS.STATUS AS 'TD' FOR XML PATH(''),TYPE)
FROM   ISSUES IS
       FOR XML PATH('TR'),ROOT('TABLE'),TYPE
GO


Will return something like:

<table>
<tr><th>ISSUE</th><th>STATUS</th></tr>
<tr><td>one</td><td>Active</td></tr>
<tr><td>two</td><td>Active</td></tr>
</table>

And that's all.

Creative Commons License This page is powered by Blogger. Isn't yours?