This post was flagged by the community and is temporarily hidden.
you can't just dump text in here and expect a reasonable response. Can you post a sample of what the data looks like and what you expect as a result.
Declare @x xml = 'XML data'
and then expected results