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)