该如何把Oracle start with 改 sqlserver？能实现吗？

Question

select distinct o.orgid from baf_org_organization o CONNECT BY prior o.parentorgid = o.orgid START WITH o.orgid='11' and o.isvalid='Y';

Answer 1

with temp(orgid,parentorgid) as(select distinct o.orgid,o.parentorgid from baf_org_organization o where o.orgid='11' and o.isvalid='Y'union allselect distinct o.orgid,o.parentorgid from baf_org_organization oinner join temp b on o.parentorgid = b.orgid)select orgid from temp试下，对Oracle的语法不是太了解，我理解的是这个意思。

Answer 2

sqlserver没有这个写法