Back to OIM Explorer

dbo.TSB_FTMembershipWithoutPerson

Table FunctionSQL_TABLE_VALUED_FUNCTIONSandbox DB

Table Function.

Source: sandbox-db sys.sql_modules

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

SQL44 lines
1CREATE FUNCTION dbo.TSB_FTMembershipWithoutPerson(2  @objectkeybase varchar(138)3) RETURNS @erg TABLE(UID_UNSAccount varchar(38) collate database_default,4UID_UNSGroup varchar(38) collate database_default,5XObjectKey varchar(138) collate database_default primary key(UID_UNSAccount,6UID_UNSGroup)7)8AS9BEGIN10  IF isnull(@objectkeybase,11  '') = ''12  BEGIN13    INSERT INTO @erg(UID_UNSAccount,14    UID_UNSGroup,15    XObjectKey)16    SELECT17      uig.UID_UNSAccount,18      uig.UID_UNSGroup,19      uig.XObjectKey20    FROM UNSAccountInUNSGroup uig21    JOIN UNSAccount a22      ON uig.UID_UNSAccount = a.UID_UNSAccount23    WHERE24      a.UID_Person IS NULL25  END26  ELSE27  BEGIN28    INSERT INTO @erg(UID_UNSAccount,29    UID_UNSGroup,30    XObjectKey)31    SELECT32      uig.UID_UNSAccount,33      uig.UID_UNSGroup,34      uig.XObjectKey35    FROM UNSAccountInUNSGroup uig36    JOIN UNSAccount a37      ON uig.UID_UNSAccount = a.UID_UNSAccount38    JOIN TSBVDomainAndContainer v39      ON v.UID_Container = a.UID_UNSContainer40    WHERE41      a.UID_Person IS NULL AND v.ObjectkeyDomain = @ObjectKeyBase42  END43  RETURN44END
Open raw exported source
SQL ยท Raw8 lines
1create function dbo.TSB_FTMembershipWithoutPerson (@objectkeybase varchar(138) ) returns @erg table (UID_UNSAccount varchar(38) collate database_default2 , UID_UNSGroup varchar(38) collate database_default , XObjectKey varchar(138) collate database_default primary key (UID_UNSAccount, UID_UNSGroup) ) as3 begin if isnull(@objectkeybase, '') = '' begin insert into @erg(UID_UNSAccount, UID_UNSGroup, XObjectKey) select uig.UID_UNSAccount, uig.UID_UNSGroup,4 uig.XObjectKey from UNSAccountInUNSGroup uig join UNSAccount a on uig.UID_UNSAccount = a.UID_UNSAccount where a.UID_Person is null end else begin insert5 into @erg(UID_UNSAccount, UID_UNSGroup, XObjectKey) select uig.UID_UNSAccount, uig.UID_UNSGroup, uig.XObjectKey from UNSAccountInUNSGroup uig join UNSAccount6 a on uig.UID_UNSAccount = a.UID_UNSAccount join TSBVDomainAndContainer v on v.UID_Container = a.UID_UNSContainer where a.UID_Person is null and v.ObjectkeyDomain7 = @ObjectKeyBase end return end 8