If you are able to influence the development from the off, then I would go with TVP as shreding XML is very expensive.

There are lots of resources on this very...

Love the "maybe" option! made me think twice before answering 🙂

You can solve this by shreding the data into the two tables by using the nodes functions. I have created this example:

--create our tables

CREATE TABLE Jobs (JobCode INT PRIMARY KEY...

Great question!

That's odd then.. When i pass your "Current Result" xml example through that style sheet, it outputs...

I'm not very good at XSL myself, but does this get you what you need?

<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:a="test_3">

<xsl:output method="xml" indent="yes" omit-xml-declaration="yes"/>

<xsl:template match="/">

<xsl:copy><xsl:apply-templates select="/a:Report/a:Document"/></xsl:copy>

</xsl:template>

<xsl:template match="*">

...

Have you got an example before/after xml that you can post as that may help

No problem.. thank you for the nice feedback.. 🙂

Hi, I've just come up with this... does this help with what you need:

declare @xml xml = '<root>

<elem10 Attr01="9.00" Attr02="9.00" Attr03="9.00" Attr04="9.00" Attr05="9.00" Attr06="9.00">

<elem101010 Attr01="9.00" Attr02="9.00" Attr03="9.00" Attr04="9.00" Attr05="9.00" Attr06="9.00">

<elem10101010...

Hi. when you are specifying xpaths (that is the xml path to the node you want), you need to specify either the full path to the xml node that you...

Hi.. I'm glad I could help 🙂

Ok, we don't need to transform the xml first via xquery if you only want to shred the xml to a flat table. from your original post it appeared that...

It doesn't get dumped anywhere, it is just a select query.

To insert the transformed xml into a table, just add an insert statement before the select i.e.

;with xmlnamespaces ('urn:com.workday/bsvc' as...

Hi. That snippit of xml that you have pasted seems to be a little different to your original xml that you posted earlier on.

Try this updated version of the query...

You'll need to read the xml data in from the file to a variable before running the example that I posted earlier.

Reading in the data is quite straight forward...