Microsoft KB Archive/154035

= BUG: Select From a View Involving Outer Joins May Cause AV =

Article ID: 154035

Article Last Modified on 10/3/2003

-

APPLIES TO


 * Microsoft SQL Server 6.5 Standard Edition

-



This article was previously published under Q154035





SYMPTOMS
When you Select from a view that involves simple outer joins using ANSI syntax and a distinct clause, an "Exception Divide By Zero" error message appears.



WORKAROUND
To work around this problem, do not use a distinct clause in the Select statement.



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

Additional query words: stack trace access violation sql

Keywords: kbnetwork KB154035

-

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

© Microsoft Corporation. All rights reserved.