with org(OrgID,OrgName,ParentID,[level])
as
(
select orgid,orgname,parentid,0 as [level] from SYSOrg
where orgname like ''%'+ @DW +'%''
union all
select a.OrgID,a.OrgName,a.ParentID,[level]=1 from SYSOrg as a
inner join org as b
as
(
select orgid,orgname,parentid,0 as [level] from SYSOrg
where orgname like ''%'+ @DW +'%''
union all
select a.OrgID,a.OrgName,a.ParentID,[level]=1 from SYSOrg as a
inner join org as b
on a.ParentID = b.OrgID)
select * from org