You cannot reference the new alias as it does not exist yet.

Below is 1 way of accessing it

WITH cteBase AS (
    SELECT DISTINCT 
...

The EXISTS was...

Again, this code is untested, as there is no sample structure or data to work with.

Using a Join

WITH cteBase AS (
  SELECT b."start_dtg", b."end_dtg"
  FROM...

Without sample data, this is untested code.  That said, it appears to be a very simple update

UPDATE b
SET [invalid] = 0
FROM tableB AS b
INNER JOIN tableA AS...

Hi DesNorton,

It's almost working; at least it is appending Year_ to EventYear.

However, I am getting the following error:

Msg 207, Level 16, State 1, Line 30

Invalid column name 'Year_2019'.

Do I...

You could look at simply adding the "Year_" prefix at the point where you substitute it into the DSQL.  I have removed most of the meat from your query to...

There aren't too many people that will open an Excel file.

Please provide your sample data and requirements as SQL scripts.

Miss Daisy

I suspect that the implicit conversion is causing an issue.

Does this work?

WHERE vaoq.Questionnaire_ID = CONVERT(uniqueidentifier, '09C4C7B4-1275-460A-AE23-FFA9256B1ABE')

Go

Sonic

To see if that problem may be present, please execute the following code and report the results, please.

 SELECT  MinLen = MIN(DATALENGTH(log_message))
   ...

You could also try outputting the results directly to file

Also, do not prefix your stored procedure with sp_.

This has a performance impact, as SQL assumes that your proc is in the master DB.

What is the data type of your DOB field?