May 29, 2019 at 7:46 pm
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.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply