Hi Alan,

Many thanks for the code you have provided. I am still evaluating how to apply this to an existing table, but I do have an observation.  If there is...

• This reply was modified 2 months ago by  SqlRookie.
• This reply was modified 2 months ago by  SqlRookie.

Thank you all for your detailed feedback.  I shall use this when we eventually get 2022!

Have posted this in 2019 forum.

Many thanks.

Thank you for clarifying Phil. 🙂

I see.  This is what it's giving me:-

Version Level Edition

15.0.4261.1 RTM Enterprise Edition (64-bit)

Version Level Edition

15.0.4395.2 RTM Enterprise Edition (64-bit)

Many thanks Phil.

I have SQL Server Management Studio v19.0.1 and 18.12.1 installed. Are these compatible?

Thank you Phil, Scott and Steve for your informative and concise replies!  Much appreciated.

I'm struggling with one thing: dbo.DelimitedSplit8K.  What is this?

Many thanks! 🙂

Footnote... Steve: I'm getting this error for...

• This reply was modified 2 months ago by  SqlRookie.
• This reply was modified 2 months ago by  SqlRookie.

Yes my fault, I should have compiled my original question better, my apologies.

So for each row of data there is this XML column and a REF_NO column.  Each REF_NO will...

Good morning Mark,

Thank you so much for your assistance with this.  It works a treat!

However, there is one final part to this.  When applying the code to my overall view,...

Many thanks for the reply Mark.

I am getting the following error with the STRING_AGG function:-

"Msg 195, Level 15, State 10, Line 8

'string_agg' is not a recognized built-in function name."

I have...