ms-sql 재귀호출(start with)

WITH dept_CTE AS (
SELECT 1 as dispseq, dept_id, dept_name, parent_dept_id,COMPANY_ID
FROM adm_dept
WHERE parent_dept_id = '' // 최상위 부모노드
UNION ALL
SELECT dc.dispseq + 1 as dispseq, d.dept_id, d.dept_name, d.parent_dept_id,d.COMPANY_ID
FROM adm_dept d
INNER JOIN dept_CTE dc
ON dc.dept_id = d.parent_dept_id
)
SELECT a.dispseq, a.dept_id, a.dept_name, a.parent_dept_id,a.COMPANY_ID
FROM dept_CTE a