查找担保圈-step7-提取未被包含过组的成员,得出结论
1 USE [test] 2 GO 3 /****** Object: StoredProcedure [dbo].[p05_get_group_member_cleared] Script Date: 2019/7/8 15:32:01 ******/ 4 SET ANSI_NULLS ON 5 GO 6 SET QUOTED_IDENTIFIER ON 7 GO 8 ALTER PROC [dbo].[p05_get_group_member_cleared] 9 AS 10 --s5,提取未被包含过组的成员,得出结论 11 BEGIN 12 IF OBJECT_ID(N'dbo.t05_get_group_member_cleared') IS NOT NULL 13 DROP TABLE dbo.t05_get_group_member_cleared; 14 15 SELECT groupno AS 组编号, 16 id AS 组内编号, 17 cust_name, 18 nlevel AS 成员数 19 INTO dbo.t05_get_group_member_cleared 20 FROM [dbo].t02_get_group_member AS a 21 WHERE [groupno] IN ( 22 SELECT iinclude_groupno FROM dbo.t04_get_groupno_cleared 23 ); 24 END;
posted on 2019-07-08 15:33 hold_on_up 阅读(134) 评论(0) 编辑 收藏 举报