workflow.Workflow_ProcedureDependency_T_bidirectional_T - U

Declare @updated Int = -1;

While @updated <> 0
Begin
    Update
        T1
    Set
        T1.is_redundant = 1
    From
        workflow.Workflow_ProcedureDependency_T               As T1
        Inner Join
            workflow.Workflow_ProcedureDependency_T_redundant As T2
                On
                T1.Workflow_id                               = T2.Workflow_id
                And T1.referencing_Procedure_RepoObject_guid = T2.referencing_Procedure_RepoObject_guid
                And T1.referenced_Procedure_RepoObject_guid  = T2.referenced_Procedure_RepoObject_guid
    Where
        ( T1.is_redundant          = 0 )
        And T2.RownrPerReferencing = 1;

    Set @updated = @@RowCount;
    --Set @rows = @rows + @updated;
End;