Here are 4 scripts.
Table creation.sql.
CTE Organization Chart.sql - Create Organization chart logic using CTE Recursion
CTE Organization Chart.sql - Create Organization chart step by step showing all needed querys
Organization Chart Logic.sql - Optimized sql query without CTE recursion, with the recursion CTE logic.
I hope you enjoy it.