1.01kHow to Merge XML CTE's in SQL

1.11kWhy am I getting null values f