Back to OIM Explorer

dbo.ATT_FTObjectKeysForAttCaseDec

Inline Table FunctionSQL_INLINE_TABLE_VALUED_FUNCTIONSandbox DB

Inline Table Function.

Source: sandbox-db sys.sql_modules

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

SQL17 lines
1CREATE FUNCTION dbo.ATT_FTObjectKeysForAttCaseDec(2  @UID_Person varchar(38)3) RETURNS TABLE4AS5RETURN(6SELECT7  y.UID_AttestationCase,8  y.ObjectKeyRelated9FROM(10SELECT11  ac.UID_AttestationCase, ac.ObjectKey1, ac.ObjectKeyBase, ac.ObjectKey2, ac.ObjectKey312FROM AttestationCase ac13JOIN ATT_VAttDecisionPerson_DO v14  ON ac.UID_AttestationCase = v.UID_AttestationCase15WHERE16  v.RulerLevel <> 2 AND v.uid_personhead = @UID_Person) AS x unpivot(ObjectKeyRelated FOR spalte IN(ObjectKey1,17ObjectKeyBase, ObjectKey2, ObjectKey3)) AS y)
Open raw exported source
SQL ยท Raw5 lines
1create function dbo.ATT_FTObjectKeysForAttCaseDec  (@UID_Person varchar(38) ) returns table as return ( select y.UID_AttestationCase, y.ObjectKeyRelated2 from ( select ac.UID_AttestationCase, ac.ObjectKey1, ac.ObjectKeyBase , ac.ObjectKey2 , ac.ObjectKey3 from AttestationCase ac join ATT_VAttDecisionPerson_DO3  v on ac.UID_AttestationCase = v.UID_AttestationCase where v.RulerLevel <> 2 and v.uid_personhead = @UID_Person ) as x unpivot (ObjectKeyRelated for spalte4 in (ObjectKey1,ObjectKeyBase , ObjectKey2, ObjectKey3)) as y ) 5