Microsoft KB Archive/149174

{|
 * width="100%"|

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