dbo.QBM_PTableRevisionFill

1   create   procedure QBM_PTableRevisionFill as begin declare @dbid int = DB_ID() SET XACT_ABORT OFF BEGIN TRY merge into QBMTableRevision as t 
2using ( select distinct dt.TableName from QBM_VTablesForRevision dt where dt.IsForQBMTableRevision = 1 and dbo.QBM_FGIConfigparmValue('Common\TableRevision'
3) > ' ' ) as s on t.TableName = s.TableName and t.ServerProcess = 0 when not matched by source and t.serverprocess = 0 then delete when not matched by 
4target then insert ( TableName ) values ( s.Tablename ) ;  update QBMTableRevision set ServerProcess = -1 from QBMTableRevision r with (readpast) left 
5outer join sys.sysprocesses p on r.ServerProcess = p.spid and p.dbid = @dbid where p.spid is null and r.ServerProcess > 0 update QBMTableRevision set RevisionDate
6 = a.maxRevisionDate from QBMTableRevision u join ( select r.TableName, MAX(r.RevisionDate) as maxRevisionDate from QBMTableRevision r with (readpast) 
7where r.ServerProcess <= 0 and r.RevisionDate > ' ' group by r.TableName ) as a on u.TableName = a.TableName and u.ServerProcess = 0 waitfor delay '00:00:02'
8 delete QBMTableRevision where ServerProcess = -1 END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default declare @Rethrow varchar(1000) = dbo.QBM_FGISessionErrorRethrow
9() RAISERROR (@Rethrow, 18, 1) WITH NOWAIT END CATCH endLabel: return end 
10