Back to OIM Explorer

dbo.ADS_FGIGroupChangeValid

Scalar FunctionSQL_SCALAR_FUNCTIONSandbox DB

Scalar Function.

Source: sandbox-db sys.sql_modules

Source size: 1.649 characters

Interpretation

  • Database function. Usually supports views, validation, or calculated predicates; look at referenced-by entries for callers.

Relations

  • No extracted relations.

Typed Edges

  • No typed edges extracted for this source.

References

  • No direct source references extracted.

Referenced By

  • No direct source references extracted.

Complete Source

SQL53 lines
1CREATE FUNCTION dbo.ADS_FGIGroupChangeValid(2  @UID_ADSGroup varchar(38)3) RETURNS BIT4AS5BEGIN6  DECLARE @erg BIT = 17  IF EXISTS(8    SELECT TOP 1 19    FROM ADSAccountInADSGroup aig10  LEFT11  OUTER12    JOIN ADS_VGroupMemberValid_Account v13      ON aig.UID_ADSGroup = v.UID_ADSGroupContainer AND aig.UID_ADSAccount = v.UID_ADSaccountMember14    WHERE15      aig.UID_ADSGroup = @UID_ADSGroup AND aig.XOrigin > 0 AND v.UID_ADSGroupContainer IS NULL) OR EXISTS(16  SELECT TOP 1 117  FROM ADSContactInADSGroup aig18  LEFT19  OUTER20  JOIN ADS_VGroupMemberValid_Contact v21    ON aig.UID_ADSGroup = v.UID_ADSGroupContainer AND aig.UID_ADSContact = v.UID_ADSContactMember22  WHERE23    aig.UID_ADSGroup = @UID_ADSGroup AND aig.XOrigin > 0 AND v.UID_ADSGroupContainer IS NULL) OR EXISTS(24  SELECT TOP 1 125  FROM ADSMachineInADSGroup aig26  LEFT27  OUTER28  JOIN ADS_VGroupMemberValid_Machine v29    ON aig.UID_ADSGroup = v.UID_ADSGroupContainer AND aig.UID_ADSMachine = v.UID_ADSMachineMember30  WHERE31    aig.UID_ADSGroup = @UID_ADSGroup AND aig.XOrigin > 0 AND v.UID_ADSGroupContainer IS NULL) OR EXISTS(32  SELECT TOP 1 133  FROM ADSGroupInADSGroup aig34  LEFT35  OUTER36  JOIN ADS_VGroupMemberValid_Group v37    ON aig.UID_ADSGroupParent = v.UID_ADSGroupContainer AND aig.UID_ADSGroupChild = v.UID_ADSGroupMember38  WHERE39    aig.UID_ADSGroupParent = @UID_ADSGroup AND v.UID_ADSGroupContainer IS NULL) OR EXISTS(40  SELECT TOP 1 141  FROM ADSGroupInADSGroup aig42  LEFT43  OUTER44  JOIN ADS_VGroupMemberValid_Group v45    ON aig.UID_ADSGroupParent = v.UID_ADSGroupContainer AND aig.UID_ADSGroupChild = v.UID_ADSGroupMember46  WHERE47    aig.UID_ADSGroupChild = @UID_ADSGroup AND v.UID_ADSGroupContainer IS NULL)48  BEGIN49    SELECT @erg = 050  END51  endLabel:52  RETURN(@erg)53END
Open raw exported source
SQL ยท Raw12 lines
1    create   function dbo.ADS_FGIGroupChangeValid (@UID_ADSGroup varchar(38) ) returns bit as begin declare @erg bit = 1  if exists (select top 21 1 from ADSAccountInADSGroup aig left outer join ADS_VGroupMemberValid_Account v on aig.UID_ADSGroup = v.UID_ADSGroupContainer and aig.UID_ADSAccount 3= v.UID_ADSaccountMember where aig.UID_ADSGroup = @UID_ADSGroup and aig.XOrigin > 0 and v.UID_ADSGroupContainer is null ) or exists (select top 1 1 from4 ADSContactInADSGroup aig left outer join ADS_VGroupMemberValid_Contact v on aig.UID_ADSGroup = v.UID_ADSGroupContainer and aig.UID_ADSContact = v.UID_ADSContactMember5 where aig.UID_ADSGroup = @UID_ADSGroup and aig.XOrigin > 0 and v.UID_ADSGroupContainer is null ) or exists (select top 1 1 from ADSMachineInADSGroup aig6 left outer join ADS_VGroupMemberValid_Machine v on aig.UID_ADSGroup = v.UID_ADSGroupContainer and aig.UID_ADSMachine = v.UID_ADSMachineMember where aig.UID_ADSGroup7 = @UID_ADSGroup and aig.XOrigin > 0 and v.UID_ADSGroupContainer is null ) or exists (select top 1 1 from ADSGroupInADSGroup aig left outer join ADS_VGroupMemberValid_Group8 v on aig.UID_ADSGroupParent = v.UID_ADSGroupContainer and aig.UID_ADSGroupChild = v.UID_ADSGroupMember where aig.UID_ADSGroupParent = @UID_ADSGroup and9 v.UID_ADSGroupContainer is null ) or exists (select top 1 1 from ADSGroupInADSGroup aig left outer join ADS_VGroupMemberValid_Group v on aig.UID_ADSGroupParent10 = v.UID_ADSGroupContainer and aig.UID_ADSGroupChild = v.UID_ADSGroupMember where aig.UID_ADSGroupChild = @UID_ADSGroup and v.UID_ADSGroupContainer is 11null ) begin select @erg = 0 end endLabel: return(@erg) end 12