dbo.POL_TUQERPolicy

1create   trigger POL_TUQERPolicy on QERPolicy  for Update not for Replication as begin  declare @SQLToCheck QBM_YParameterList declare @XObjectKeys
2 QBM_YParameterList BEGIN TRY if exists (select top 1 1 from inserted) goto start if exists (select top 1 1 from deleted) goto start return start: declare
3 @GenProcID varchar(38) select @GenProcID = dbo.QBM_FGISessionContext('') declare @UID_QERPolicy varchar(38) declare @WhereClause nvarchar(1024) if update
4(WhereClause) begin insert into @SQLToCheck(Parameter1, ContentFull) select c.XObjectKey, 'select top 1 1 as columnvalue from ' + t.TableName + '
5		 where (
6		 '
7 + c.WhereClause + '
8		 )' from inserted c  join DialogTable t on c.UID_DialogTable = t.UID_DialogTable where c.WhereClause > ' ' exec QBM_PSQLCheckExecutable
9 @SQLToCheck, @RaiseError = 1 end  if (update(WhereClause) or update(IsInactive) or update(IsNoWhereClause) ) begin declare @DBQueueElements_01 QBM_YDBQueueRaw
10 insert into @DBQueueElements_01 (object, subobject, genprocid) select x.uid, null, @GenProcID from ( select t.UID_QERPolicy as uid from QERPolicy t join
11 deleted d on t.UID_QERPolicy = d.UID_QERPolicy ) as x exec QBM_PDBQueueInsert_Bulk 'POL-K-QERPolicyMakeProc', @DBQueueElements_01  declare @DBQueueElements_02
12 QBM_YDBQueueRaw insert into @DBQueueElements_02 (object, subobject, genprocid) select x.uid, null, @GenProcID from ( select t.UID_QERPolicy as uid from
13 QERPolicy t join deleted d on t.UID_QERPolicy = d.UID_QERPolicy where isnull(t.IsInactive, 0) = 0 ) as x exec QBM_PDBQueueInsert_Bulk 'POL-K-QERPolicyFill'
14, @DBQueueElements_02 end   if update(IsInActive) begin insert into @XObjectKeys (Parameter1) select pho.XObjectKey from deleted d join QERPolicy r on 
15d.uid_QERPolicy = r.uid_QERPolicy join QERPolicyHasObject pho on pho.UID_QERPolicy = r.UID_QERPolicy where (isnull(d.IsInActive, 0) = 0 and isnull(r.IsInActive
16, 0) = 1) exec QBM_PJobCreate_HODelete_L 'QERPolicyHasObject', @XObjectKeys, @GenProcID , @AdditionalObjectKeysAffected = DEFAULT end END TRY BEGIN CATCH
17 exec QBM_PSessionErrorAdd default RAISERROR ('', 18, 1) WITH NOWAIT END CATCH ende: return end 
18