Dynamic Hierarchical Reporting with Recursive Common Table Expressions

Design a complex recursive CTE that can generate a multi-level organizational hierarchy report with depth-based salary calculations. The solution must dynamically handle organizational restructuring, calculate total compensation rollups, and support variable depth reporting. Include performance optimization techniques for large organizational datasets (50,000+ employees), and implement error handling for circular reference scenarios.