Back to OIM Explorer

dbo.QER_FTPersonsAreMe_S

Inline Table FunctionSQL_INLINE_TABLE_VALUED_FUNCTIONSandbox DB

Inline Table Function.

Source: sandbox-db sys.sql_modules

Source size: 486 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.QER_FTPersonsAreMe source text reference

References

Referenced By

  • No direct source references extracted.

Complete Source

SQL23 lines
1CREATE FUNCTION dbo.QER_FTPersonsAreMe_S(2  @UID_Person varchar(38)3) RETURNS TABLE4  WITH schemabinding5AS6RETURN(7  WITH m AS(8SELECT @UID_Person AS UID_Person9UNION all10SELECT p.UID_PersonMasterIdentity11FROM dbo.Person p12WHERE13  p.UID_Person = @UID_Person AND p.UID_PersonMasterIdentity > ' ')14SELECT x.UID_Person15FROM(16SELECT uid_person17FROM m18UNION all19SELECT p.UID_Person20FROM dbo.Person p21JOIN m22  ON p.UID_PersonMasterIdentity = m.UID_Person) AS x23GROUP BY x.UID_Person)
Open raw exported source
SQL ยท Raw5 lines
1create function dbo.QER_FTPersonsAreMe_S (@UID_Person varchar(38)) returns table with schemabinding as return ( with m as (  select @UID_Person as UID_Person2  union all select p.UID_PersonMasterIdentity from dbo.Person p where p.UID_Person = @UID_Person and p.UID_PersonMasterIdentity > ' ' ) select x.UID_Person3 from (  select uid_person from m  union all select p.UID_Person from dbo.Person p join m on p.UID_PersonMasterIdentity = m.UID_Person ) as x group by 4x.UID_Person ) 5