Select Top 1000000 (Case
    When TflopsWindows.TFlops Is Null Then 0
    Else TflopsWindows.TFlops
  End) As TflopsWindows,
  (Case
    When TflopsLinux.TFlops Is Null Then 0
    Else TflopsLinux.TFlops
  End) As TflopsLinux,
  (Case
    When TflopsMac.TFlops Is Null Then 0
    Else TflopsMac.TFlops
  End) As TflopsMac,
  ((Case
    When TflopsWindows.TFlops Is Null Then 0
    Else TflopsWindows.TFlops
  End) + (Case
    When TflopsLinux.TFlops Is Null Then 0
    Else TflopsLinux.TFlops
  End) + (Case
    When TflopsMac.TFlops Is Null Then 0
    Else TflopsMac.TFlops
  End)) As TflopsTotal
From (Select Sum((Cast(tblProcessor.MaxClockSpeed / 1000 As decimal(18,2)) *
        tblProcessor.NumberOfCores * 16) / 1000) As TFlops
      From tblAssets
        Inner Join tblProcessor On tblAssets.AssetID = tblProcessor.AssetID
        Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
      Where tblAssetCustom.Model Not Like '%virtual%') As TflopsWindows,
  (Select Sum((Cast(SubString(tblLinuxProcessors.MaxSpeed, 0, 5) /
        1000 As decimal(18,2)) * 4 * 16) / 1000) As TFlops
      From tblAssets
        Inner Join tblLinuxProcessors On tblAssets.AssetID =
          tblLinuxProcessors.AssetID
        Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
      Where tblAssetCustom.Model Not Like '%virtual%') As TflopsLinux,
  (Select Sum(((Cast(SubString(Replace(tblMacHwOverview.CPUSpeed, ',',
        ''), 0, 4) As decimal(18,2)) / 10) * tblMacHwOverview.NrOfCPUs * 16) /
        1000) As TFlops
      From tblAssets
        Inner Join tblMacHwOverview On
          tblAssets.AssetID = tblMacHwOverview.AssetID
        Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
      Where tblAssetCustom.Model Not Like '%virtual%') As TflopsMac

Select Top 1000000 (Case
    When TflopsWindows.TFlops Is Null Then 0
    Else TflopsWindows.TFlops
  End) As TflopsWindows,
  (Case
    When TflopsLinux.TFlops Is Null Then 0
    Else TflopsLinux.TFlops
  End) As TflopsLinux,
  (Case
    When TflopsMac.TFlops Is Null Then 0
    Else TflopsMac.TFlops
  End) As TflopsMac,
  (Case
    When TflopsESXi.TFlopsVM Is Null Then 0
    Else TflopsESXi.TFlopsVM
  End) As TflopsESXi,
  ((Case
    When TflopsWindows.TFlops Is Null Then 0
    Else TflopsWindows.TFlops
  End) + (Case
    When TflopsLinux.TFlops Is Null Then 0
    Else TflopsLinux.TFlops
  End) + (Case
    When TflopsMac.TFlops Is Null Then 0
    Else TflopsMac.TFlops
  End) + (Case
    When TflopsESXi.TFlopsVM Is Null Then 0
    Else TflopsESXi.TFlopsVM
  End)) As TflopsTotal
From (Select Sum((Cast(tblProcessor.MaxClockSpeed / 1000 As decimal(18,2)) *
        tblProcessor.NumberOfCores * 16) / 1000) As TFlops
      From tblAssets
        Inner Join tblProcessor On tblAssets.AssetID = tblProcessor.AssetID
        Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
      Where tblAssetCustom.Model Not Like '%virtual%') As TflopsWindows,
  (Select Sum((Cast(SubString(tblLinuxProcessors.MaxSpeed, 0, 5) /
        1000 As decimal(18,2)) * 4 * 16) / 1000) As TFlops
      From tblAssets
        Inner Join tblLinuxProcessors On tblAssets.AssetID =
          tblLinuxProcessors.AssetID
        Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
      Where tblAssetCustom.Model Not Like '%virtual%') As TflopsLinux,
  (Select Sum(((Cast(SubString(Replace(tblMacHwOverview.CPUSpeed, ',',
        ''), 0, 4) As decimal(18,2)) / 10) * tblMacHwOverview.NrOfCPUs * 16) /
        1000) As TFlops
      From tblAssets
        Inner Join tblMacHwOverview On
          tblAssets.AssetID = tblMacHwOverview.AssetID
        Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
      Where tblAssetCustom.Model Not Like '%virtual%') As TflopsMac,
  (Select Sum((Cast(tblVmwareInfo.CpuMhz / 1000 As decimal(18,2)) *
        tblVmwareInfo.numCpuCores * 16) / 1000) As TFlopsVM
      From tblAssets
        Inner Join tblVmwareInfo On tblAssets.AssetID = tblVmwareInfo.AssetID)
  As TflopsESXi