Microsoft KB Archive/155710

= FIX: Select Statement Can Cause Arithmetic Overflow =

Article ID: 155710

Article Last Modified on 3/14/2005

-

APPLIES TO


 * Microsoft SQL Server 6.0 Standard Edition
 * Microsoft SQL Server 6.5 Standard Edition

-



This article was previously published under Q155710



BUG #: 15785 (6.50) 15607 (6.00)



SYMPTOMS
In general, when you use the Select statement and a query that involves the multiplication of a decimal number and the value returned from a function, an Arithmetic Overflow error message appears. This error message also appears in the following three specific conditions:

 Calculation must involve at least three operands Calculation must include the following three operations:

 an integer constant multiplied by an integer returned from a function multiplied by a decimal or numeric value in the form of either a constant, local variable or a column value.  Calculation be performed in the order in which they are listed in Condition 2 above.</li></ol>

<div class="workaround_section">

WORKAROUND
To work around this problem, convert the decimal or numeric values to integer values using the Convert function. For more information on how to use the Convert function, please see the Transact-SQL Reference guide.

<div class="status_section">

STATUS
Microsoft has confirmed this to be a problem in Microsoft SQL Server versions 6.0 and 6.5. This problem has been corrected in U.S. Service Pack 4 for Microsoft SQL Server version 6.5. For more information, contact your primary support provider.

Keywords: kbbug kbfix kbnetwork KB155710

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.