dbo.QER_TUWorkDesk

1create   trigger QER_TUWorkDesk on WorkDesk  for Update not for Replication as begin  BEGIN TRY if exists (select top 1 1 from inserted) goto start
2 if exists (select top 1 1 from deleted) goto start return start: declare @GenProcID varchar(38) select @GenProcID = dbo.QBM_FGISessionContext('') if update
3(uid_department) or update(uid_locality) or update(uid_ProfitCenter) or update(IsNoInherite) begin declare @DBQueueElements_02 QBM_YDBQueueRaw insert into
4 @DBQueueElements_02 (object, subobject, genprocid) select x.uid, null, @GenProcID from ( select distinct w.uid_WorkDesk as uid from deleted d join WorkDesk
5 w on d.uid_WorkDesk = w.uid_WorkDesk where isnull(d.uid_department,'') <> isnull(w.uid_department,'') or isnull(d.uid_locality,'') <> isnull(w.uid_locality
6,'') or isnull(d.uid_ProfitCenter,'') <> isnull(w.uid_ProfitCenter,'') or isnull(d.IsNoInherite,0) <> isnull(w.IsNoInherite,0) ) as x exec QBM_PDBQueueInsert_Bulk
7 'QER-K-HelperWorkdeskOrg', @DBQueueElements_02 exec QBM_PDBQueueInsert_Bulk 'QER-K-AllForOneWorkdesk', @DBQueueElements_02 end    END TRY BEGIN CATCH 
8exec QBM_PSessionErrorAdd default RAISERROR ('', 18, 1) WITH NOWAIT END CATCH return end 
9