try this:SELECT TOP 1000000 assType.AssetTypeIcon10 As icon,ass.AssetName As Asset,ass.Domain,assType.AssetTypename As AssetType,ass.IPAddress,assCust.Manufacturer,assCust.Model,assCust.Serialnumber,ass.Firstseen,ass.Lastseen,ass.Lasttried,COALESCE(a...