workflow.Workflow_ProcedureDependency_T_NotInSortorder - V

/*
workflow.Workflow_ProcedureDependency_T not redundant entries not yet processed into workflow.WorkflowStep_Sortorder
*/
CREATE View workflow.Workflow_ProcedureDependency_T_NotInSortorder
As
Select
    T1.Workflow_id
  , T1.referenced_Procedure_RepoObject_guid
  , T1.referencing_Procedure_RepoObject_guid
--, is_redundant
From
    workflow.Workflow_ProcedureDependency_T_active As T1
Where
    T1.is_redundant = 0
    And Not Exists
(
    Select
        Expr1 = 1
    From
        workflow.WorkflowStep_Sortorder As T2
    Where
        ( T2.Workflow_id                   = T1.Workflow_id )
        And ( T2.Procedure_RepoObject_guid = T1.referencing_Procedure_RepoObject_guid )
)

    --
    And Not Exists
(
    Select
        Expr1 = 1
    From
        workflow.WorkflowStep_Sortorder As T2
    Where
        ( T2.Workflow_id                   = T1.Workflow_id )
        And ( T2.Procedure_RepoObject_guid = T1.referenced_Procedure_RepoObject_guid )
)

sqlCopied!