Back to OIM Explorer

dbo.QER_PITShopProductNodeCheck

Stored ProcedureSQL_STORED_PROCEDURESandbox DB

Stored Procedure. HOFireEvent -> ITShopOrg.DeletePRNode at line 72; Single DBQueue insert -> QER-K-OrgAutoChild / QER_ZITShopProductNodeCheck at line 72; Single DBQueue insert -> QER-K-OrgAutoChild / QER_ZITShopProductNodeCheck at line 96; References QBM_PJobCreate*

Source: sandbox-db sys.sql_modules

Source size: 8.089 characters

Interpretation

  • Database routine. Review parameters, called procedures, DBQueue inserts, and QBM_PJobCreate helper calls before assuming side effects.
  • Object-layer bridge detected through QBM_PJobCreate helper usage.
  • DBQueue relation detected. Follow the task procedure and referenced-by list for async processing.

Relations

  • HOFireEvent -> ITShopOrg.DeletePRNode at line 72
  • Single DBQueue insert -> QER-K-OrgAutoChild / QER_ZITShopProductNodeCheck at line 72
  • Single DBQueue insert -> QER-K-OrgAutoChild / QER_ZITShopProductNodeCheck at line 96
  • References QBM_PJobCreate*
  • References QBM_PJobCreate_HOFireEvent*
  • References QBM_PDBQueueInsert_Single

Typed Edges

  • fires event ITShopOrg.DeletePRNode HOFireEvent -> ITShopOrg.DeletePRNode at line 72
  • queues DBQueue task QER_ZITShopProductNodeCheck at line 72 Single DBQueue insert -> QER-K-OrgAutoChild / QER_ZITShopProductNodeCheck at line 72
  • queues DBQueue task QER_ZITShopProductNodeCheck at line 96 Single DBQueue insert -> QER-K-OrgAutoChild / QER_ZITShopProductNodeCheck at line 96
  • references source dbo.QBM_FCVBinaryToString source text reference
  • references source dbo.QBM_FCVElementToObjectKey1 source text reference
  • references source dbo.QBM_FCVStringToInt source text reference
  • references source dbo.QBM_FGIBitPatternXOrigin source text reference
  • references source dbo.QBM_FGIConfigparmValue source text reference
  • references source dbo.QBM_FGISessionContext source text reference
  • references source dbo.QBM_PDBQueueInsert_Single source text reference
  • references source dbo.QBM_PJobCreate source text reference
  • references source dbo.QBM_PJobCreate_HOFireEvent source text reference
  • references source dbo.QBM_PJobCreate_HOFireEvent_L source text reference
  • references source dbo.QBM_PJournal source text reference
  • references source dbo.QBM_PSessionContextSet source text reference
  • references source dbo.QBM_PSessionErrorAdd source text reference
  • references source dbo.QER_PITShopOrderMove source text reference
  • references source dbo.QER_PITShopOrderMove_bulk source text reference
  • references source dbo.QER_PITShopProductNodeCreate source text reference
  • references source dbo.QER_PITShopProductNodeCreate_b source text reference
  • queues DBQueue task QER-K-OrgAutoChild -> QER_ZITShopProductNodeCheck QBM_PDBQueueInsert_Single 'QER-K-OrgAutoChild', @UID_OrgBO, '', @GenProcID end END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR ('', 18 , 1) WITH NOWAIT END CATCH endLabel: exec QBM_PSessionContextSet 'GenProcID', @GenProcID…

References

Referenced By

Complete Source

