IDEAS IN WORDS
A blog about Information Systems and Software
ALL
GENERAL
NEWS
BUSINESS
IN GENERAL
E-COMMERCE
OPERATIONS and SUPPLY CHAIN
SOFTWARE ENGINEERING, TALENT
PROGRAMMING
DATABASE
XML/XSL
LAB
NodeJS Object Database

XML
XSL for Converting Flat XML to Hierarchial XML
Just for the reference of XML, XSL enthusiasts, I will quickly demonstrate how you can convert a flat XML file to a hierarchial XML with nested nodes. When hierarchy is the focus, there can be many different XML structures, but for the sake of simplicity, I have chosen the below example. This example assumes that you have ID, PARENTID and LEVEL attributes in each node, and PARENTID being 0, blank or null means that the employee node is a root node. To achieve this conversion, we have to know the root nodes.
Read More
XML-XSL Transformations in SQL Server
With the release of Master Data Services (MDS) for SQL Server 2008R2, it is now possible to perform XML transformations on the database server. Even though, it may sound as a bad idea to perform such operations on the database level instead of clientside, one can certainly find useful cases for this functionality.A database configured with MDS, simply contains some CLR assemblies and UDF functions that make use of these assemblies.
Read More
SHARE PAGE