This looks like relatively simple XML, you should just use XQuery to parse it
😎Something like this:
SELECT
REPORT.DATA.query('.')
FROM @TXML.nodes('Reports/Report') AS REPORT(DATA)
Thanks, Let me dig further from this solution.
You'll find several examples on this forum, feel free to ping back if you have any problems.
😎