This might get you started
😎
SELECT
PROP.DATA.value('local-name(../.)','VARCHAR(100)') AS Parent_element
,PROP.DATA.value('local-name(.)','VARCHAR(100)') AS Element
,PROP.DATA.value('(@*)[1]','VARCHAR(100)') AS Parameter_Value
FROM @TXML.nodes('//*:Property') PROP(DATA)
;
Thanks, But when I try it I get an error:
XQuery [nodes()]: No more tokens expected at the end of the XQuery expression. Found 'Property'.
Any idea?