Back to OIM Explorer

dbo.QBM_P0443A4E1724A1CB3D52A2C2_a

Stored ProcedureSQL_STORED_PROCEDURESandbox DB

Stored Procedure.

Source: sandbox-db sys.sql_modules

Source size: 915 characters

Interpretation

  • Database routine. Review parameters, called procedures, DBQueue inserts, and QBM_PJobCreate helper calls before assuming side effects.

Relations

  • No extracted relations.

Typed Edges

  • No typed edges extracted for this source.

References

  • No direct source references extracted.

Referenced By

Complete Source

SQL33 lines
1CREATE PROCEDURE QBM_P0443A4E1724A1CB3D52A2C2_a(2  @BlockSize int,3  @ReadyForDeleteOrExport int,4  @KeyPattern varchar(25),5  @Grenzdatum datetime6)7AS8BEGIN9  DECLARE @BlockPuffer QBM_YSingleGUID10  DECLARE @lauf int11  DECLARE @XUser nvarchar(64) = object_name(@@procid)12  DECLARE @Xdate datetime = getutcdate()13  DECLARE @CountRowsToDelete int14  INSERT INTO @BlockPuffer(UID_SingleGuid)15  SELECT TOP(@BlockSize) w.UID_Tree16  FROM DialogProcessChain w17  WHERE18    w.ReadyForDeleteOrExport = 0 AND w.XDateUpdated < @Grenzdatum AND w.GenProcID LIKE @KeyPattern19  SELECT @CountRowsToDelete = @@ROWCOUNT20  SELECT @lauf = @CountRowsToDelete - @BlockSize + 121  IF @CountRowsToDelete > 022  BEGIN23    UPDATE DialogProcessChain24    SET ReadyForDeleteOrExport = @ReadyForDeleteOrExport,25    XDateUpdated = @Xdate,26    XUserUpdated = @XUser27    FROM DialogProcessChain w28    JOIN @BlockPuffer p29      ON w.UID_Tree = p.UID_SingleGuid30  END31  endLabel:32  RETURN(@lauf)33END
Open raw exported source
SQL ยท Raw7 lines
1      create   procedure QBM_P0443A4E1724A1CB3D52A2C2_a ( @BlockSize int , @ReadyForDeleteOrExport int , @KeyPattern varchar(25) , @Grenzdatum datetime2 ) as begin declare @BlockPuffer QBM_YSingleGUID declare @lauf int declare @XUser nvarchar(64) = object_name(@@procid) declare @Xdate datetime = getutcdate3() declare @CountRowsToDelete int insert into @BlockPuffer(UID_SingleGuid) select top (@BlockSize) w.UID_Tree from DialogProcessChain w where w.ReadyForDeleteOrExport4 = 0 and w.XDateUpdated < @Grenzdatum and w.GenProcID like @KeyPattern select @CountRowsToDelete = @@ROWCOUNT select @lauf = @CountRowsToDelete - @BlockSize5 + 1 if @CountRowsToDelete > 0 begin update DialogProcessChain set ReadyForDeleteOrExport = @ReadyForDeleteOrExport , XDateUpdated = @Xdate , XUserUpdated6 = @XUser from DialogProcessChain w join @BlockPuffer p on w.UID_Tree = p.UID_SingleGuid end endLabel: return(@lauf) end 7