Back to OIM Explorer

dbo.QER_FGITimeZoneForPerson

Scalar FunctionSQL_SCALAR_FUNCTIONSandbox DB

Scalar Function.

Source: sandbox-db sys.sql_modules

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

SQL65 lines
1CREATE FUNCTION dbo.QER_FGITimeZoneForPerson(2  @UID_Person varchar(38)3) RETURNS varchar(384)5  WITH schemabinding6AS7BEGIN8  RETURN(9  SELECT10    TOP 1 isnull(z1.UID_DialogTimeZone, isnull(z3.UID_DialogTimeZone, isnull(z2.UID_DialogTimeZone,11    isnull(z4.UID_DialogTimeZone, isnull(z5.UID_DialogTimeZone, 'QBM-FA50BC3A1B8FC82E9DCFCCF81AA0D275'))))) AS UID_DialogTimeZone12  FROM dbo.Person p13  JOIN dbo.DialogDatabase db14    ON db.IsMainDatabase = 115  LEFT16  OUTER17  JOIN dbo.DialogState s118    ON p.UID_DialogState = s1.UID_DialogState19  LEFT20  OUTER21  JOIN dbo.DialogStateHasTimeZone z122    ON s1.UID_DialogState = z1.UID_DialogState23  LEFT24  OUTER25  JOIN dbo.DialogCountry c126    ON c1.UID_DialogCountry = CASE27  WHEN s1.UID_DialogCountry IS NULL THEN28  p.UID_DialogCountry29  ELSE s1.UID_DialogCountry30  END31  LEFT32  OUTER33  JOIN dbo.DialogCountryHasTimeZone z234    ON c1.UID_DialogCountry = z2.UID_DialogCountry35  LEFT36  OUTER37  JOIN dbo.BaseTree l38    ON p.UID_Locality = l.UID_Org39  LEFT40  OUTER41  JOIN dbo.DialogState s242    ON l.UID_DialogState = s2.UID_DialogState43  LEFT44  OUTER45  JOIN dbo.DialogStateHasTimeZone z346    ON s2.UID_DialogState = z3.UID_DialogState47  LEFT48  OUTER49  JOIN dbo.DialogCountry c250    ON c2.UID_DialogCountry = CASE51  WHEN s2.UID_DialogCountry IS NULL THEN52  l.UID_DialogCountry53  ELSE s2.UID_DialogCountry54  END55  LEFT56  OUTER57  JOIN dbo.DialogCountryHasTimeZone z458    ON c2.UID_DialogCountry = z4.UID_DialogCountry59  LEFT60  OUTER61  JOIN dbo.DialogCountryHasTimeZone z562    ON db.UID_DialogCountryDefault = z5.UID_DialogCountry63  WHERE64    p.UID_Person = @UID_Person)65END
Open raw exported source
SQL ยท Raw11 lines
1   create   function dbo.QER_FGITimeZoneForPerson ( @UID_Person varchar(38) ) returns varchar(38) with schemabinding as begin return (   select 2top 1 isnull(z1.UID_DialogTimeZone , isnull (z3.UID_DialogTimeZone , isnull(z2.UID_DialogTimeZone , isnull(z4.UID_DialogTimeZone, isnull(z5.UID_DialogTimeZone3 , 'QBM-FA50BC3A1B8FC82E9DCFCCF81AA0D275'  ) ) ) ) ) as UID_DialogTimeZone             from dbo.Person p join dbo.DialogDatabase db on db.IsMainDatabase4 = 1 left outer join dbo.DialogState s1 on p.UID_DialogState = s1.UID_DialogState left outer join dbo.DialogStateHasTimeZone z1 on s1.UID_DialogState =5 z1.UID_DialogState left outer join dbo.DialogCountry c1 on c1.UID_DialogCountry = case when s1.UID_DialogCountry is null then p.UID_DialogCountry else6 s1.UID_DialogCountry end left outer join dbo.DialogCountryHasTimeZone z2 on c1.UID_DialogCountry = z2.UID_DialogCountry left outer join dbo.BaseTree l7 on p.UID_Locality = l.UID_Org left outer join dbo.DialogState s2 on l.UID_DialogState = s2.UID_DialogState left outer join dbo.DialogStateHasTimeZone 8z3 on s2.UID_DialogState = z3.UID_DialogState left outer join dbo.DialogCountry c2 on c2.UID_DialogCountry = case when s2.UID_DialogCountry is null then9 l.UID_DialogCountry else s2.UID_DialogCountry end left outer join dbo.DialogCountryHasTimeZone z4 on c2.UID_DialogCountry = z4.UID_DialogCountry left 10outer join dbo.DialogCountryHasTimeZone z5 on db.UID_DialogCountryDefault = z5.UID_DialogCountry where p.UID_Person = @UID_Person   ) end 11