Select Top (1000000) SQ.icon,
  SQ.AssetID,
  SQ.AssetName,
  SQ.OS,
  SQ.Build,
  SQ.[OS Version],
  SQ.Domain,
  SQ.Username,
  SQ.Userdomain,
  SQ.IPAddress,
  SQ.Description,
  SQ.Manufacturer,
  SQ.Model,
  SQ.Location,
  SQ.IPLocation,
  SQ.Firstseen As [Created at],
  SQ.Lastseen As [Last successful scan]
From (Select tsysOS.Image As icon,
      tblAssets.AssetID,
      tblAssets.AssetName,
      tsysOS.OSname As OS,
      tblAssets.OScode + '.' + tblAssets.BuildNumber As Build,
      tblAssets.Version As [OS Version],
      tblAssets.Domain,
      tblAssets.Username,
      tblAssets.Userdomain,
      tblAssets.IPAddress,
      tblAssets.Description,
      tblAssetCustom.Manufacturer,
      tblAssetCustom.Model,
      tblAssetCustom.Location,
      tsysIPLocations.IPLocation,
      tblAssets.Firstseen,
      tblAssets.Lastseen,
      (Select Case
            When IsNumeric(Replace(Replace(Replace(tblAssets.OScode, '.', ''),
              'S', ''), 'R', '') + '.0') = 1 Then
              Cast(Replace(Replace(Replace(tblAssets.OScode, '.', ''), 'S', ''),
              'R', '') As BIGINT)
            Else 0
          End As Expr1) As OsCodeNumeric,
      Cast(tblAssets.BuildNumber As INT) As BuildNumber
    From tblAssets
      Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
      Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode
      Left Outer Join tsysIPLocations On tblAssets.LocationID =
          tsysIPLocations.LocationID
    Where tsysOS.OSname = 'Win 2016' And tblAssetCustom.State = 1 And
      tblAssets.BuildNumber Is Not Null) As SQ
  Cross Join (Select Max(os1.OSCodeNumeric) As MaxOsCodeNumeric
    From tsysOS As os1
    Where os1.Sortorder = 19) As mo
  Cross Join (Select Max(Cast(a.BuildNumber As INT)) As MaxBuildNumber
    From tblAssets As a
      Inner Join tsysOS As o On o.OScode = a.OScode
    Where o.OSname = 'Win 2016' And a.BuildNumber Is Not Null And (Select Case
            When IsNumeric(Replace(Replace(Replace(a.OScode, '.', ''), 'S', ''),
              'R', '') + '.0') = 1 Then Cast(Replace(Replace(Replace(a.OScode,
              '.', ''), 'S', ''), 'R', '') As BIGINT)
            Else 0
          End As Expr1) = (Select Max(os2.OSCodeNumeric) As Expr1
        From tsysOS As os2 Where os2.Sortorder = 19)) As mb
Where (SQ.OsCodeNumeric < mo.MaxOsCodeNumeric) Or
  (SQ.BuildNumber < mb.MaxBuildNumber)
Order By SQ.AssetName