I have the following CTE's, and I'm trying to combine XML1 and XML2 CTE's in Sql Server by their common refid key.