Подскажите, пжласта, в чем причина следующего:
запрос-
SELECT WHouses.WHouse, InWHouses.ProductID, InWHouses.Quantity, COALESCE (SUM(chkWHouseQty.Quantity), 0.00) AS Qty,
InWHouses.WHouseID
FROM WHouses INNER JOIN InWHouses LEFT OUTER JOIN chkWHouseQty
ON InWHouses.ProductID = chkWHouseQty.ProductID AND InWHouses.WHouseID = chkWHouseQty.WHouseID
ON WHouses.WHouseID = InWHouses.WHouseID INNER JOIN Products ON InWHouses.ProductID = Products.ProductID
WHERE (Products.TypeID >= 0)
GROUP BY WHouses.WHouse, InWHouses.ProductID, InWHouses.Quantity, InWHouses.WHouseID
HAVING (ABS(COALESCE (SUM(chkWHouseQty.Quantity), 0.00) - InWHouses.Quantity) > 0.00001)

выдает SqlDumpExceptionHandler: Process 9 generated fatal exception c0000093 EXCEPTION_FLT_UNDERFLOW. SQL Server is terminating this process.

При добавлении к запросу Option(loop join) запрос проходит.