dbo.QBM_ZPrePropReport

1   create   procedure QBM_ZPrePropReport (@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 , sign(convert(int, isnull(t.isDeactivatedByPreProcessor
7,0)) /*+ convert(int, isnull(rp.isDeactivatedByPreProcessor,0)) */ ) , sign(convert(int, isnull(t.isDeactivatedByPreProcessor,0)) /*+ convert(int, isnull(rp.isDeactivatedByPreProcessor,0)) */
8 ) , x.GenProcID, isnull(o.PreProcessorCondition,N''), o.isDeactivatedByPreProcessor from @DBQueueCurrent x join DialogReport o on x.uid_parameter = o.uid_dialogReport
9 left outer join dialogtable t on o.UID_DialogTableBase = t.UID_DialogTable   update @PrePropHelper set IsDeactivated = dbo.QBM_FGIPrepropConditionDeactiv
10(h.PreProcessorCondition) from @PrePropHelper h where h.PreProcessorCondition > ' ' and h.IsDeactivated = 0  exec QBM_PSessionContextSet 'GenProcID', @GenProcID
11 update DialogReport set IsDeactivatedByPreProcessor = x.isDeactivated, xdateupdated = GetUTCDate(), xuserupdated = 'DBScheduler'  from DialogReport r 
12join @PrePropHelper x on r.UID_DialogReport = x.uid_parameter where r.IsDeactivatedByPreProcessor <> x.IsDeactivated select @CountItems = @@rowcount if
13 @CountItems > 0 begin   exec QBM_PDBQueueInsert_WaitForComp 'Report', @GenProcID   end  END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR
14 ('', 18, 1) WITH NOWAIT END CATCH  endLabel: exec QBM_PSessionContextSet 'GenProcID', @GenProcID_R return end 
15