dbo.QBM_ZPrePropGroup

1   create   procedure QBM_ZPrePropGroup (@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 , IsDeactivated , 
6IsDeactivatedOld, GenProcID , PreProcessorCondition) select x.uid_parameter, 0 , g.isDeactivatedByPreProcessor , x.GenProcID, isnull(g.PreProcessorCondition
7,N'') from @DBQueueCurrent x join dialogGroup g on x.uid_parameter = g.UID_DialogGroup update @PrePropHelper set IsDeactivated = dbo.QBM_FGIPrepropConditionDeactiv
8(h.PreProcessorCondition) from @PrePropHelper h where h.PreProcessorCondition > ' '   exec QBM_PSessionContextSet 'GenProcID', @GenProcID update DialogGroup
9 set IsDeactivatedByPreProcessor = x.isDeactivated, xdateupdated = GetUTCDate(), xuserupdated = 'DBScheduler'  from DialogGroup r join @PrePropHelper x
10 on r.UID_DialogGroup = x.uid_parameter where( r.IsDeactivatedByPreProcessor <> x.IsDeactivated or x.IsDeactivated = 1 ) select @CountItems = @@rowcount
11 if @CountItems > 0 begin exec QBM_PDBQueueInsert_Single 'QBM-K-CommonReCalculate' , 'QBM-K-CommonGroupCollection', '', @GenProcID end END TRY BEGIN CATCH
12 exec QBM_PSessionErrorAdd default RAISERROR ('', 18, 1) WITH NOWAIT END CATCH endLabel: exec QBM_PSessionContextSet 'GenProcID', @GenProcID_R return end
13 
14