Browse by Tags

All Tags » xml (RSS)
Monday, September 22, 2008 3:19 PM

Tabular XML Data to Hierachical XML Data Translation with XSLT

On previous post , we discussed creating a hierarchical XML from tabular data using only T-SQL. On this post, we'll explore transforming tabular data in XML format to a hierarchical XML format using purely XSLT. Let's say that we have an XML that...
Posted by Jimmy Chandra | with no comments
Filed under:
Tuesday, August 12, 2008 4:53 PM

Transforming Denormalized Tabular Data to Hierarchical XML Using SQL Server (2005)

A friend of mine asked me today if there is any easy way to transform a table / query result that is quite tabular like the one in the table below to a hierarchical XML format just by using T-SQL query. Id Product Activity 1 Product A Activity A 2 Product...
Posted by Jimmy Chandra | 2 comment(s)
Filed under: ,