dbo.QBM_PJobPerformanceUpdate

1    create   procedure QBM_PJobPerformanceUpdate (@Queue nvarchar(255) ,  @PerfValues nvarchar(max)  )  as begin SET XACT_ABORT OFF BEGIN TRY   
2merge into JobPerformance as t using ( select dbo.QBM_FCVStringToGUID('', UPPER(concat( @Queue, x.ComponentClass, x.TaskName ))) as UID_JobPerformance 
3, x.ComponentClass as ComponentClass, x.TaskName as TaskName, x.Countperminute as Countperminute from ( select left(sp.parametername, charindex('|', sp.parametername
4) -1 ) as ComponentClass , substring(sp.parametername, charindex('|', sp.parametername) +1 , 255 ) as TaskName , dbo.QBM_FCVStringToInt(sp.parametervalue
5, 0) as CountPerMinute from dbo.QBM_FCVStringToListSplitted(@PerfValues, nchar(7), 0, 0 , N'=') sp ) as x ) as s on t.UID_JobPerformance = s.UID_JobPerformance
6 when matched and t.CountPerMinute <> s.CountPerMinute then update set t.CountPerMinute = s.CountPerMinute when not matched by target then insert(UID_JobPerformance
7, Queue, ComponentClass , TaskName , CountPerMinute) values (s.UID_JobPerformance, @queue, s.ComponentClass , s.TaskName , s.CountPerMinute) ; END TRY 
8BEGIN CATCH exec QBM_PSessionErrorAdd default declare @Rethrow varchar(1000) = dbo.QBM_FGISessionErrorRethrow() RAISERROR (@Rethrow, 18, 1) WITH NOWAIT
9 END CATCH end 
10