如何使用SQL Server递归获取节点的XPath？

I'm tired of looking at possibly the ugliest SQL statement I've ever built and need your help. I am searching through an XML document for various elements and want to see their XPaths. The query below works by brute force, but I cannot come up with a way to create a function or CTE that will properly support N levels.I'm tired of looking at possibly the ugliest SQ