dbo.CPL_ZScheduleStartFill

1  create   procedure CPL_ZScheduleStartFill ( @SlotNumber int ) AS begin declare @MyName nvarchar(64) = object_name(@@procid) declare @DBQueueCurrent
2 QBM_YDBQueueCurrent BEGIN TRY insert into @DBQueueCurrent(UID_DialogDBQueue, UID_Parameter, UID_SubParameter, GenProcID) select UID_DialogDBQueue, UID_Parameter
3, UID_SubParameter, GenProcID from QBMDBQueueCurrent cu with (readpast) where cu.SlotNumber = @SlotNumber if @@rowcount = 0 begin goto EndLabel end   declare
4 @DBQueueElements_01 QBM_YDBQueueRaw insert into @DBQueueElements_01 (object, subobject, genprocid) select x.uid, null, x.GenProcID from ( select s.uid_complianceSubRule
5 as uid, cu.GenProcID from ComplianceSubrule s join complianceRule r on s.uid_complianceRule = r.uid_complianceRule join @DBQueueCurrent cu on cu.UID_Parameter
6 = r.UID_DialogScheduleFill where r.IsWorkingCopy = 0  and r.IsInActive = 0 and r.IsSimpleMode = 1 ) as x exec QBM_PDBQueueInsert_Bulk 'CPL-K-ComplianceSubRuleFillObject'
7, @DBQueueElements_01   declare @DBQueueElements_02 QBM_YDBQueueRaw insert into @DBQueueElements_02 (object, subobject, genprocid) select x.uid, null, 
8x.GenProcID from ( select r.uid_complianceRule as uid, cu.GenProcID from complianceRule r join @DBQueueCurrent cu on cu.UID_Parameter = r.UID_DialogScheduleFill
9 where r.IsWorkingCopy = 0  and r.IsInActive = 0  ) as x exec QBM_PDBQueueInsert_Bulk 'CPL-K-ComplianceSubRuleFillPerson', @DBQueueElements_02 END TRY 
10BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR ('', 18, 1) WITH NOWAIT END CATCH  endLabel: return end 
11