Q149174 - FIX: Correlated Subquery on Datetime Col May Cause Client AV

FIX: Correlated Subquery on Datetime Col May Cause Client AV

Q149174

The information in this article applies to:

Microsoft SQL Server version 6.0

BUG#: 14267 (6.00)

SYMPTOMS

The client thread may access violate if it has the datetime column in correlation, and multiple conditions in the WHERE clause of the correlated subquery and the main outer query.

WORKAROUND

Split the query into multiple queries by using intermediate temporary tables.

STATUS

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

Additional query words: sql6 av

Keywords : kbprogramming
Issue type : kbbug
Technology : kbSQLServSearch kbAudDeveloper kbSQLServ600