This is elementary my dear Phil, your illness must have been quite serious 😉
😎

;WITH BASE_DATA AS
(
  SELECT
   T.Id
   ,X.CV
  ...

How many columns are in the actual data set?
😎

Here is a version with 0
😎

USE TEEST;
GO
SET NOCOUNT ON;

DECLARE @tbl_value TABLE (Code INT NOT NULL,Name VARCHAR(10) NOT NULL);
INSERT...

Quick suggestion (if I understood the requirements correctly)
😎

USE TEEST;
GO
SET NOCOUNT ON;

DECLARE @tbl_value TABLE (Code INT NOT NULL,Name VARCHAR(10) NOT NULL);
INSERT...

Strange, when I try this link to a thread https://www.sqlservercentral.com/Forums/FindPost1853845.aspx I get an error that the topic cannot be accessed but this here is fine https://www.sqlservercentral.com/Forums/1852932/Comma-separated-list#bm1853853

Has that specific post...

Quick (obvious) thought if the JSON column is NULL then you may want to use OUTER APPLY
😎

USE TEEST;
GO
SET NOCOUNT ON;

IF OBJECT_ID('tempdb..#tmp',...

Just a quick thought, if you don't know the actual structure of the XML but you do know the name of the node element and a property value of that...

You are very welcome
😎

I did post few resources few weeks back on this thread

Those two schemas are not the same
😎

Original schema
   
                                   +--------------------+
                                   | Execution          |
                                   +--------------------+
   +--------------------+          | Execution_id       |-+-----------,                                              
   | Questionnaire      |     ,--+<| questionnaire_name |             |                                 
   |--------------------|     |    | Execution_date     |             |        +--------------------+                        
   | Questionnaire_name |-+---|    +--------------------+             |        | Execution_answer   |                        
   +--------------------+     |                                       |        +--------------------+
                              |    +------------------------------+   '------+<| Execution_id       |  
   +---------------+          |    | Questionnaire_question_usage |   ,------+<| questionnaire_name |  
   | Question      |          |    +------------------------------+   | ,----+<| question_id        |
   +---------------+          '--+<| Questionnaire_name           |>+-' |      | answer_text        |
   | Question_id   |-+-----------+<| Question_id                  |>+---'      +--------------------+
   | Question_text |               +------------------------------+