Viewing 3 posts - 1 through 3 (of 3 total)
mfconners - Thursday, January 10, 2019 5:31 AMReplace:
FROM @TXML.nodes('ACES/App') APP(DATA);With something like this:
FROM dbo.XML_Staging AS stg
CROSS APPLY stg.TXML.nodes('ACES/App') APP(DATA);
I was posting...
January 10, 2019 at 5:37 am
Replace:
FROM @TXML.nodes('ACES/App') APP(DATA);
With something like this:
FROM dbo.XML_Staging AS stg
CROSS APPLY stg.TXML.nodes('ACES/App') APP(DATA);
January 10, 2019 at 5:31 am
November 14, 2018 at 6:10 am
Viewing 3 posts - 1 through 3 (of 3 total)