dbo.QBM_TUDialogGroup

1 create   trigger QBM_TUDialogGroup on DialogGroup  for Update not for Replication as begin  declare @ConditionsToCheck QBM_YParameterList declare
2 @XUser nvarchar(64) = object_name(@@procid) declare @Xdate datetime = getutcdate() BEGIN TRY if exists (select top 1 1 from inserted) goto start if exists
3 (select top 1 1 from deleted) goto start return start: declare @GenProcID varchar(38) select @GenProcID = dbo.QBM_FGISessionContext('') if update(PreprocessorCondition
4) begin  insert into @ConditionsToCheck (ContentFull) select i.PreProcessorCondition from inserted i exec QBM_PPrePropCheckSyntax @ConditionsToCheck  declare
5 @DBQueueElements_01 QBM_YDBQueueRaw insert into @DBQueueElements_01 (object, subobject, genprocid) select x.uid, null, @GenProcID from ( select uid_DialogGroup
6 as uid from inserted ) as x exec QBM_PDBQueueInsert_Bulk 'QBM-K-CommonPrepropGroup', @DBQueueElements_01 end  if update(GroupNumber) begin if exists (select
7 top 1 1 from deleted d join DialogGroup g on g.UID_DialogGroup = d.uid_dialogGroup where d.groupnumber > 0 and g.groupnumber > 0 and d.groupnumber <> 
8g.groupnumber ) begin  declare @DBQueueElements_02 QBM_YDBQueueRaw insert into @DBQueueElements_02 (object, subobject, genprocid) select x.uid, null, @GenProcID
9 from ( select g.uid_DialogGroup as uid from deleted d join DialogGroup g on g.UID_DialogGroup = d.uid_dialogGroup where d.groupnumber > 0 and g.groupnumber
10 > 0 and d.groupnumber <> g.groupnumber ) as x exec QBM_PDBQueueInsert_Bulk 'QBM-K-CommonGroupNumber', @DBQueueElements_02 exec QBM_PDBQueueInsert_Bulk
11 'QBM-K-CommonGroupPattern', @DBQueueElements_02 update dialoggroup set groupnumber = 0 , XDateUpdated = @Xdate , XUserUpdated = @XUser from dialogGroup
12 join deleted d on dialogGroup.UID_DialogGroup = d.uid_dialogGroup where d.groupnumber > 0 and dialoggroup.groupnumber > 0 and d.groupnumber <> dialoggroup.groupnumber
13 end end END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR ('', 18, 1) WITH NOWAIT END CATCH end 
14