Jeff and others that referred me to Nested Sets...thank you! I did find an article on Nested Sets as well. Jeff, I appreciate the links and explanation as well.
Yeah...see my other comment. We are definitely trying to fix our resource problem in Starburst and use CTEs; however, this problem might be fun to try and solve.
Yeah....I agree. I didn't think we could get the resource issue fixed for running the CTE solution. It's in Starburst, not SQL Server. But, thank you. This would be a...