dbo.RMB_TUPerson

1    create   trigger RMB_TUPerson on Person  for Update not for Replication as begin  declare @Parameter nvarchar(1000) BEGIN TRY if exists (select
2 top 1 1 from inserted) goto start if exists (select top 1 1 from deleted) goto start return start: declare @GenProcID varchar(38) select @GenProcID = 
3dbo.QBM_FGISessionContext('') if update(uid_org) begin declare @DBQueueElements_01 QBM_YDBQueueRaw insert into @DBQueueElements_01 (object, subobject, 
4genprocid) select x.uid, null, @GenProcID from ( select p.uid_person as uid from person p join deleted d on p.uid_person = d.uid_person where isnull(p.uid_org
5, '') <> isnull(d.uid_org, '') ) as x exec QBM_PDBQueueInsert_Bulk 'RMB-K-HelperPersonOrg', @DBQueueElements_01 end pwotest:   if update(uid_Org) begin
6 declare @RecalcParameter_01 QBM_YCursorBuffer  insert into @RecalcParameter_01 (UID1, ObjectKey1, Ident1) select 'RMB-PWODecisionRule-IO', i.XobjectKey
7, 'I' from inserted i union all select 'RMB-PWODecisionRule-RO', i.XobjectKey, 'I' from inserted i exec QER_PITShopHelperFill_Recalc @RecalcParameter_01
8, @GenprocID end  END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR ('', 18, 1) WITH NOWAIT END CATCH ende: return end 
9