1.04kHow to Merge XML CTE's in SQL

1.13kWhy am I getting null values f