dbo.QBM_ZTaskForInactiveTrigger

1      create   procedure QBM_ZTaskForInactiveTrigger (@SlotNumberDummy int , @Triggername varchar(38) , @Dummy2 varchar(38) , @GenProcID varchar
2(38) ) as begin declare @UID_Task varchar(38) declare @ElementBuffer QBM_YCursorBuffer declare @ElementCount int declare @ElementIndex int BEGIN TRY insert
3 into @ElementBuffer (UID1) select distinct ta.UID_Task from sys.triggers tr join sys.sql_modules q on q.object_id = tr.object_id cross apply dbo.QBM_FCVStringToListSQLMorphem0
4(q.definition, 0, 0) mo join QBMDBQueueTask ta on '''' + ta.UID_Task + '''' = mo.Morphem and ta.QueryForRecalculate > ' ' where tr.name = @Triggername 
5and mo.MorphemType = 'Literal' and mo.MorphemSubType = 'String' and ta.UID_Task > ' ' and tr.name != 'QBM_TUIndicator474488' select @ElementCount = @@ROWCOUNT
6 select @ElementIndex = 1 while @ElementIndex <= @ElementCount begin select top 1 @UID_Task = bu.UID1 from @ElementBuffer bu where bu.ElementIndex = @ElementIndex
7 exec QBM_PDBQueueInsert_Single 'QBM-K-CommonRecalculate', @UID_Task, '', @GenProcID select @ElementIndex += 1 end  END TRY BEGIN CATCH exec QBM_PSessionErrorAdd
8 default RAISERROR ('', 18, 1) WITH NOWAIT END CATCH end 
9