Dynamic Hierarchical Performance Reporting with Recursive CTE

Design a recursive Common Table Expression (CTE) that can dynamically generate a multi-level organizational performance report, tracking employee performance metrics through nested management hierarchies. The solution must handle unlimited organizational depth, calculate aggregate performance scores, and include percentage comparisons between different levels of management. Include error handling for potential circular references and performance optimization techniques for large organizational datasets.