ClrXmlShredder

Modified on 2011-07-05 08:25 by TaoK — Categorized as: C#, dotNet 2, SQL

Overview

This is a Sql Clr stored procedure for converting Xml created by a FOR XML clause back into a single tabular resultset, with one stored procedure call without knowledge of the original table/query schema.

More detail (installation/deployment, examples, etc) is available in the source file itself, included below.

Download

Source file (v1.0.2): ClrXmlShredder.cs.zip (or just use the Gist below)
Precompiled binary, if you can't or don't want to compile it yourself: ClrXmlShredder.dll.zip

Source (gist)

(if you don't see anything here, please hit F5 / refresh the page, as some browsers fail to show the "gist" on the first page load)