I notice that there's no mention of product sales … hence your reference to 'factless', I assume.

Are you therefore simply building a 'Product cube'?

What sort of reporting/analysis are you intending...

This article is a bit terse.

Tested and still broken on V20.1

The best type of solution 🙂

Have you tried putting the script task outside of the sequence container?

Interestingly, the desired output is however considered valid JSON, at least according to https://jsonlint.com/

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 1 years, 6 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 1 years, 6 months ago by Phil Parkin.