dbo.DPR_FGIShellMigrationLevel

1   create   function dbo.DPR_FGIShellMigrationLevel () returns varchar(16) AS begin declare @erg varchar(16) select top 1 @erg = case when max(sign
2(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 then
3 'ServicePack' else 'none' end from ( select distinct dbo.QBM_FCVStringToInt(sv1.ParameterValue, 0) as vMajor , dbo.QBM_FCVStringToInt(sv2.ParameterValue
4, 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.SystemType
6 = 'OneIM' and sv1.OrderNumber = 1 and sv2.OrderNumber = 2 and sv3.OrderNumber = 3 ) as sh cross join ( select distinct dbo.QBM_FCVStringToInt(mv1.ParameterValue
7, 0) as vMajor , dbo.QBM_FCVStringToInt(mv2.ParameterValue, 0) as vMinor , dbo.QBM_FCVStringToInt(mv3.ParameterValue, 0) as vSP from QBMModuleDef m cross
8 apply dbo.QBM_FCVStringToList(m.ModuleVersion, '.', 1, 0) mv1 cross apply dbo.QBM_FCVStringToList(m.ModuleVersion, '.', 1, 0) mv2 cross apply dbo.QBM_FCVStringToList
9(m.ModuleVersion, '.', 1, 0) mv3 where mv1.OrderNumber = 1 and mv2.OrderNumber = 2 and mv3.OrderNumber = 3 ) as mo endLabel: return (@erg) end 
10