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 (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)