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

ID: Q154035

The information in this article applies to:

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 SSrvGen 
Version           : 6.5
Platform          : WINDOWS 
Issue type        :

Last Reviewed: March 31, 1999