Back to OIM Explorer

dbo.QBM_ZMissingDisplayRightFill

Stored ProcedureSQL_STORED_PROCEDURESandbox DB

Stored Procedure.

Source: sandbox-db sys.sql_modules

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

  • references source dbo.QBM_FGISessionErrorRethrow source text reference
  • references source dbo.QBM_PMissingDisplayRightFill source text reference
  • references source dbo.QBM_PSessionErrorAdd source text reference

References

Referenced By

  • No direct source references extracted.

Complete Source

SQL44 lines
1CREATE PROCEDURE QBM_ZMissingDisplayRightFill(2  @SlotNumber int3)4AS5BEGIN6  DECLARE @ret int = 07  DECLARE @Rethrow varchar(1000) = dbo.QBM_FGISessionErrorRethrow()8  DECLARE @Tabellen QBM_YCursorBuffer9  DECLARE @ElementCount int10  DECLARE @ElementIndex int11  DECLARE @ElementLast int12  DECLARE @UID_DialogTable varchar(38)13  SET XACT_ABORT OFF14  BEGIN TRY15    INSERT INTO @Tabellen(UID1)16    SELECT17      DISTINCT t.UID_Parameter18    FROM QBMDBQueueCurrent t19      WITH(readpast)20    WHERE21      t.SlotNumber = @SlotNumber22    SELECT @ElementCount = @@ROWCOUNT23    SELECT @ElementIndex = @@IDENTITY - @ElementCount +124    SELECT @ElementLast = @@IDENTITY25    WHILE @ElementIndex <= @ElementLast26    BEGIN27      SELECT TOP 1 @UID_DialogTable = bu.UID128      FROM @Tabellen bu29      WHERE30        bu.ElementIndex = @ElementIndex31      EXEC QBM_PMissingDisplayRightFill @uid_dialogTable32      SELECT @ElementIndex += 133    END34  END TRY35  BEGIN CATCH36    EXEC QBM_PSessionErrorAdd DEFAULT37    RAISERROR(@Rethrow,38    18,39    1)40      WITH NOWAIT41  END CATCH42  endLabel:43  RETURN @ret44END
Open raw exported source
SQL ยท Raw8 lines
1 create   procedure QBM_ZMissingDisplayRightFill ( @SlotNumber int ) as begin declare @ret int = 0 declare @Rethrow varchar(1000) = dbo.QBM_FGISessionErrorRethrow2() declare @Tabellen QBM_YCursorBuffer declare @ElementCount int declare @ElementIndex int declare @ElementLast int declare @UID_DialogTable varchar(383) SET XACT_ABORT OFF BEGIN TRY insert into @Tabellen(UID1) select distinct t.UID_Parameter from QBMDBQueueCurrent t with (readpast) where t.SlotNumber 4= @SlotNumber select @ElementCount = @@ROWCOUNT select @ElementIndex = @@IDENTITY - @ElementCount +1 select @ElementLast = @@IDENTITY while @ElementIndex5 <= @ElementLast begin select top 1 @UID_DialogTable = bu.UID1 from @Tabellen bu where bu.ElementIndex = @ElementIndex exec QBM_PMissingDisplayRightFill6 @uid_dialogTable select @ElementIndex += 1 end  END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR (@Rethrow, 18, 1) WITH NOWAIT END CATCH7 endLabel: return @ret end 8