836How to Merge XML CTE's in SQL

957Why am I getting null values f