Back to OIM Explorer

dbo.QBM_FGIHolidayInAdminUnit

Scalar FunctionSQL_SCALAR_FUNCTIONSandbox DB

Scalar Function.

Source: sandbox-db sys.sql_modules

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

Complete Source

SQL53 lines
1CREATE FUNCTION dbo.QBM_FGIHolidayInAdminUnit(2  @Isodate nvarchar(10),3  @ObjectkeyAdminUnit varchar(138)4) RETURNS BIT5AS6BEGIN7  DECLARE @Erg BIT8  SELECT @erg = 09  DECLARE @ObjectKeyCountry varchar(138)10  DECLARE @AdminUnitIsState BIT11  SELECT @AdminUnitIsState = 012  IF @ObjectkeyAdminUnit LIKE '<Key><T>DialogState</T>%'13  BEGIN14    SELECT @AdminUnitIsState = 115  END16  IF @AdminUnitIsState = 117  BEGIN18    IF EXISTS(19      SELECT TOP 1 120      FROM dbo.DialogState s21      JOIN dbo.DialogStateHoliday h22        ON s.uid_dialogState = h.uid_dialogState23      WHERE24        s.XObjectKey = @ObjectkeyAdminUnit AND h.isodate = @Isodate AND h.IsToIgnore = 0)25    BEGIN26      SELECT @erg = 127      RETURN(@erg)28    END29    SELECT TOP 1 @ObjectKeyCountry = c.XObjectKey30    FROM dbo.DialogState s31    JOIN dbo.DialogCountry c32      ON s.uid_DialogCountry = c.uid_dialogCountry33    WHERE34      s.XObjectKey = @ObjectkeyAdminUnit35  END36  ELSE37  BEGIN38    SELECT @ObjectKeyCountry = @ObjectkeyAdminUnit39  END40  IF EXISTS(41    SELECT TOP 1 142    FROM dbo.DialogCountry c43    JOIN dbo.DialogCountryHoliday h44      ON c.uid_dialogCountry = h.uid_dialogCountry45    WHERE46      c.XObjectKey = @ObjectKeyCountry AND h.isodate = @Isodate AND h.IsToIgnore = 0)47  BEGIN48    SELECT @erg = 149    RETURN(@erg)50  END51  ende:52  RETURN(@erg)53END
Open raw exported source
SQL ยท Raw9 lines
1  create   function dbo.QBM_FGIHolidayInAdminUnit(@Isodate nvarchar(10) , @ObjectkeyAdminUnit varchar(138) ) returns bit   as begin declare @Erg2 bit select @erg = 0 declare @ObjectKeyCountry varchar(138) declare @AdminUnitIsState bit select @AdminUnitIsState = 0 if @ObjectkeyAdminUnit like '<Key><T>DialogState</T>%'3 begin  select @AdminUnitIsState = 1 end if @AdminUnitIsState = 1 begin if exists (select top 1 1 from dbo.DialogState s join dbo.DialogStateHoliday h 4on s.uid_dialogState = h.uid_dialogState where s.XObjectKey = @ObjectkeyAdminUnit and h.isodate = @Isodate  and h.IsToIgnore = 0 ) begin select @erg = 51  return(@erg)  end  select top 1 @ObjectKeyCountry = c.XObjectKey from dbo.DialogState s join dbo.DialogCountry c on s.uid_DialogCountry = c.uid_dialogCountry6 where s.XObjectKey = @ObjectkeyAdminUnit end else begin select @ObjectKeyCountry = @ObjectkeyAdminUnit end if exists (select top 1 1 from dbo.DialogCountry7 c join dbo.DialogCountryHoliday h on c.uid_dialogCountry = h.uid_dialogCountry where c.XObjectKey = @ObjectKeyCountry and h.isodate = @Isodate  and h.IsToIgnore8 = 0 ) begin select @erg = 1  return(@erg)  end ende: return (@erg) end 9