Microsoft KB Archive/167797

= BUG: AV Using Aggregate Functions in the Select List =

Article ID: 167797

Article Last Modified on 10/16/2003

-

APPLIES TO


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

-



This article was previously published under Q167797



BUG #: 16746 (6.5)



SYMPTOMS
You receive a handled access violation error (AV) when both of the following conditions are true:


 * There are two or more aggregate functions in the SELECT list of the query.

NOTE: The AV does not occur for a single aggregate function.
 * One aggregate function is used in the WHERE clause of the select query that uses the derived table.



WORKAROUND
To work around this problem, avoid constructing such queries involving a combination of two or more aggregate functions in the select list and an aggregate function in the derived table.



STATUS
Microsoft has confirmed this to be a problem in Microsoft SQL Server versions 6.0 and 6.5. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

Keywords: kbbug kbusage KB167797

-

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

© Microsoft Corporation. All rights reserved.