560How to Merge XML CTE's in SQL

698Why am I getting null values f