dbo.POL_ZQERPolicyMakeProc

1  create   procedure POL_ZQERPolicyMakeProc (@SlotNumber int) as begin  declare @uid_QERPolicy varchar(38) declare @SQLcmd nvarchar(max) declare
2 @Procname varchar(30) declare @ElementBuffer QBM_YCursorBuffer declare @ElementCount int declare @ElementIndex int SET XACT_ABORT OFF BEGIN TRY insert
3 into @ElementBuffer (UID1) select uid_parameter from QBMDBQueueCurrent p with (readpast) where p.SlotNumber = @SlotNumber select @ElementCount = @@ROWCOUNT
4 select @ElementIndex = 1 while @ElementIndex <= @ElementCount begin select top 1 @uid_QERPolicy = bu.UID1 from @ElementBuffer bu where bu.ElementIndex
5 = @ElementIndex select @procname = dbo.QBM_FGICodeName('PO', @uid_QERPolicy)  if exists (select top 1 1 from QERPolicy where uid_QERPolicy = @uid_QERPolicy
6  and isnull(isInactive,0) = 0 and isnull(isWorkingCopy,0) = 0 and isnull(isNoWhereClause,0) = 0 ) begin exec POL_PQERPolicyMakeProc @uid_QERPolicy, @procname
7 end else begin exec QBM_PProcedureDrop @procname end select @ElementIndex += 1 end  END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR (''
8, 18, 1) WITH NOWAIT END CATCH end 
9