Back to OIM Explorer

dbo.QER_FCVTimeToWorkTimePerson

Scalar FunctionSQL_SCALAR_FUNCTIONSandbox DB

Scalar Function.

Source: sandbox-db sys.sql_modules

Source size: 323 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.QBM_FCVDatetimeToNextWork source text reference
  • references source dbo.QER_FGIAdminUnitForPerson source text reference

Complete Source

SQL14 lines
1CREATE FUNCTION dbo.QER_FCVTimeToWorkTimePerson(2  @BaseTimeUTC datetime,3  @CountMinutes int,4  @UID_Person varchar(38)5) RETURNS datetime6AS7BEGIN8  DECLARE @Erg datetime9  SELECT10    @erg = dbo.QBM_FCVDatetimeToNextWork(@BaseTimeUTC,11    @CountMinutes,12    dbo.QER_FGIAdminUnitForPerson(@uid_person)) ende:13  RETURN(@erg)14END
Open raw exported source
SQL ยท Raw4 lines
1   create   function dbo.QER_FCVTimeToWorkTimePerson (@BaseTimeUTC datetime , @CountMinutes int , @UID_Person varchar(38) ) returns datetime as 2begin declare @Erg datetime select @erg = dbo.QBM_FCVDatetimeToNextWork(@BaseTimeUTC , @CountMinutes , dbo.QER_FGIAdminUnitForPerson (@uid_person) ) ende:3 return (@erg) end 4