583How to Merge XML CTE's in SQL

723Why am I getting null values f