I've just been trying a few things and couldn't make it work.

It seems that the T-SQL JSON functions deem any string containing a single / character as invalid and escape...

I tried to follow your logic for the row where ID = 5.

- IN --->> 2024-12-16
- (4 AMOUNT * 85 PRICE)+(5 BALANCEO * 85 )/ (BALANCE  9) ...

It would be interesting to understand what this data represents.

As all of the rows have Code 0001, do they all refer to the same object? And yet the price changes...

Try surrounding the server name with double quotes

Would you care to expand on this comment, please?

I am currently migrating...

Try this instead

    CROSS APPLY sx.XMLDoc.nodes ('root/Header') C(x)
    CROSS APPLY sx.XMLDoc.nodes ('root/PurchaseOrder') d(y)
    CROSS APPLY y.nodes ('PurchaseOrderLine') e(z)
CROSS...

• This reply was modified 2 years, 4 months ago by Phil Parkin.

See whether this helps.

DROP TABLE IF EXISTS #SomeXML;

CREATE TABLE #SomeXML
(
    XMLDoc XML
);

INSERT #SomeXML
(
    XMLDoc
)
VALUES
('<root>
  <Header>
    <xxxxxName>yyyyy</xxxxxName>
 ...

You should consider heading over to https://www.brentozar.com/pastetheplan/instructions/ and adding your actual execution plan there.

It would also be helpful if you would include the full DDL for the tables involved. Include...

I don't have time to dig into this, but there is an error in the query.

LEN('L') will always equal 1, because that's how long 'L' is.

You should also remove the...

• This reply was modified 2 years, 4 months ago by Phil Parkin.

If you want a coded solution, please provide a (sanitised as needed) version of the XML doc, not an image!

• This reply was modified 2 years, 4 months ago by Phil Parkin.

Requirements are fairly loose Eirkur. Investigate the storing of Excel documents either in Sql Server or a fileshare (on a different server to the Sql one), whichever is best....

Folders in Workspaces is now in Preview.

No need for SSAS, now that there are semantic models.

IMO, migrating to Power BI 'Tabular Reports' from SSRS is super simple and worth investigating.

DF does not replace SSIS, however. We have tried to migrate and failed (and gone back...

Did you try BISM Normalizer? Looks like the schema compare...

Are you looking to store the entire file as a single BLOB, or import its contents as individual columns?