22,210
社区成员
发帖
与我相关
我的任务
分享
create table huiyuan
(
hyh int,
tjhyh int,
ld bit
)
insert into huiyuan values (1,0,1)
--1号会员的直属下线
insert into huiyuan values (2,1,0)
insert into huiyuan values (3,1,0)
insert into huiyuan values (4,1,1)
insert into huiyuan values (5,1,0)
--1号会员下线是领导,这个领导的下线
insert into huiyuan values (6,4,0)
--1号会员下线非领导
insert into huiyuan values (7,2,0)
insert into huiyuan values (8,2,0)
insert into huiyuan values (9,2,0)
insert into huiyuan values (10,2,0)
insert into huiyuan values (11,3,0)
--非推荐会员,也就是没有人推荐他
insert into huiyuan values (12,0,0)
--1号会员所有的下线
;with cte(hyh,tjhyh) as
(select hyh,tjhyh from HuiYuan where hyh=1
union all
select huiyuan.Hyh,huiyuan.tjhyh from HuiYuan,cte
where cte.hyh=HuiYuan.tjhyh
)
select * from cte