ALTER FUNCTION [mrsk].[check_sub_docs](	@doc_link int
)
RETURNS @docs TABLE(
	whose INT
	, LINK INT
	, doc_type INT
	, contract_status INT
	, level INT
) AS
BEGIN
	;WITH Childs(whose, LINK, doc_type, contract_status, Level) as (
		SELECT
			d.link, d.link, d.F_Docum_Types, d.F_Contract_Status, 1
		FROM dbo.DD_Docs d
		WHERE
			LINK = @doc_link
		UNION ALL
		SELECT
			c.whose, d.link, d.F_Docum_Types, d.F_Contract_Status, c.Level + 1
		FROM dbo.DD_Docs d
		JOIN Childs c ON c.whose = d.F_Docs
	)
	INSERT INTO @docs
	SELECT * FROM Childs
	OPTION (MAXRECURSION 777);
	RETURN
END

SELECT
	TP_LINK
	, CASE WHEN 
		EXISTS( SELECT 1 FROM mrsk.check_sub_docs(DD_LINK) WHERE doc_type = @DST_Route_List_Invent AND contract_status NOT IN( @CS_Done, @DCS_Cancelled_Out) )
			THEN 1 ELSE 0 
	END not_finished
FROM #temp

ALTER FUNCTION [mrsk].[check_sub_docs](	@doc_link int
)
RETURNS @docs TABLE(
	whose INT
	, LINK INT
	, doc_type INT
	, contract_status INT
	, level INT
) AS
BEGIN
	;WITH Childs(whose, LINK, doc_type, contract_status, Level) as (
		SELECT
			d.link, d.link, d.F_Docum_Types, d.F_Contract_Status, 1
		FROM dbo.DD_Docs d
		WHERE
			LINK = @doc_link
		UNION ALL
		SELECT
			c.whose, d.link, d.F_Docum_Types, d.F_Contract_Status, c.Level + 1
		FROM dbo.DD_Docs d
		JOIN Childs c ON c.LINK = d.F_Docs
	)
	INSERT INTO @docs
	SELECT * FROM Childs
	OPTION (MAXRECURSION 777);
	RETURN
END