Viewing 15 posts - 1 through 15 (of 28 total)
Until I can get my MERGE statement working if ever 🙁, I have the below tacky loop but it seems to work
DECLARE @patch TABLE (
October 19, 2018 at 6:26 pm
October 19, 2018 at 6:01 pm
October 19, 2018 at 11:14 am
Will the...
October 15, 2018 at 4:51 pm
October 15, 2018 at 6:06 am
I would test that against your queries. I have not found any significant...
October 14, 2018 at 1:51 pm
October 14, 2018 at 8:24 am
I've already posted...
October 13, 2018 at 9:57 am
@frederico_fonseca. Sorry, I didn't see your reply and edited my...
October 13, 2018 at 7:32 am
Yes....I think you mean what I have below...and I think it works...
SELECT M.id, M.something--, M.xmlData
FROM dbo.Test M
CROSS APPLY xmlData.nodes('/Data/*') T(c)
JOIN @match p ON...
October 13, 2018 at 6:37 am
Some progress! I feel I'm closer to the solution. Not using XMLTable since it's just more clutter than I need. The 'NodeRef' column in the results I have provided just...
October 13, 2018 at 5:45 am
October 13, 2018 at 5:06 am
October 13, 2018 at 5:02 am
Yeah, that makes sense. Thanks Sue.
I'm also hoping it will help me right a JsonTable function.
September 12, 2018 at 3:59 pm
Viewing 15 posts - 1 through 15 (of 28 total)