dbo.QBM_ZPrePropColumn

1    create   procedure QBM_ZPrePropColumn (@SlotNumber int) as begin  declare @GenProcID varchar(38) declare @CountItems int  declare @GenProcID_R
2 varchar(38) = dbo.QBM_FGISessionContext('') declare @DBQueueCurrent QBM_YDBQueueCurrent BEGIN TRY insert into @DBQueueCurrent(UID_DialogDBQueue, UID_Parameter
3, UID_SubParameter, GenProcID) select UID_DialogDBQueue, UID_Parameter, UID_SubParameter, GenProcID from QBMDBQueueCurrent cu with (readpast) where cu.SlotNumber
4 = @SlotNumber if @@rowcount = 0 begin goto EndLabel end select @GenProcID = max(GenProcID) from @DBQueueCurrent where GenProcID > ' ' if isnull(@Genprocid
5, '') = '' begin select @GenProcID = newid() end declare @PrePropHelper QBM_YPrepropHelper insert into @PrePropHelper (uid_parameter , isDeactivatedPrior
6 , IsDeactivated , GenProcID , PreProcessorCondition, IsDeactivatedOld) select x.uid_parameter, isnull(t.isDeactivatedByPreProcessor,0), isnull(t.isDeactivatedByPreProcessor
7,0), x.GenProcID, isnull(c.PreProcessorCondition,N''), c.isDeactivatedByPreProcessor from @DBQueueCurrent x join dialogcolumn c on x.uid_parameter = c.uid_dialogcolumn
8 join dialogtable t on c.UID_DialogTable = t.UID_DialogTable   update @PrePropHelper set IsDeactivated = dbo.QBM_FGIPrepropConditionDeactiv(h.PreProcessorCondition
9) from @PrePropHelper h where h.PreProcessorCondition > ' ' and h.IsDeactivated = 0  update @PrePropHelper set IsDeactivated = 1 from @PrePropHelper h 
10join QBM_VQBMRelation r on r.UID_ChildColumn = h.uid_parameter join DialogTable t on r.UID_DialogTableParent= t.UID_DialogTable where t.IsDeactivatedByPreProcessor
11 = 1 if exists (select top 1 1 from dialogcolumn c join @PrePropHelper x on c.UID_DialogColumn = x.uid_parameter where c.IsDeactivatedByPreProcessor <>
12 x.IsDeactivated  and not exists (select top 1 1 from QBMRelation r where c.UID_DialogColumn = r.UID_ChildColumn ) ) begin  exec QBM_PDBQueueInsert_WaitForComp
13 'Column', @GenProcID  end   exec QBM_PSessionContextSet 'GenProcID', @GenProcID update DialogColumn set IsDeactivatedByPreProcessor = x.isDeactivated,
14 xdateupdated = GetUTCDate(), xuserupdated = 'DBScheduler'  from DialogColumn r join @PrePropHelper x on r.UID_DialogColumn = x.uid_parameter where r.IsDeactivatedByPreProcessor
15 <> x.IsDeactivated select @CountItems = @@rowcount    declare @DBQueueElements_01 QBM_YDBQueueRaw insert into @DBQueueElements_01 (object, subobject, 
16genprocid) select v.UID_DialogColumn, null, @GenProcID from dialogcolumn v with (nolock) join @PrePropHelper x on v.UID_BaseColumn = x.uid_parameter   
17exec QBM_PDBQueueInsert_Bulk 'QBM-K-CommonPrepropColumn', @DBQueueElements_01    declare @DBQueueElements_02 QBM_YDBQueueRaw insert into @DBQueueElements_02
18 (object, subobject, genprocid) select x.UID, null, @GenProcID from (select UID_DialogColumn as UID from DialogColumn c join @PrePropHelper x on c.UID_baseColumn
19 = x.uid_parameter and (x.IsDeactivated <> x.IsDeactivatedOld  ) union select UID_ChildColumn as UID from QBMRelation cr join @PrePropHelper x on cr.UID_parentColumn
20 = x.uid_parameter  join dialogcolumn c with (nolock) on x.uid_parameter = c.uid_dialogcolumn and c.isPKMember = 1 union   select UID_ChildColumn as UID
21 from QBMRelation cr join @PrePropHelper x on cr.UID_ChildColumn = x.uid_parameter and (x.IsDeactivated <> x.IsDeactivatedOld or x.IsDeactivated = 0 ) 
22) as x exec QBM_PDBQueueInsert_Bulk 'QBM-K-CommonPrepropColumnFK', @DBQueueElements_02                   declare @DBQueueElements_03 QBM_YDBQueueRaw insert
23 into @DBQueueElements_03 (object, subobject, genprocid) select x.uid, null, @GenProcID from (select distinct t.TableName as UID from @PrePropHelper x 
24join DialogColumn c with (nolock) on x.uid_parameter = c.uid_dialogColumn join DialogTable t with (nolock) on c.UID_DialogTable = t.UID_DialogTable and
25 ( x.IsDeactivated <> x.IsDeactivatedOld  or x.IsDeactivated = 1 ) and c.isPKMember = 1 ) as x exec QBM_PDBQueueInsert_Bulk 'QBM-K-CommonPrepropTableFK'
26, @DBQueueElements_03 if @CountItems > 0 begin   declare @DBQueueElements_04 QBM_YDBQueueRaw insert into @DBQueueElements_04 (object, subobject, genprocid
27) select x.uid, null, @GenProcID from (select tu.UID_DialogTable as UID from @PrePropHelper x join DialogColumn c on x.uid_parameter = c.uid_dialogColumn
28 join DialogColumn u with (nolock) on c.UID_DialogColumnUnionView = u.uid_dialogColumn join DialogTable tu with (nolock) on u.UID_DialogTable = tu.UID_DialogTable
29 and ( x.IsDeactivated <> x.IsDeactivatedOld ) union select tv.UID_DialogTable as UID from @PrePropHelper x join DialogColumn c on x.uid_parameter = c.uid_dialogColumn
30 join DialogColumn v with (nolock) on v.UID_BaseColumn = c.uid_dialogColumn join DialogTable tv with (nolock) on v.UID_DialogTable = tv.UID_DialogTable
31 and ( x.IsDeactivated <> x.IsDeactivatedOld ) ) as x exec QBM_PDBQueueInsert_Bulk 'QBM-K-CommonRebuildView', @DBQueueElements_04  end   END TRY BEGIN 
32CATCH exec QBM_PSessionErrorAdd default RAISERROR ('', 18, 1) WITH NOWAIT END CATCH  endLabel: exec QBM_PSessionContextSet 'GenProcID', @GenProcID_R return
33 end 
34