Back to OIM Explorer

dbo.QER_ZPersonCheckDynUser

Stored ProcedureSQL_STORED_PROCEDURESandbox DB

Stored Procedure.

Source: sandbox-db sys.sql_modules

Source size: 912 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_PDynamicUserForPerson source text reference
  • references source dbo.QBM_PSessionErrorAdd source text reference

References

Referenced By

  • No direct source references extracted.

Complete Source

SQL42 lines
1CREATE PROCEDURE QER_ZPersonCheckDynUser(2  @SlotNumber int3)4AS5BEGIN6  DECLARE @UID_DialogUser varchar(38)7  DECLARE @UID_Person varchar(38)8  DECLARE @ElementLast int9  DECLARE @ElementBufferMulti QBM_YCursorBuffer10  DECLARE @ElementCount int11  DECLARE @ElementIndex int12  BEGIN TRY13    INSERT INTO @ElementBufferMulti(UID1)14    SELECT cu.UID_Parameter15    FROM QBMDBQueueCurrent cu16      WITH(readpast)17    WHERE18      cu.SlotNumber = @SlotNumber19    SELECT @ElementCount = @@ROWCOUNT20    SELECT @ElementIndex = @@IDENTITY - @ElementCount +121    SELECT @ElementLast = @@IDENTITY22    WHILE @ElementIndex <= @ElementLast23    BEGIN24      SELECT TOP 1 @UID_Person = bu.UID125      FROM @ElementBufferMulti bu26      WHERE27        bu.ElementIndex = @ElementIndex28      EXEC QBM_PDynamicUserForPerson @UID_Person,29      NULL,30        @UID_DialogUser OUTPUT31      SELECT @ElementIndex += 132    END33  END TRY34  BEGIN CATCH35    EXEC QBM_PSessionErrorAdd DEFAULT36    RAISERROR('',37    18,38    1)39      WITH NOWAIT40  END CATCH41  endLabel:42END
Open raw exported source
SQL ยท Raw7 lines
1   create   procedure QER_ZPersonCheckDynUser (@SlotNumber int) AS begin declare @UID_DialogUser varchar(38) declare @UID_Person varchar(38) declare2 @ElementLast int declare @ElementBufferMulti QBM_YCursorBuffer declare @ElementCount int declare @ElementIndex int BEGIN TRY   insert into @ElementBufferMulti3 (UID1) select cu.UID_Parameter from QBMDBQueueCurrent cu with (readpast) where cu.SlotNumber = @SlotNumber select @ElementCount = @@ROWCOUNT select @ElementIndex4 = @@IDENTITY - @ElementCount +1 select @ElementLast = @@IDENTITY  while @ElementIndex <= @ElementLast begin select top 1 @UID_Person = bu.UID1 from @ElementBufferMulti5 bu where bu.ElementIndex = @ElementIndex exec QBM_PDynamicUserForPerson @UID_Person, null, @UID_DialogUser output      select @ElementIndex += 1 end  6END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR ('', 18, 1) WITH NOWAIT END CATCH endLabel: end 7