Listing Tree Recursive

WITH itemgoodsdeptHistory AS
(
    -- Anchor member: 找到指定员工
    SELECT DeptID,ParentID,DeptName,treeItem,addby FROM itemgoodsdept WHERE deptid = '00757'
    UNION ALL
    -- Recursive member: 找到下级员工
    SELECT e.DeptID, e.ParentID, e.DeptName,e.treeItem,e.addby
    FROM itemgoodsdept e  INNER JOIN itemgoodsdeptHistory eh ON e.parentID = eh.Deptid
)
select * from itemgoodsdeptHistory;

--delete from itemgoodsdept where deptid in (
--select deptid from itemgoodsdeptHistory);