Author: SSWUG Research


Expanding Hierarchies

Microsoft has expanded the information about expanding hierarchies in SQL Server Books Online (BOL) since SQL Server 6.x. But the BOL solution merely displays the output; you can’t join the results with other views, tables, or results. My T-SQL coding solution fills this gap. Also, the solution I pr


How to Encode XML Data

This article explains how character encoding works and specifically how it works in XML and the MSXML DOM. A lot of people have been asking me questions lately about how to make their XML files transfer data properly between different platforms. They create an XML document, type in data, stick a few