SQL328 lines
1CREATE PROCEDURE QER_PITShopProductNodeCheck(2  @UID_OrgBO varchar(38),3  @GenProcID varchar(38)4)5AS6BEGIN7  DECLARE @UID_OrgPR varchar(38)8  DECLARE @startat datetime9  DECLARE @BasisObjectKey varchar(138)10  DECLARE @SQLcmd nvarchar(max)11  DECLARE @DebugSwitch int = 012  DECLARE @MerkTable1 QBM_YSingleGUID13  DECLARE @MerkTable2 QBM_YSingleGUID14  DECLARE @MerkTableNoAssign QBM_YCursorBuffer15  DECLARE @MerkTable3 QBM_YParameterList16  DECLARE @StringPatternInherit varchar(16)17  DECLARE @StringPatternInheritInv varchar(16)18  DECLARE @DebugLevel char(1) = 'W'19  DECLARE @RowLimitNodeCheck int20  DECLARE @RowCounterNodeCheck int21  DECLARE @GenProcID_R varchar(38) = dbo.QBM_FGISessionContext('')22  DECLARE @ElementLast int23  DECLARE @ElementCount int24  DECLARE @ElementIndex int25  DECLARE @PWOsToMove QBM_YParameterList26  DECLARE @NodeCreateBuffer QBM_YParameterList27  DECLARE @WirMachenDasNochEinmal BIT = 028  DECLARE @EntriesToFire QBM_YParameterList29  BEGIN TRY30    SELECT31      @StringPatternInherit = dbo.QBM_FCVBinaryToString(CONVERT(varbinary, dbo.QBM_FGIBitPatternXOrigin('|Inherit|',32      0)),33      0)34    SELECT35      @StringPatternInheritInv = dbo.QBM_FCVBinaryToString(CONVERT(varbinary, dbo.QBM_FGIBitPatternXOrigin('|Inherit|',36      1)),37      0)38    SELECT @RowCounterNodeCheck = 039    SELECT40      @RowLimitNodeCheck = dbo.QBM_FCVStringToInt(dbo.QBM_FGIConfigparmValue('QER\ITShop\LimitOfNodeCheck'),41      500)42    IF NOT EXISTS(43      SELECT TOP 1 144      FROM BaseTree45      WHERE46        uid_org = isnull(@UID_OrgBO, ''))47    BEGIN48      SELECT49        @SQLcmd = N 'BaseTree ' + rtrim(@UID_OrgBO) + ' not exists, Job ORGAUTOCHILD was killed'50      IF @DebugSwitch > 051      BEGIN52        print @SQLCmd53      END54      EXEC QBM_Pjournal @SQLcmd,55        @@procid,56      'D',57        @DebugLevel58      GOTO endLabel59    END60    SELECT61      @SQLCmd = string_agg(CONCAT(convert(nvarchar(max), ''), '62	 select b.uid_org 63				from BaseTree b join ',64      t.TableName, ' bha on b.UID_ParentOrg = ''', @UID_OrgBO, '''65													and b.uid_org = bha.uid_org66			where bha.XOrigin & ',67      @StringPatternInheritInv, ' > 0 68			 and bha.XIsInEffect = 169		'),70      '71			union all72		')73    FROM BaseTreeAssign a74    JOIN DialogTable t75      WITH(readpast)76      ON a.UID_DialogTableMN = t.UID_DialogTable77    WHERE78      a.IsITShopEnabled = 179    IF @DebugSwitch > 080    BEGIN81      print @SQLCmd82    END83    INSERT INTO @MerkTable1(UID_SingleGuid)84    EXEC sp_executesql @SQLCmd85    IF @DebugSwitch > 086    BEGIN87      SELECT *88      FROM @MerkTable189    END90    SELECT91      @SQLcmd = string_agg(CONCAT(convert(nvarchar(max), ''), '92	   select c.uid_org93	     from BaseTree o join ',94      t.TableName, ' c on o.uid_org = c.uid_org95											and o.uid_parentorg = ''', @UID_OrgBO, '''96		where not exists (select top 1 1 97							from '98      , t.TableName, ' p 99							where p.uid_org = ''', @UID_OrgBO, '''100							and p.', c.ColumnName, ' = c.',101      c.ColumnName, '102							and p.XOrigin & ', @StringPatternInheritInv, ' > 0 103						)104			and c.XOrigin & ',105      @StringPatternInheritInv, ' > 0 106			and c.XIsInEffect = 1107			'),108      '109			union all110		')111    FROM BaseTreeAssign a112    JOIN DialogTable t113      WITH(readpast)114      ON a.UID_DialogTableMN = t.UID_DialogTable115    JOIN DialogColumn c116      WITH(readpast)117      ON t.UID_DialogTable = c.UID_DialogTable AND c.IsPKMember = 1 AND c.ColumnName <> 'UID_Org'118    WHERE119      a.IsITShopEnabled = 1120    IF @DebugSwitch > 0121    BEGIN122      print @SQLCmd123    END124    INSERT INTO @MerkTable2(UID_SingleGuid)125    EXEC sp_executesql @SQLCmd126    IF @DebugSwitch > 0127    BEGIN128      SELECT *129      FROM @MerkTable2130    END131    INSERT INTO @MerkTableNoAssign(UID1)132    SELECT133      DISTINCT b.UID_Org134    FROM BaseTree b135    WHERE136      b.UID_ParentOrg = @UID_OrgBO137    SELECT138      @SQLcmd = string_agg(CONCAT(convert(nvarchar(max), ''), '139	 select b.uid_org 140				from BaseTree b join ',141      t.TableName, ' bha on b.UID_ParentOrg = ''', @UID_OrgBO, '''142													and b.uid_org = bha.uid_org143			where bha.XOrigin & ',144      @StringPatternInheritInv, ' > 0 145			and bha.XIsInEffect = 1146		'),147      '148			union all149		')150    FROM BaseTreeAssign a151    JOIN DialogTable t152      WITH(readpast)153      ON a.UID_DialogTableMN = t.UID_DialogTable154    WHERE155      a.IsITShopEnabled = 1156    IF @DebugSwitch > 0157    BEGIN158      print @SQLCmd159    END160    INSERT INTO @MerkTableNoAssign(UID1)161    EXEC sp_executesql @SQLCmd162    IF @DebugSwitch > 0163    BEGIN164      SELECT UID1165      FROM @MerkTableNoAssign166    END167    EXEC QBM_PSessionContextSet 'GenProcID',168      @GenProcID169    DECLARE @ElementToDelte QBM_YCursorBuffer170    INSERT INTO @ElementToDelte(UID1)171    SELECT m.UID_SingleGuid172    FROM @MerkTable1 m173    GROUP BY m.UID_SingleGuid174    HAVING COUNT(*) > 1175    UNION176    SELECT m.UID_SingleGuid177    FROM @MerkTable2 m178    UNION179    SELECT m.UID1180    FROM @MerkTableNoAssign m181    GROUP BY m.UID1182    HAVING COUNT(*) = 1183    SELECT @ElementCount = @@ROWCOUNT184    SELECT @ElementIndex = @@IDENTITY - @ElementCount +1185    SELECT @ElementLast = @@IDENTITY186    IF @DebugSwitch > 0187    BEGIN188      print str(@ElementCount) + ' zu vernichtende Sachen'189    END190    WHILE @ElementIndex <= @ElementLast AND @RowCounterNodeCheck < @RowLimitNodeCheck AND @WirMachenDasNochEinmal = 0191    BEGIN192      SELECT TOP 1 @UID_OrgPR = bu.UID1193      FROM @ElementToDelte bu194      WHERE195        bu.ElementIndex = @ElementIndex196      SELECT197        @SQLcmd = string_agg(CONCAT(convert(nvarchar(max), ''), '198				update ', t.TableName, ' set XOrigin = 0199						where uid_org = ''',200        @UID_OrgPR, '''201			   delete ', t.TableName, ' 202			   where uid_org = ''', @UID_OrgPR, ''''),203        nchar(13) + nchar(10))204      FROM BaseTreeAssign a205      JOIN DialogTable t206        WITH(readpast)207        ON a.UID_DialogTableMN = t.UID_DialogTable208      WHERE209        a.IsITShopEnabled = 1210      IF @DebugSwitch > 0211      BEGIN212        print @SQLCmd213      END214      EXEC sp_executesql @SQLCmd215      DELETE @PWOsToMove216      INSERT INTO @PWOsToMove(Parameter1,217      Parameter2,218      Parameter3,219      HasContentFull)220      SELECT221        pwo.UID_PersonWantsOrg,222        NULL,223        @GenProcID,224        0225      FROM Personwantsorg pwo226      WHERE227        uid_org = @UID_OrgPR228      EXEC QER_PITShopOrderMove_bulk @PWOsToMove229      IF @ElementCount > 1 AND(230        SELECT count(*)231      FROM @PWOsToMove) > 500232      BEGIN233        SELECT @WirMachenDasNochEinmal = 1234      END235      DELETE @EntriesToFire236      INSERT INTO @EntriesToFire(Parameter1)237      SELECT238        dbo.QBM_FCVElementToObjectKey1('ITShopOrg',239        'UID_ITShopOrg',240        @UID_OrgPR)241      EXEC QBM_PJobCreate_HOFireEvent_L 'ITShopOrg',242        @EntriesToFire,243      'DeletePRNode',244        @GenProcID,245        @CheckForExisting = 1,246        @AdditionalObjectKeysAffected = DEFAULT247      SELECT @RowCounterNodeCheck += 1248      SELECT @ElementIndex += 1249    END250    SELECT251      @SQLCmd = string_agg(CONCAT(convert(nvarchar(max), ''), '252	  select zz.XObjectKey253	   from  ',254      t.TableName, ' h join ', prod.TableName, ' zz on h.', c.ColumnName, ' = zz.', c.ColumnName, '255		where h.uid_org = ''',256      @UID_OrgBO, '''257			and not exists (select top 1 1 from 258								BaseTree o join ', t.TableName, ' c on o.uid_org = c.uid_org259								where o.uid_parentorg = h.uid_org 260								and  c.'261      , c.ColumnName, ' = h.', c.ColumnName, '262							)263			and h.XOrigin & ', @StringPatternInheritInv, ' > 0264		',265    CASE266      WHEN ef.UID_DialogColumn > ' ' THEN267    ' and h.XIsInEffect = 1 '268    ELSE ''269    END),270    '271			union all272		')273    FROM BaseTreeAssign a274      WITH(readpast)275    JOIN DialogTable t276      WITH(readpast)277      ON a.UID_DialogTableMN = t.UID_DialogTable278    JOIN DialogTable prod279      WITH(readpast)280      ON a.UID_DialogTableElement = prod.UID_DialogTable281    JOIN DialogColumn c282      WITH(readpast)283      ON t.UID_DialogTable = c.UID_DialogTable AND c.IsPKMember = 1 AND c.ColumnName <> 'UID_Org'284    LEFT285    OUTER286    JOIN DialogColumn ef287      WITH(readpast)288      ON t.UID_DialogTable = ef.UID_DialogTable AND ef.ColumnName = 'XIsInEffect'289    WHERE290      a.IsITShopEnabled = 1291    IF @DebugSwitch > 0292    BEGIN293      Print '======== Starten Neuanlage' print @SQLCmd294    END295    INSERT INTO @MerkTable3(Parameter1)296    EXEC sp_executesql @SQLCmd297    IF @DebugSwitch > 0298    BEGIN299      SELECT *300      FROM @MerkTable3301    END302    INSERT INTO @NodeCreateBuffer(Parameter1)303    SELECT TOP(@RowLimitNodeCheck) m.Parameter1304    FROM @MerkTable3 m305    SELECT @RowCounterNodeCheck += @@ROWCOUNT306    EXEC QER_PITShopProductNodeCreate_b @UID_OrgBO,307      @NodeCreateBuffer,308      @GenProcID NochMalEntscheidung:309    IF @RowCounterNodeCheck >= @RowLimitNodeCheck OR @WirMachenDasNochEinmal = 1310    BEGIN311      EXEC QBM_PDBQueueInsert_Single 'QER-K-OrgAutoChild',312        @UID_OrgBO,313      '',314        @GenProcID315    END316  END TRY317  BEGIN CATCH318    EXEC QBM_PSessionErrorAdd DEFAULT319    RAISERROR('',320    18,321    1)322      WITH NOWAIT323  END CATCH324  endLabel:325  EXEC QBM_PSessionContextSet 'GenProcID',326    @GenProcID_R327  RETURN328END
Open raw exported source
SQL · Raw98 lines
1         create   procedure QER_PITShopProductNodeCheck(@UID_OrgBO varchar(38) , @GenProcID varchar(38) )  AS begin declare @UID_OrgPR varchar(382) declare @startat datetime declare @BasisObjectKey varchar(138) declare @SQLcmd nvarchar(max) declare @DebugSwitch int = 0 declare @MerkTable1 QBM_YSingleGUID3 declare @MerkTable2 QBM_YSingleGUID  declare @MerkTableNoAssign QBM_YCursorBuffer  declare @MerkTable3 QBM_YParameterList  declare @StringPatternInherit4 varchar(16) declare @StringPatternInheritInv varchar(16) declare @DebugLevel char(1) = 'W' declare @RowLimitNodeCheck int declare @RowCounterNodeCheck5 int declare @GenProcID_R varchar(38) = dbo.QBM_FGISessionContext('') declare @ElementLast int declare @ElementCount int declare @ElementIndex int declare6 @PWOsToMove QBM_YParameterList     declare @NodeCreateBuffer QBM_YParameterList declare @WirMachenDasNochEinmal bit = 0 declare @EntriesToFire QBM_YParameterList7 BEGIN TRY select @StringPatternInherit = dbo.QBM_FCVBinaryToString( CONVERT(varbinary, dbo.QBM_FGIBitPatternXOrigin('|Inherit|',0)), 0) select @StringPatternInheritInv8 = dbo.QBM_FCVBinaryToString( CONVERT(varbinary, dbo.QBM_FGIBitPatternXOrigin('|Inherit|',1)), 0) select @RowCounterNodeCheck = 0 select @RowLimitNodeCheck9 = dbo.QBM_FCVStringToInt(dbo.QBM_FGIConfigparmValue('QER\ITShop\LimitOfNodeCheck'), 500)  if not exists (select top 1 1 from BaseTree where uid_org = 10isnull(@UID_OrgBO,'')) begin select @SQLcmd = N'BaseTree ' + rtrim(@UID_OrgBO) + ' not exists, Job ORGAUTOCHILD was killed' if @DebugSwitch > 0 begin print11 @SQLCmd end exec QBM_Pjournal @SQLcmd, @@procid, 'D', @DebugLevel goto endLabel  end   select @SQLCmd = string_agg( concat( convert(nvarchar(max), '')12, '13	 select b.uid_org 14				from BaseTree b join ' , t.TableName , ' bha on b.UID_ParentOrg = ''' , @UID_OrgBO , '''15													and b.uid_org = bha.uid_org16			where bha.XOrigin & '17 , @StringPatternInheritInv , ' > 0 18			 and bha.XIsInEffect = 119		' )  , '20			union all21		' )   from BaseTreeAssign a join DialogTable t with (readpast22) on a.UID_DialogTableMN = t.UID_DialogTable where a.IsITShopEnabled = 1 if @DebugSwitch > 0 begin print @SQLCmd end insert into @MerkTable1(UID_SingleGuid23 ) exec sp_executesql @SQLCmd if @DebugSwitch > 0 begin select * from @MerkTable1 end   select @SQLcmd = string_agg( concat( convert(nvarchar(max), '')24, '25	   select c.uid_org26	     from BaseTree o join ' , t.TableName , ' c on o.uid_org = c.uid_org27											and o.uid_parentorg = ''' , @UID_OrgBO28 , '''29		where not exists (select top 1 1 30							from ' , t.TableName , ' p 31							where p.uid_org = ''' , @UID_OrgBO , '''32							and p.' , c.ColumnName33 , ' = c.' , c.ColumnName , '34							and p.XOrigin & ' , @StringPatternInheritInv , ' > 0 35						)36			and c.XOrigin & ' , @StringPatternInheritInv ,37 ' > 0 38			and c.XIsInEffect = 139			' )  , '40			union all41		' )   from BaseTreeAssign a join DialogTable t with (readpast) on a.UID_DialogTableMN =42 t.UID_DialogTable join DialogColumn c with (readpast) on t.UID_DialogTable = c.UID_DialogTable and c.IsPKMember = 1 and c.ColumnName <> 'UID_Org'  where43 a.IsITShopEnabled = 1 if @DebugSwitch > 0 begin print @SQLCmd end insert into @MerkTable2(UID_SingleGuid ) exec sp_executesql @SQLCmd if @DebugSwitch 44> 0 begin select * from @MerkTable2 end   insert into @MerkTableNoAssign (UID1 ) select distinct b.UID_Org from BaseTree b where b.UID_ParentOrg = @UID_OrgBO45   select @SQLcmd = string_agg( concat( convert(nvarchar(max), ''), '46	 select b.uid_org 47				from BaseTree b join ' , t.TableName , ' bha on b.UID_ParentOrg = '''48 , @UID_OrgBO , '''49													and b.uid_org = bha.uid_org50			where bha.XOrigin & ' , @StringPatternInheritInv , ' > 0 51			and bha.XIsInEffect = 152		'53 )  , '54			union all55		' )   from BaseTreeAssign a join DialogTable t with (readpast) on a.UID_DialogTableMN = t.UID_DialogTable where a.IsITShopEnabled56 = 1 if @DebugSwitch > 0 begin print @SQLCmd end insert into @MerkTableNoAssign(UID1 ) exec sp_executesql @SQLCmd if @DebugSwitch > 0 begin select UID157 from @MerkTableNoAssign end  exec QBM_PSessionContextSet 'GenProcID', @GenProcID   declare @ElementToDelte QBM_YCursorBuffer insert into @ElementToDelte58 (UID1) select m.UID_SingleGuid  from @MerkTable1 m group by m.UID_SingleGuid  having COUNT(*) > 1 union select m.UID_SingleGuid  from @MerkTable2 m union59 select m.UID1  from @MerkTableNoAssign m group by m.UID1  having COUNT(*) = 1  select @ElementCount = @@ROWCOUNT select @ElementIndex = @@IDENTITY - @ElementCount60 +1 select @ElementLast = @@IDENTITY if @DebugSwitch > 0 begin print str(@ElementCount) + ' zu vernichtende Sachen' end while @ElementIndex <= @ElementLast61 and @RowCounterNodeCheck < @RowLimitNodeCheck and @WirMachenDasNochEinmal = 0 begin select top 1 @UID_OrgPR = bu.UID1 from @ElementToDelte bu where bu.ElementIndex62 = @ElementIndex     select @SQLcmd = string_agg( concat(convert(nvarchar(max), ''), '63				update ' , t.TableName , ' set XOrigin = 064						where uid_org = '''65 , @UID_OrgPR , '''66			   delete ' , t.TableName , ' 67			   where uid_org = ''' , @UID_OrgPR , '''' )  , nchar(13) + nchar(10) )  from BaseTreeAssign68 a join DialogTable t with (readpast) on a.UID_DialogTableMN = t.UID_DialogTable where a.IsITShopEnabled = 1 if @DebugSwitch > 0 begin print @SQLCmd end69 exec sp_executesql @SQLCmd    delete @PWOsToMove insert into @PWOsToMove (Parameter1, Parameter2, Parameter3, HasContentFull) select pwo.UID_PersonWantsOrg70, null, @GenProcID, 0 from Personwantsorg pwo where uid_org = @UID_OrgPR exec QER_PITShopOrderMove_bulk @PWOsToMove if @ElementCount > 1  and ( select 71count(*) from @PWOsToMove ) > 500 begin select @WirMachenDasNochEinmal = 1 end   delete @EntriesToFire insert into @EntriesToFire (Parameter1) select dbo.QBM_FCVElementToObjectKey172('ITShopOrg', 'UID_ITShopOrg', @UID_OrgPR) exec QBM_PJobCreate_HOFireEvent_L 'ITShopOrg', @EntriesToFire ,'DeletePRNode', @GenProcID , @CheckForExisting73 = 1 , @AdditionalObjectKeysAffected = DEFAULT select @RowCounterNodeCheck += 1 select @ElementIndex += 1 end      select @SQLCmd = string_agg( concat(74 convert(nvarchar(max), ''), '75	  select zz.XObjectKey76	   from  ' , t.TableName , ' h join ' , prod.TableName , ' zz on h.' , c.ColumnName , ' = zz.'77 , c.ColumnName , '78		where h.uid_org = ''' , @UID_OrgBO , '''79			and not exists (select top 1 1 from 80								BaseTree o join ' , t.TableName , ' c on o.uid_org = c.uid_org81								where o.uid_parentorg = h.uid_org 82								and  c.'83 , c.ColumnName , ' = h.' , c.ColumnName , '84							)85			and h.XOrigin & ' , @StringPatternInheritInv , ' > 086		' , case when ef.UID_DialogColumn > 87' ' then ' and h.XIsInEffect = 1 ' else '' end )  , '88			union all89		' )  from BaseTreeAssign a with (readpast) join DialogTable t with (readpast) on90 a.UID_DialogTableMN = t.UID_DialogTable join DialogTable prod with (readpast) on a.UID_DialogTableElement = prod.UID_DialogTable join DialogColumn c with91 (readpast) on t.UID_DialogTable = c.UID_DialogTable and c.IsPKMember = 1 and c.ColumnName <> 'UID_Org'  left outer join DialogColumn ef with (readpast92) on t.UID_DialogTable = ef.UID_DialogTable and ef.ColumnName = 'XIsInEffect' where a.IsITShopEnabled = 1 if @DebugSwitch > 0 begin Print '======== Starten Neuanlage'93 print @SQLCmd end insert into @MerkTable3(Parameter1 ) exec sp_executesql @SQLCmd if @DebugSwitch > 0 begin select * from @MerkTable3 end insert into 94@NodeCreateBuffer (Parameter1) select top (@RowLimitNodeCheck) m.Parameter1  from @MerkTable3 m select @RowCounterNodeCheck += @@ROWCOUNT exec QER_PITShopProductNodeCreate_b95 @UID_OrgBO, @NodeCreateBuffer, @GenProcID NochMalEntscheidung:  if @RowCounterNodeCheck >= @RowLimitNodeCheck or @WirMachenDasNochEinmal = 1 begin exec96 QBM_PDBQueueInsert_Single 'QER-K-OrgAutoChild', @UID_OrgBO, '', @GenProcID end END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR ('', 1897, 1) WITH NOWAIT END CATCH  endLabel: exec QBM_PSessionContextSet 'GenProcID', @GenProcID_R return end 98