Microsoft KB Archive/152811

= BUG: Multiple Result Set Reported When GROUP BY Clause Is Used =

Article ID: 152811

Article Last Modified on 10/17/2003

-

APPLIES TO


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

-



This article was previously published under Q152811



BUG# 15009



SYMPTOMS
If you use a GROUP BY clause with the bit field (this has to be converted to another datatype, such as int, char, and so forth) will cause more than one row to be returned in the result set when only one should be expected.

This problem occurs GROUP BY clause processing during query processing time especially when there are repeated records in the table.



WORKAROUND
Rewriting the query with the DISTINCT keyword will report the correct result set.



STATUS
Microsoft has confirmed this to be a problem in SQL Server 6.0 and 6.5.

Keywords: kbbug kbprogramming kbpending KB152811

-

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

© Microsoft Corporation. All rights reserved.