710How to Merge XML CTE's in SQL

838Why am I getting null values f