Back to OIM Explorer

dbo.ADS_ZGroupInADSGroup_Circ

Stored ProcedureSQL_STORED_PROCEDURESandbox DB

Stored Procedure.

Source: sandbox-db sys.sql_modules

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

References

Referenced By

  • No direct source references extracted.

Complete Source

SQL69 lines
1CREATE PROCEDURE ADS_ZGroupInADSGroup_Circ(2  @SlotNumberDummy int,3  @dummy1 varchar(38),4  @Dummy2 varchar(38),5  @GenProcIDDummy varchar(38)6)7AS8BEGIN9  BEGIN TRY10    UPDATE ADSGroupCollection11    SET IsCircular = 112    FROM ADSGroupCollection co13    WHERE14      co.UID_ADSGroupChild <> co.UID_ADSGroupParent AND EXISTS(15    SELECT TOP 1 116    FROM ADSGroupCollection ce17    WHERE18      co.UID_ADSGroupChild = ce.UID_ADSGroupParent AND co.UID_ADSGroupParent = ce.UID_ADSGroupChild) AND IsCircular = 019    UPDATE ADSGroupCollection20    SET IsCircular = 021    FROM ADSGroupCollection co22    WHERE23      co.UID_ADSGroupChild <> co.UID_ADSGroupParent AND NOT EXISTS(24    SELECT TOP 1 125    FROM ADSGroupCollection ce26    WHERE27      co.UID_ADSGroupChild = ce.UID_ADSGroupParent AND co.UID_ADSGroupParent = ce.UID_ADSGroupChild) AND IsCircular = 128    UPDATE ADSGroupCollection29    SET IsCircular = 130    FROM ADSGroupCollection co31    WHERE32      co.UID_ADSGroupChild = co.UID_ADSGroupParent AND EXISTS(33    SELECT TOP 1 134    FROM ADSGroupCollection ce35    WHERE36      co.UID_ADSGroupParent = ce.UID_ADSGroupParent AND ce.UID_ADSGroupChild <> ce.UID_ADSGroupParent AND IsCircular = 1) AND IsCircular = 037    UPDATE ADSGroupCollection38    SET IsCircular = 039    FROM ADSGroupCollection co40    WHERE41      co.UID_ADSGroupChild = co.UID_ADSGroupParent AND NOT EXISTS(42    SELECT TOP 1 143    FROM ADSGroupCollection ce44    WHERE45      co.UID_ADSGroupParent = ce.UID_ADSGroupParent AND ce.UID_ADSGroupChild <> ce.UID_ADSGroupParent AND IsCircular = 1) AND IsCircular = 146    UPDATE ADSGroupCollection47    SET IsCircular = x.IsCircular48    FROM ADSGroupCollection co49    JOIN(50    SELECT51      y.UID_ADSGroupChild,52      y.IsCircular53    FROM ADSGroupCollection y54    WHERE55      y.UID_ADSGroupChild = y.UID_ADSGroupParent) AS x56      ON x.UID_ADSGroupChild = co.UID_ADSGroupChild57    WHERE58      co.IsCircular <> x.IsCircular59  END TRY60  BEGIN CATCH61    EXEC QBM_PSessionErrorAdd DEFAULT62    RAISERROR('',63    18,64    1)65      WITH NOWAIT66  END CATCH67  ende:68  RETURN69END
Open raw exported source
SQL ยท Raw13 lines
1      create   procedure ADS_ZGroupInADSGroup_Circ ( @SlotNumberDummy int , @dummy1 varchar(38) , @Dummy2 varchar(38) , @GenProcIDDummy varchar(382) ) as begin   BEGIN TRY update ADSGroupCollection set IsCircular = 1 from ADSGroupCollection co where co.UID_ADSGroupChild <> co.UID_ADSGroupParent and3 exists (select top 1 1 from ADSGroupCollection ce where co.UID_ADSGroupChild = ce.UID_ADSGroupParent and co.UID_ADSGroupParent = ce.UID_ADSGroupChild 4) and IsCircular = 0  update ADSGroupCollection set IsCircular = 0 from ADSGroupCollection co where co.UID_ADSGroupChild <> co.UID_ADSGroupParent and not5 exists (select top 1 1 from ADSGroupCollection ce where co.UID_ADSGroupChild = ce.UID_ADSGroupParent and co.UID_ADSGroupParent = ce.UID_ADSGroupChild 6) and IsCircular = 1  update ADSGroupCollection set IsCircular = 1 from ADSGroupCollection co where co.UID_ADSGroupChild = co.UID_ADSGroupParent and exists7 (select top 1 1 from ADSGroupCollection ce where co.UID_ADSGroupParent = ce.UID_ADSGroupParent and ce.UID_ADSGroupChild <> ce.UID_ADSGroupParent and IsCircular8 = 1 ) and IsCircular = 0 update ADSGroupCollection set IsCircular = 0 from ADSGroupCollection co where co.UID_ADSGroupChild = co.UID_ADSGroupParent and9 not exists (select top 1 1 from ADSGroupCollection ce where co.UID_ADSGroupParent = ce.UID_ADSGroupParent and ce.UID_ADSGroupChild <> ce.UID_ADSGroupParent10 and IsCircular = 1 ) and IsCircular = 1 update ADSGroupCollection set IsCircular = x.IsCircular from ADSGroupCollection co join (select y.UID_ADSGroupChild11, y.IsCircular from ADSGroupCollection y where y.UID_ADSGroupChild = y.UID_ADSGroupParent ) as x on x.UID_ADSGroupChild = co.UID_ADSGroupChild where co.IsCircular12 <> x.IsCircular  END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR ('', 18, 1) WITH NOWAIT END CATCH  ende: return end 13