dbo.QER_TUHardware

1create   trigger QER_TUHardware on Hardware  for Update not for Replication as begin declare @XDateInserted datetime , @XDateUpdated datetime , 
2@XUserInserted nvarchar(64) , @XUserUpdated nvarchar(64) declare @QBM_BitPatternXMarkedForDel_Delay int = dbo.QBM_FGIBitPatternXMarkedForDel('|Delay|',
3 0)  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 @GenProcID 
4varchar(38) select @GenProcID = dbo.QBM_FGISessionContext('')   if update(uid_Hardwaretype) begin if exists(select top 1 1 from Hardware i join deleted
5 d on i.uid_Hardware = d.uid_Hardware and isnull(i.uid_Hardwaretype,'') <> isnull(d.uid_Hardwaretype,'') join Hardwaretype p on i.UID_Hardwaretype = p.UID_Hardwaretype
6 and p.isInactive = 1 ) begin  raiserror( '#LDS#Assignment cannot take place, because the device type is disabled.|', 18, 2) with nowait end end  if dbo.QBM_FGIColumnUpdatedOthers
7 ('Hardware', 'XTouched', columns_updated()) = 1 and (dbo.QBM_FGIColumnUpdatedOthers ('Hardware', 'XMarkedForDeletion', columns_updated()) = 1 or exists
8 ( select top 1 1 from inserted i join Hardware p on i.uid_Hardware = p.uid_Hardware  where  sign(i.XMarkedForDeletion & @QBM_BitPatternXMarkedForDel_Delay
9) <> sign(p.XMarkedForDeletion & @QBM_BitPatternXMarkedForDel_Delay) ) ) begin   declare @maxAnzahl int select @maxAnzahl = 100 if 100 < (select count(*
10) from inserted) + (select count(*) from deleted) begin select top 1 @maxAnzahl = ( (Count(*)) /10 + 1) from Hardware end else begin select @maxAnzahl 
11= 1073741824  end end  if update(uid_department) or update(uid_locality) or update(uid_ProfitCenter) or update(XMarkedForDeletion) or update(IsNoInherite
12) begin declare @DBQueueElements_04 QBM_YDBQueueRaw insert into @DBQueueElements_04 (object, subobject, genprocid) select x.uid, null, @GenProcID from 
13( select distinct h.uid_Hardware as uid from deleted d join Hardware h on d.uid_Hardware = h.uid_Hardware where isnull(d.uid_department,'') <> isnull(h.uid_department
14,'') or isnull(d.uid_locality,'') <> isnull(h.uid_locality,'') or isnull(d.uid_ProfitCenter,'') <> isnull(h.uid_ProfitCenter,'') or isnull(d.IsNoInherite
15,0) <> isnull(h.IsNoInherite,0)  or  sign(d.XMarkedForDeletion & @QBM_BitPatternXMarkedForDel_Delay) <> sign(h.XMarkedForDeletion & @QBM_BitPatternXMarkedForDel_Delay
16) ) as x exec QBM_PDBQueueInsert_Bulk 'QER-K-AllForOneHardware', @DBQueueElements_04 exec QBM_PDBQueueInsert_Bulk 'QER-K-HelperHardwareOrg', @DBQueueElements_04
17 end   END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR ('', 18, 1) WITH NOWAIT END CATCH ende: return end 
18