查找担保圈-step3-获取担保圈路径

USE [test]
GO
/****** Object:  StoredProcedure [dbo].[p01_get_group_path]    Script Date: 2019/7/8 14:40:47 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROC [dbo].[p01_get_group_path]
AS
--s1，获取担保圈路径
IF OBJECT_ID(N'dbo.t01_get_group_path') IS NOT NULL
    DROP TABLE dbo.t01_get_group_path;

SELECT t.full_path,
       t.nlevel,
       ROW_NUMBER() OVER (ORDER BY t.full_path) AS groupno
INTO dbo.t01_get_group_path
FROM
(
    SELECT DISTINCT
           b.full_path,
           b.nlevel
    FROM [dbo].[dbgx] AS a
        CROSS APPLY [dbo].[f_findrecycle](a.KHMC, 10) AS b
--WHERE     a.KHMC IN ( '山东郓城卡德维润滑油有限公司', '郓城惠达化纤制品有限公司',
--                      '郓城县久隆塑料制品有限公司', '郓城海鹏鞋业有限公司', '郓城昌顺机械有限公司',
--                      '郓城恩银机械有限公司' )
) AS t;