dbo.QBM_ZPrePropColumnFK

1   create   procedure QBM_ZPrePropColumnFK (@SlotNumber int) as begin  declare @GenProcID varchar(38) declare @CountItems int  declare @GenProcID_R
2 varchar(38) = dbo.QBM_FGISessionContext('') declare @DBQueueCurrent QBM_YDBQueueCurrent declare @XUser nvarchar(64) = object_name(@@procid) declare @Xdate
3 datetime = getutcdate() BEGIN TRY insert into @DBQueueCurrent(UID_DialogDBQueue, UID_Parameter, UID_SubParameter, GenProcID) select UID_DialogDBQueue,
4 UID_Parameter, UID_SubParameter, GenProcID from QBMDBQueueCurrent cu with (readpast) where cu.SlotNumber = @SlotNumber if @@rowcount = 0 begin goto EndLabel
5 end declare @PrePropHelper QBM_YPrepropHelper insert into @PrePropHelper (uid_parameter , isDeactivatedPrior , IsDeactivated , IsDeactivatedOld, GenProcID
6 , PreProcessorCondition, PreProcessorConditionT) select x.uid_parameter, 0, 0, isnull(c.isDeactivatedByPreProcessor,0), x.GenProcID, isnull(c.PreProcessorCondition
7,N''), isnull(t.PreProcessorCondition,N'') from @DBQueueCurrent x join dialogcolumn c on x.uid_parameter = c.uid_dialogcolumn join dialogtable t on c.UID_DialogTable
8 = t.UID_DialogTable   select @GenProcID = max(GenProcID) from @DBQueueCurrent    update @PrePropHelper set isDeactivated = isnull(c.isDeactivatedByPreProcessor
9,0) from @PrePropHelper h join QBMRelation r on r.UID_ChildColumn = h.uid_parameter join DialogColumn c on r.UID_ParentColumn = c.UID_DialogColumn where
10 h.isDeactivated <> isnull(c.isDeactivatedByPreProcessor,0)   update @PrePropHelper set IsDeactivated = dbo.QBM_FGIPrepropConditionDeactiv(h.PreProcessorConditionT
11) from @PrePropHelper h where h.PreProcessorCondition > ' ' and h.IsDeactivated = 0   update @PrePropHelper set IsDeactivated = dbo.QBM_FGIPrepropConditionDeactiv
12(h.PreProcessorCondition) from @PrePropHelper h where h.PreProcessorCondition > ' ' and h.IsDeactivated = 0  update @preprophelper set IsDeactivated = 
131 from @preprophelper h, dialogcolumn c, dialogcolumn b where h.uid_parameter = c.uid_dialogcolumn and c.uid_BaseColumn = b.uid_dialogColumn and b.isDeactivatedByPreprocessor
14 = 1    exec QBM_PSessionContextSet 'GenProcID', @GenProcID update DialogColumn set IsDeactivatedByPreProcessor = x.isDeactivated , XDateUpdated = @Xdate
15 , XUserUpdated = @XUser  from DialogColumn r join @PrePropHelper x on r.UID_DialogColumn = x.uid_parameter where r.IsDeactivatedByPreProcessor <> x.IsDeactivated
16 select @CountItems = @@rowcount   if @CountItems > 0 begin  declare @DBQueueElements_01 QBM_YDBQueueRaw insert into @DBQueueElements_01 (object, subobject
17, genprocid) select x.uid, null, @GenProcID from (select distinct cv.UID_DialogColumn as UID from DialogColumn c join @PrePropHelper x on c.uid_dialogColumn
18 = x.uid_parameter and c.ispkmember = 1 and x.IsDeactivated <> x.IsDeactivatedOld join DialogColumn cv with (nolock) on cv.uid_BaseColumn = c.uid_dialogColumn
19 ) as x exec QBM_PDBQueueInsert_Bulk 'QBM-K-CommonPrepropColumnFK', @DBQueueElements_01  declare @DBQueueElements_02 QBM_YDBQueueRaw insert into @DBQueueElements_02
20 (object, subobject, genprocid) select x.uid, null, @GenProcID from (select distinct t.TableName as UID from DialogColumn c join @PrePropHelper x on c.uid_dialogColumn
21 = x.uid_parameter and c.ispkmember = 1 and x.IsDeactivated <> x.IsDeactivatedOld join DialogTable t with (nolock) on c.UID_DialogTable = t.UID_DialogTable
22 ) as x exec QBM_PDBQueueInsert_Bulk 'QBM-K-CommonPrepropTableFK', @DBQueueElements_02 end   END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR
23 ('', 18, 1) WITH NOWAIT END CATCH  endLabel: exec QBM_PSessionContextSet 'GenProcID', @GenProcID_R return end 
24