Back to OIM Explorer

dbo.QER_PRulerDetect_OX

Stored ProcedureSQL_STORED_PROCEDURESandbox DB

Stored Procedure.

Source: sandbox-db sys.sql_modules

Source size: 1.765 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_FCVStringToList source text reference
  • references source dbo.QBM_FCVStringToListSplitted source text reference
  • references source dbo.QBM_FCVElementToObjectKey1 source text reference
  • references source dbo.QER_FGIPWORulerOrigin source text reference
  • references source dbo.QBM_PSessionErrorAdd source text reference

References

Referenced By

  • No direct source references extracted.

Complete Source

SQL76 lines
1CREATE PROCEDURE QER_PRulerDetect_OX(2  @uid_PersonWantsOrg varchar(38),3  @UID_QERWorkingStep varchar(38)4)5AS6BEGIN7  DECLARE @WhereClauseMissnutzt nvarchar(max)8  DECLARE @ParameterName nvarchar(256)9  DECLARE @ColumnNameAERole varchar(38)10  DECLARE @XObjectKeyPWO varchar(138) = dbo.QBM_FCVElementToObjectKey1('PersonWantsOrg',11  '',12  @UID_PersonWantsOrg)13  DECLARE @cmd nvarchar(max)14  SET XACT_ABORT OFF15  BEGIN TRY16    SELECT TOP 1 @WhereClauseMissnutzt = s.WhereClause17    FROM QERWorkingStep s18    WHERE19      s.UID_QERWorkingStep = @UID_QERWorkingStep20    SELECT TOP 1 @ParameterName = s.ParameterName21    FROM dbo.QBM_FCVStringToListSplitted(@WhereClauseMissnutzt,22    char(7),23    1,24    0,25    '') s26    WHERE27      s.OrderNumber = 128    SELECT TOP 1 @ColumnNameAERole =29    LEFT(s.ParameterName,30    30)31    FROM dbo.QBM_FCVStringToListSplitted(@WhereClauseMissnutzt,32    char(7),33    1,34    0,35    '') s36    WHERE37      s.OrderNumber = 238    SELECT39      TOP 1 @cmd = CONCAT('select pio.UID_Person     -- die Entscheider40							, dbo.QER_FGIPWORulerOrigin(pio.XObjectKey) as UID_PWORulerOrigin41       from '42      ,43      t.TableName,44      ' b join PersonInBaseTree pio on b.',45      @ColumnNameAERole,46      ' = pio.UID_Org47       where b.',48      c.ColumnName,49      ' = ''',50      pa.ParameterValue,51      ''' -- der wert aus oben ParameterValue5253                           ')54    FROM DialogParameterSet s55    JOIN DialogParameter pa56      ON s.UID_DialogParameterSet = pa.UID_DialogParameterSet57    JOIN DialogColumn c58      ON pa.UID_DialogColumnQuery = c.UID_DialogColumn59    JOIN DialogTable t60      ON c.UID_DialogTable = t.UID_DialogTable61    WHERE62      s.ObjectKeyUsedBy = @XObjectKeyPWO AND pa.ParameterName = @ParameterName63    INSERT INTO #Ruler(UID_Person,64    UID_PWORulerOrigin)65    EXEC sp_executesql @cmd66  END TRY67  BEGIN CATCH68    EXEC QBM_PSessionErrorAdd DEFAULT,69      @cmd70    RAISERROR('',71    18,72    1)73      WITH NOWAIT74  END CATCH75  endLabel:76END
Open raw exported source
SQL ยท Raw17 lines
1   create   procedure QER_PRulerDetect_OX ( @uid_PersonWantsOrg varchar(38) , @UID_QERWorkingStep varchar(38) ) as begin declare @WhereClauseMissnutzt2 nvarchar(max) declare @ParameterName nvarchar(256) declare @ColumnNameAERole varchar(38) declare @XObjectKeyPWO varchar(138) = dbo.QBM_FCVElementToObjectKey13('PersonWantsOrg', '', @UID_PersonWantsOrg) declare @cmd nvarchar(max) SET XACT_ABORT OFF BEGIN TRY select top 1 @WhereClauseMissnutzt = s.WhereClause 4from QERWorkingStep s where s.UID_QERWorkingStep = @UID_QERWorkingStep  select top 1 @ParameterName = s.ParameterName from dbo.QBM_FCVStringToListSplitted5(@WhereClauseMissnutzt, char(7), 1, 0, '') s where s.OrderNumber = 1 select top 1 @ColumnNameAERole = left(s.ParameterName, 30) from dbo.QBM_FCVStringToListSplitted6(@WhereClauseMissnutzt, char(7), 1, 0, '') s where s.OrderNumber = 2   select top 1 @cmd = concat('select pio.UID_Person     -- die Entscheider7							, dbo.QER_FGIPWORulerOrigin(pio.XObjectKey) as UID_PWORulerOrigin8       from '9, t.TableName, ' b join PersonInBaseTree pio on b.', @ColumnNameAERole ,' = pio.UID_Org10       where b.', c.ColumnName ,' = ''', pa.ParameterValue ,''' -- der wert aus oben ParameterValue1112                           '13 )  from DialogParameterSet s join DialogParameter pa on s.UID_DialogParameterSet = pa.UID_DialogParameterSet join DialogColumn c on pa.UID_DialogColumnQuery14 = c.UID_DialogColumn join DialogTable t on c.UID_DialogTable = t.UID_DialogTable where s.ObjectKeyUsedBy = @XObjectKeyPWO  and pa.ParameterName = @ParameterName15   insert into #Ruler(UID_Person, UID_PWORulerOrigin) exec sp_executesql @cmd END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default ,@cmd RAISERROR (''16, 18, 1) WITH NOWAIT END CATCH endLabel: end 17