Back to OIM Explorer

dbo.ARS_FTITShopRulerPA

Table FunctionSQL_TABLE_VALUED_FUNCTIONSandbox DB

Table Function.

Source: sandbox-db sys.sql_modules

Source size: 741 characters

Interpretation

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

Relations

  • No extracted relations.

Typed Edges

  • references source dbo.ARS_FTPersonFromEdsva source text reference

References

Referenced By

  • No direct source references extracted.

Complete Source

SQL28 lines
1CREATE FUNCTION dbo.ARS_FTITShopRulerPA(2  @uid_personwantsorg varchar(38)3) RETURNS @erg TABLE(UID_Person varchar(38) collate database_default,4UID_PWORulerOrigin varchar(38) collate database_default5)6AS7BEGIN8  DECLARE @Ownerlist nvarchar(max) = NULL9  SELECT TOP 1 @Ownerlist = g.edsvaSecondaryOwners10  FROM PersonWantsOrg pwo11  JOIN BaseTreeHasADSGroup ohg12    ON pwo.UID_ITShopOrgFinal = ohg.UID_Org AND ohg.XOrigin > 0 AND ohg.XIsInEffect = 113  JOIN ADSGroup g14    ON ohg.uid_ADSGroup = g.uid_ADSGroup15  WHERE16    pwo.UID_PersonWantsOrg = @uid_personwantsorg17  IF @Ownerlist IS NULL18  BEGIN19    GOTO endLabel20  END21  INSERT INTO @erg(UID_Person,22  UID_PWORulerOrigin)23  SELECT24    l.UID_Person,25    NULL26  FROM dbo.ARS_FTPersonFromEdsva(@Ownerlist) l endLabel:27  RETURN28END
Open raw exported source
SQL ยท Raw6 lines
1create function dbo.ARS_FTITShopRulerPA (@uid_personwantsorg varchar(38) ) returns @erg table ( UID_Person varchar(38) collate database_default , UID_PWORulerOrigin2 varchar(38) collate database_default ) AS begin declare @Ownerlist nvarchar(max) = null  select top 1 @Ownerlist = g.edsvaSecondaryOwners from PersonWantsOrg3 pwo join BaseTreeHasADSGroup ohg on pwo.UID_ITShopOrgFinal = ohg.UID_Org and ohg.XOrigin > 0 and ohg.XIsInEffect = 1 join ADSGroup g on ohg.uid_ADSGroup4 = g.uid_ADSGroup where pwo.UID_PersonWantsOrg = @uid_personwantsorg if @Ownerlist is null begin goto endLabel end insert into @erg(UID_Person, UID_PWORulerOrigin5) select l.UID_Person, null from dbo.ARS_FTPersonFromEdsva(@Ownerlist) l endLabel: return end 6