dbo.RPS_ZPrePropRPSReport

1    create   procedure RPS_ZPrePropRPSReport (@SlotNumber int ) as begin  declare @GenProcID varchar(38) declare @GenProcID_R varchar(38) = dbo.QBM_FGISessionContext
2('') declare @DBQueueCurrent QBM_YDBQueueCurrent BEGIN TRY insert into @DBQueueCurrent(UID_DialogDBQueue, UID_Parameter, UID_SubParameter, GenProcID) select
3 UID_DialogDBQueue, UID_Parameter, UID_SubParameter, GenProcID from QBMDBQueueCurrent cu with (readpast) where cu.SlotNumber = @SlotNumber if @@rowcount
4 = 0 begin goto EndLabel end select @GenProcID = max(GenProcID) from @DBQueueCurrent where GenProcID > ' ' if isnull(@Genprocid, '') = '' begin select 
5@GenProcID = newid() end declare @PrePropHelper QBM_YPrepropHelper insert into @PrePropHelper (uid_parameter , isDeactivatedPrior , IsDeactivated , GenProcID
6 , PreProcessorCondition, IsDeactivatedOld) select x.uid_parameter, 0, 0, x.GenProcID, isnull(c.PreProcessorCondition,N''), c.isDeactivatedByPreProcessor
7 from @DBQueueCurrent x join RPSReport c on x.uid_parameter = c.uid_RPSReport  update @PrePropHelper set IsDeactivated = dbo.QBM_FGIPrepropConditionDeactiv
8(h.PreProcessorCondition) from @PrePropHelper h where h.PreProcessorCondition > ' ' and h.IsDeactivated = 0  exec QBM_PSessionContextSet 'GenProcID', @GenProcID
9 update RPSReport set IsDeactivatedByPreProcessor = x.isDeactivated, xdateupdated = GetUTCDate(), xuserupdated = 'DBScheduler'  from RPSReport r join @PrePropHelper
10 x on r.UID_RPSReport = x.uid_parameter where r.IsDeactivatedByPreProcessor <> x.IsDeactivated END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR
11 ('', 18, 1) WITH NOWAIT END CATCH  endLabel: exec QBM_PSessionContextSet 'GenProcID', @GenProcID_R return end 
12