Back to OIM Explorer

dbo.QBM_PA164BD06A63979BC96DA633_a

Stored ProcedureSQL_STORED_PROCEDURESandbox DB

Stored Procedure.

Source: sandbox-db sys.sql_modules

Source size: 813 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

SQL29 lines
1CREATE PROCEDURE QBM_PA164BD06A63979BC96DA633_a(2  @BlockSize int,3  @ReadyForDeleteOrExport int,4  @KeyPattern varchar(25),5  @Grenzdatum datetime6)7AS8BEGIN9  DECLARE @BlockPuffer QBM_YSingleGUID10  DECLARE @lauf int11  DECLARE @CountRowsToDelete int12  INSERT INTO @BlockPuffer(UID_SingleGuid)13  SELECT TOP(@BlockSize) w.UID_DialogWatchOperation14  FROM DialogWatchOperation w15  WHERE16    w.ReadyForDeleteOrExport = 0 AND w.OperationDate < @Grenzdatum AND w.GenProcID LIKE @KeyPattern17  SELECT @CountRowsToDelete = @@ROWCOUNT18  SELECT @lauf = @CountRowsToDelete - @BlockSize + 119  IF @CountRowsToDelete > 020  BEGIN21    UPDATE DialogWatchOperation22    SET ReadyForDeleteOrExport = @ReadyForDeleteOrExport23    FROM DialogWatchOperation w24    JOIN @BlockPuffer p25      ON w.UID_DialogWatchOperation = p.UID_SingleGuid26  END27  endLabel:28  RETURN(@lauf)29END
Open raw exported source
SQL ยท Raw7 lines
1     create   procedure QBM_PA164BD06A63979BC96DA633_a( @BlockSize int , @ReadyForDeleteOrExport int , @KeyPattern varchar(25) , @Grenzdatum datetime2 ) as begin declare @BlockPuffer QBM_YSingleGUID declare @lauf int declare @CountRowsToDelete int insert into @BlockPuffer(UID_SingleGuid) select top (@BlockSize3) w.UID_DialogWatchOperation from DialogWatchOperation w where w.ReadyForDeleteOrExport = 0 and w.OperationDate < @Grenzdatum and w.GenProcID like @KeyPattern4 select @CountRowsToDelete = @@ROWCOUNT select @lauf = @CountRowsToDelete - @BlockSize + 1 if @CountRowsToDelete > 0 begin update DialogWatchOperation 5set ReadyForDeleteOrExport = @ReadyForDeleteOrExport from DialogWatchOperation w join @BlockPuffer p on w.UID_DialogWatchOperation = p.UID_SingleGuid end6 endLabel: return(@lauf) end 7