dbo.QBM_TUAssembly_DialValDynRef

1 create   trigger QBM_TUAssembly_DialValDynRef on DialogValidDynamicRef  for Update not for Replication as begin declare @GenProcID varchar(38) 
2= dbo.QBM_FGISessionContext('') BEGIN TRY if exists (select top 1 1 from inserted) goto start if exists (select top 1 1 from deleted) goto start return
3 start:  if update(ParentRestriction) or update(ParentExecuteBy)  or update(ChildExecuteBy) begin exec QBM_PDBQueueInsert_Single 'QBM-K-CommonMakeRITriggerPre'
4, '', '', @GenProcID end  declare @DBQueueElements_01 QBM_YDBQueueRaw insert into @DBQueueElements_01 (object, subobject, genprocid) select x.uid, null
5, @GenProcID from (select t.TableName as UID from DialogValidDynamicRef i join deleted d on i.XObjectKey = d.XObjectKey join DialogColumn c on i.UID_DialogColumn
6 = c.UID_DialogColumn join DialogTable t on c.UID_DialogTable = t.UID_DialogTable where isnull(i.ChildExecuteBy,'') <> isnull(d.ChildExecuteBy,'') or isnull
7(i.ParentExecuteBy,'') <> isnull(d.ParentExecuteBy,'')  or isnull(i.ParentRestriction,'') <> isnull(d.ParentRestriction,'') union select t.TableName as
8 UID from DialogValidDynamicRef i join deleted d on i.XObjectKey = d.XObjectKey join DialogTable t on i.UID_DialogTableReference = t.UID_DialogTable where
9 isnull(i.ChildExecuteBy,'') <> isnull(d.ChildExecuteBy,'') or isnull(i.ParentExecuteBy,'') <> isnull(d.ParentExecuteBy,'')  or isnull(i.ParentRestriction
10,'') <> isnull(d.ParentRestriction,'') ) as x  insert into @DBQueueElements_01 (object, subobject, genprocid) select b.TableName, null, e.GenProcID from
11 @DBQueueElements_01 e join DialogTable v on e.Object = v.TableName join DialogTable b on v.UID_DialogTableBase = b.UID_DialogTable exec QBM_PDBQueueInsert_Bulk
12 'QBM-K-CommonMakeWatchtrigger', @DBQueueElements_01 exec QBM_PDBQueueInsert_Bulk 'QBM-K-CommonMakeRITrigger' , @DBQueueElements_01  END TRY BEGIN CATCH
13 exec QBM_PSessionErrorAdd default RAISERROR ('', 18, 1) WITH NOWAIT END CATCH end 
14