927How to Merge XML CTE's in SQL

1.04kWhy am I getting null values f