FOR XML RAW results back to rows & Columns

  • Is there a simple way to take the results of a query that have been converted to xml  with FOR XML RAW back into columns & Rows? I am working on storing the results of several queries around user permissions from a handful of different applications , and rather than having to create a custom table for each applications permissions, I would prefer to store them as a single XML result and then re-expand them back to columns and rows for reporting purposes.  Everything I have been looking at around XML shows stuff using the nodes or xpath queries, but I was wondering if there was some kind of standard way to expand everything back out without having to specify all the nodes for each different type of result set.

  • The closest that I've seen is to use the OPENXML command specifying a table name (Example E).

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply