Back to OIM Explorer

dbo.QER_FTPersonsAreMe

Inline Table FunctionSQL_INLINE_TABLE_VALUED_FUNCTIONSandbox DB

Inline Table Function.

Source: sandbox-db sys.sql_modules

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

Complete Source

SQL54 lines
1CREATE FUNCTION dbo.QER_FTPersonsAreMe(2  @UID_Person varchar(38)3) RETURNS TABLE4  WITH schemabinding5AS6RETURN(7SELECT8  @UID_Person AS UID_Person,9  p.UID_PersonMasterIdentity,10CASE11  WHEN p.UID_PersonMasterIdentity IS NULL THEN12113ELSE 014END AS IsMasterIdentity,15CASE16  WHEN p.UID_PersonMasterIdentity > ' ' THEN17118ELSE 019END AS IsSubIdentity20FROM dbo.Person p21WHERE22  p.UID_Person = @UID_Person23UNION24SELECT25  p.UID_PersonMasterIdentity,26  NULL,27  1,28  029FROM dbo.Person p30WHERE31  p.UID_Person = @UID_Person AND p.UID_PersonMasterIdentity > ' '32UNION33SELECT34  DISTINCT p.UID_Person,35  p.UID_PersonMasterIdentity,36CASE37  WHEN p.UID_PersonMasterIdentity IS NULL THEN38139ELSE 040END AS IsMasterIdentity,41CASE42  WHEN p.UID_PersonMasterIdentity > ' ' THEN43144ELSE 045END AS IsSubIdentity46FROM dbo.Person p47JOIN(48SELECT @UID_Person AS uid_person49UNION50SELECT p.UID_PersonMasterIdentity51FROM dbo.Person p52WHERE53  p.UID_Person = @UID_Person AND p.UID_PersonMasterIdentity > ' ') e54  ON p.UID_PersonMasterIdentity = e.UID_Person)
Open raw exported source
SQL ยท Raw8 lines
1create function dbo.QER_FTPersonsAreMe (@UID_Person varchar(38)) returns table       with schemabinding as return (  select @UID_Person as UID_Person ,2 p.UID_PersonMasterIdentity , case when p.UID_PersonMasterIdentity IS null then 1 else 0 end as IsMasterIdentity , case when p.UID_PersonMasterIdentity3 > ' ' then 1 else 0 end as IsSubIdentity from dbo.Person p where p.UID_Person = @UID_Person union select p.UID_PersonMasterIdentity, null, 1, 0 from dbo.Person4 p where p.UID_Person = @UID_Person and p.UID_PersonMasterIdentity > ' ' union  select distinct p.UID_Person, p.UID_PersonMasterIdentity, case when p.UID_PersonMasterIdentity5 IS null then 1 else 0 end as IsMasterIdentity , case when p.UID_PersonMasterIdentity > ' ' then 1 else 0 end as IsSubIdentity from dbo.Person p join( 6 select @UID_Person as uid_person            union select p.UID_PersonMasterIdentity  from dbo.Person p where p.UID_Person = @UID_Person and p.UID_PersonMasterIdentity7 > ' ' ) e on p.UID_PersonMasterIdentity = e.UID_Person ) 8