You are very welcome Rob and thanks for the feedback.
😎

Just a quick thought, you should add the TYPE directive and the value method if there are any characters within the concatenated text that would be encoded in the FOR...

Quick question, is there enough free space on the drive for the database?
😎

Here is one possible solution
😎

USE TEEST;
GO
SET NOCOUNT ON;

-- SAMPLE DATA SET
IF OBJECT_ID(N'dbo.TBL_XML_DOC') IS NOT NULL DROP TABLE dbo.TBL_XML_DOC;
CREATE TABLE dbo.TBL_XML_DOC

Are there more than one elements with that name in the XML document?
😎

Further on the schema I posted previously

Questionnaire
An instance of a collection of questions and their properties.

Question
Individual unique questions and their properties. ...

I see many problems here and my first thought is that a re-iteration of the business requirement analysis should be the next step. The schema itself is over simplified for...