如何在SQL Server中有效地合并两个层次结构？

I have two tables with hierarchyid fields, one of which is a staging table with new data that needs to be merged into the other (that is, a set of nodes that need to be added to the main tree, some of which might already be there).I have two tables with hierarchyid fields, one