CTE Hierarchy compared to the alternative
After my CTE presentation a while back I was asked many questions, and received several great suggestions from people. One question was how does the performance compare between a recursive CTE to generate a hierarchical tree path listing and …