Back to OIM Explorer

dbo.ADS_FTGroupCollection

Table FunctionSQL_TABLE_VALUED_FUNCTIONSandbox DB

Table Function.

Source: sandbox-db sys.sql_modules

Source size: 902 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

SQL39 lines
1CREATE FUNCTION dbo.ADS_FTGroupCollection(2  @ObjectKeyAccountOrGroup varchar(138)3) RETURNS @erg TABLE(UID_ADSGroup varchar(38) collate database_default4)5  WITH schemabinding6AS7BEGIN8  DECLARE @lauf int9  INSERT INTO @erg(UID_ADSGroup)10  SELECT uid_ADSGroup11  FROM dbo.ADSGroup12  WHERE13    XObjectKey = @ObjectKeyAccountOrGroup14  INSERT INTO @erg(UID_ADSGroup)15  SELECT aig.uid_ADSGroup16  FROM dbo.ADSAccount a17  JOIN dbo.ADSAccountInADSGroup aig18    ON a.uid_ADSAccount = aig.uid_ADSAccount AND aig.XOrigin > 0 AND aig.XIsInEffect = 119  WHERE20    a.XObjectKey = @ObjectKeyAccountOrGroup21  SELECT @lauf = 122  WHILE @lauf > 023  BEGIN24    INSERT INTO @erg(UID_ADSGroup)25    SELECT26      DISTINCT gig.uid_ADSGroupParent27    FROM @erg e28    JOIN dbo.ADSGroupInADSGroup gig29      ON e.uid_ADSGroup = gig.uid_ADSGroupChild30    WHERE31      NOT EXISTS(32    SELECT TOP 1 133    FROM @erg b34    WHERE35      b.uid_ADSGroup = gig.uid_ADSGroupParent)36    SELECT @lauf = @@rowcount37  END38  RETURN39END
Open raw exported source
SQL ยท Raw7 lines
1create function dbo.ADS_FTGroupCollection (@ObjectKeyAccountOrGroup varchar(138) ) returns @erg table (UID_ADSGroup varchar(38) collate database_default2 ) with schemabinding as begin  declare @lauf int  insert into @erg (UID_ADSGroup) select uid_ADSGroup from dbo.ADSGroup where XObjectKey = @ObjectKeyAccountOrGroup3 insert into @erg (UID_ADSGroup) select aig.uid_ADSGroup from dbo.ADSAccount a join dbo.ADSAccountInADSGroup aig on a.uid_ADSAccount = aig.uid_ADSAccount4 and aig.XOrigin > 0 and aig.XIsInEffect = 1 where a.XObjectKey = @ObjectKeyAccountOrGroup select @lauf = 1 while @lauf > 0 begin insert into @erg(UID_ADSGroup5) select distinct gig.uid_ADSGroupParent from @erg e join dbo.ADSGroupInADSGroup gig on e.uid_ADSGroup = gig.uid_ADSGroupChild where Not exists (select6 top 1 1 from @erg b where b.uid_ADSGroup = gig.uid_ADSGroupParent ) select @lauf = @@rowcount end  return end 7