Back to OIM Explorer

dbo.TSB_FTAccountsForPerson

Inline Table FunctionSQL_INLINE_TABLE_VALUED_FUNCTIONSandbox DB

Inline Table Function.

Source: sandbox-db sys.sql_modules

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

SQL35 lines
1CREATE FUNCTION dbo.TSB_FTAccountsForPerson(2  @UID_Person varchar(38)3) RETURNS TABLE4AS5RETURN(6SELECT7  a.UID_Person AS UID_PersonOfAccount,8  a.XObjectKey AS ObjectKeyAccount9FROM(10SELECT me.UID_PersonAlsoMe AS UID_Person11FROM Person p12JOIN QER_VPersonsAreMe me13  ON me.UID_PersonOrigin = p.UID_Person14WHERE15  p.UID_Person = @UID_Person AND p.IsDummyPerson = 016UNION all17SELECT p.UID_Person18FROM Person p19WHERE20  p.IsDummyPerson = 1 AND p.UID_PersonHead = @UID_Person21UNION all22SELECT @UID_Person) AS pe23JOIN UNSAccount a24  ON pe.UID_Person = a.UID_Person25UNION26SELECT27  a.UID_Person,28  a.XObjectKey29FROM Person p30JOIN UNSAccount a31  ON p.UID_Person = a.UID_Person32JOIN TSBPersonUsesAccount pua33  ON a.XObjectKey = pua.ObjectKeyAccount34WHERE35  p.IsDummyPerson = 1 AND pua.UID_Person = @UID_Person)
Open raw exported source
SQL ยท Raw7 lines
1create function dbo.TSB_FTAccountsForPerson( @UID_Person varchar(38) ) returns table as return (   select a.UID_Person as UID_PersonOfAccount , a.XObjectKey2 as ObjectKeyAccount from ( select me.UID_PersonAlsoMe as UID_Person from Person p join QER_VPersonsAreMe me on me.UID_PersonOrigin = p.UID_Person  where3 p.UID_Person = @UID_Person and p.IsDummyPerson = 0 union all select p.UID_Person from Person p  where p.IsDummyPerson = 1 and p.UID_PersonHead = @UID_Person4 union all select @UID_Person ) as pe join UNSAccount a on pe.UID_Person = a.UID_Person union  select a.UID_Person, a.XObjectKey from Person p join UNSAccount5 a on p.UID_Person = a.UID_Person join TSBPersonUsesAccount pua on a.XObjectKey = pua.ObjectKeyAccount where p.IsDummyPerson = 1 and pua.UID_Person = @UID_Person6 ) 7