I stand to be corrected, but rumor has it that FULLZ are leaked personal details,...

The correct answer is not available as an option

The following SQL will help you to shred the xml.  You can then work on formatting it as you need.

DECLARE @xmlData xml = '<Data>
  <Monthly_x0020_Income>
 ...

Alternatively, you can rewrite the query to repeat the CASE statement

SELECT DISTINCT 
    ph.STARTDATE
  , ph.SERIALNUMBER
  , dc.DESTINATIONGROUP
  , pi.PLEDGEID
 ...

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