repo.RepoObject_persistence_NoCompareNoUpdate - V

CREATE View repo.RepoObject_persistence_NoCompareNoUpdate
As
Select
    T1.target_RepoObject_guid
  , T1.source_RepoObject_guid
  , T1.source_RepoObject_name
  , T1.ColumnListNoCompareNoUpdate
  , NoCompareNoUpdate_Column         = Trim ( T2.value )
  , T3.RepoObject_guid
  , T3.RepoObjectColumn_guid
  , is_persistence_NoCompareNoUpdate = Iif(T3.RepoObjectColumn_guid Is Null, 0, 1)
From
    repo.RepoObject_persistence                                   As T1
    Cross Apply String_Split(T1.ColumnListNoCompareNoUpdate, ',') As T2
    Left Join
        repo.RepoObjectColumn As T3
            On
            T3.RepoObject_guid = T1.target_RepoObject_guid
            And T3.Column_name = Trim ( T2.value )