dbo.QBM_TUAssembly_QBMViewAddOn

1 create   trigger QBM_TUAssembly_QBMViewAddOn on QBMViewAddOn  for Update not for Replication as begin declare @GenProcID varchar(38) = dbo.QBM_FGISessionContext
2('') BEGIN TRY if exists (select top 1 1 from inserted) goto start if exists (select top 1 1 from deleted) goto start return start:  if dbo.QBM_FGIColumnUpdatedOthers
3('QBMViewAddOn', 'IsGenerated', columns_updated()) = 1 begin declare @DBQueueElements_01 QBM_YDBQueueRaw insert into @DBQueueElements_01 (object, subobject
4, genprocid) select x.uid, null, @GenProcID from (select t.UID_DialogTable as UID from inserted i join DialogTable t on i.UID_DialogTable = t.UID_DialogTable
5 where i.IsGenerated = 0 union select t2.UID_DialogTable from inserted i join DialogTable t on i.UID_DialogTable = t.UID_DialogTable join DialogTable t2
6 on t.UID_DialogTableBase = t2.UID_DialogTable where i.IsGenerated = 0 union select t2.UID_DialogTableUnion from inserted i join DialogTable t on i.UID_DialogTable
7 = t.UID_DialogTable join DialogTable t2 on t.UID_DialogTableUnion = t2.UID_DialogTable where i.IsGenerated = 0 ) as x exec QBM_PDBQueueInsert_Bulk 'QBM-K-CommonRebuildView'
8, @DBQueueElements_01 end   END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR ('', 18, 1) WITH NOWAIT END CATCH end 
9