Microsoft KB Archive/148267

{|
 * width="100%"|

FIX: Correlated Subquery Nested 3+ Levels May Give Error 403

 * }

Q148267

-

The information in this article applies to:


 * Microsoft SQL Server version 6.0

-

BUG# NT: 13721 (6.00)

SYMPTOMS
A correlated subquery nested to three levels or more may give the following error message:

Msg 403, Level 16, State 1

Invalid operator for datatype op: UNKNOWN TOKEN type: char

WORKAROUND
Split the query so that the nesting level is less than three.

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 403 correlated subquery

Keywords : kbprogramming

Issue type : kbbug

Technology : kbSQLServSearch kbAudDeveloper kbSQLServ600