Back to OIM Explorer

dbo.DPR_FGIShellMigrationLevel

Scalar FunctionSQL_SCALAR_FUNCTIONSandbox DB

Scalar Function.

Source: sandbox-db sys.sql_modules

Source size: 1.402 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_FCVStringToList source text reference
  • references source dbo.QBM_FCVStringToInt source text reference

References

Referenced By

  • No direct source references extracted.

Complete Source

SQL35 lines
1CREATE FUNCTION dbo.DPR_FGIShellMigrationLevel(2) RETURNS varchar(163)4AS5BEGIN6  DECLARE @erg varchar(16)7  SELECT TOP 1 @erg = CASE8  WHEN max(sign(abs(sh.vMajor - mo.vMajor))) = 1 THEN9  'Major'10  WHEN max(sign(abs(sh.vMinor - mo.vMinor))) = 1 THEN11  'Minor'12  WHEN max(sign(abs(sh.vSP - mo.vSP))) = 1 THEN13  'ServicePack'14  ELSE 'none'15  END16  FROM(17  SELECT18    DISTINCT dbo.QBM_FCVStringToInt(sv1.ParameterValue, 0) AS vMajor,19    dbo.QBM_FCVStringToInt(sv2.ParameterValue, 0) AS vMinor,20    dbo.QBM_FCVStringToInt(sv3.ParameterValue, 0) AS vSP21  FROM DPRSchema s CROSS apply dbo.QBM_FCVStringToList(s.SystemVersion, '.', 1, 0) sv1 CROSS apply dbo.QBM_FCVStringToList(s.SystemVersion,22  '.', 1, 0) sv2 CROSS apply dbo.QBM_FCVStringToList(s.SystemVersion, '.', 1, 0) sv323  WHERE24    s.SystemType = 'OneIM' AND sv1.OrderNumber = 1 AND sv2.OrderNumber = 2 AND sv3.OrderNumber = 3) AS sh CROSS25  JOIN(26  SELECT27    DISTINCT dbo.QBM_FCVStringToInt(mv1.ParameterValue, 0) AS vMajor,28    dbo.QBM_FCVStringToInt(mv2.ParameterValue, 0) AS vMinor,29    dbo.QBM_FCVStringToInt(mv3.ParameterValue, 0) AS vSP30  FROM QBMModuleDef m CROSS apply dbo.QBM_FCVStringToList(m.ModuleVersion, '.', 1, 0) mv1 CROSS apply dbo.QBM_FCVStringToList(m.ModuleVersion,31  '.', 1, 0) mv2 CROSS apply dbo.QBM_FCVStringToList(m.ModuleVersion, '.', 1, 0) mv332  WHERE33    mv1.OrderNumber = 1 AND mv2.OrderNumber = 2 AND mv3.OrderNumber = 3) AS mo endLabel:34  RETURN(@erg)35END
Open raw exported source
SQL ยท Raw10 lines
1   create   function dbo.DPR_FGIShellMigrationLevel () returns varchar(16) AS begin declare @erg varchar(16) select top 1 @erg = case when max(sign2(abs(sh.vMajor - mo.vMajor))) = 1 then 'Major' when max(sign(abs(sh.vMinor - mo.vMinor))) = 1 then 'Minor' when max(sign(abs(sh.vSP - mo.vSP))) = 1 then3 'ServicePack' else 'none' end from ( select distinct dbo.QBM_FCVStringToInt(sv1.ParameterValue, 0) as vMajor , dbo.QBM_FCVStringToInt(sv2.ParameterValue4, 0) as vMinor , dbo.QBM_FCVStringToInt(sv3.ParameterValue, 0) as vSP from DPRSchema s cross apply dbo.QBM_FCVStringToList(s.SystemVersion, '.', 1, 0) 5sv1 cross apply dbo.QBM_FCVStringToList(s.SystemVersion, '.', 1, 0) sv2 cross apply dbo.QBM_FCVStringToList(s.SystemVersion, '.', 1, 0) sv3 where s.SystemType6 = 'OneIM' and sv1.OrderNumber = 1 and sv2.OrderNumber = 2 and sv3.OrderNumber = 3 ) as sh cross join ( select distinct dbo.QBM_FCVStringToInt(mv1.ParameterValue7, 0) as vMajor , dbo.QBM_FCVStringToInt(mv2.ParameterValue, 0) as vMinor , dbo.QBM_FCVStringToInt(mv3.ParameterValue, 0) as vSP from QBMModuleDef m cross8 apply dbo.QBM_FCVStringToList(m.ModuleVersion, '.', 1, 0) mv1 cross apply dbo.QBM_FCVStringToList(m.ModuleVersion, '.', 1, 0) mv2 cross apply dbo.QBM_FCVStringToList9(m.ModuleVersion, '.', 1, 0) mv3 where mv1.OrderNumber = 1 and mv2.OrderNumber = 2 and mv3.OrderNumber = 3 ) as mo endLabel: return (@erg) end 10