USE [test]

 GO

 /****** Object:  StoredProcedure [dbo].[p05_get_group_member_cleared]    Script Date: 2019/7/8 15:32:01 ******/

 SET ANSI_NULLS ON

 GO

 SET QUOTED_IDENTIFIER ON

 GO

 ALTER PROC [dbo].[p05_get_group_member_cleared]

 AS

 --s5，提取未被包含过组的成员，得出结论

 BEGIN

     IF OBJECT_ID(N'dbo.t05_get_group_member_cleared') IS NOT NULL

         DROP TABLE dbo.t05_get_group_member_cleared;

     SELECT groupno AS 组编号,

            id AS 组内编号,

            cust_name,

            nlevel AS 成员数

     INTO dbo.t05_get_group_member_cleared

     FROM [dbo].t02_get_group_member AS a

     WHERE [groupno] IN (

                            SELECT iinclude_groupno FROM dbo.t04_get_groupno_cleared

                        );

 END;