Microsoft KB Archive/148267

From BetaArchive Wiki

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


Last Reviewed: March 25, 2000
© 2001 Microsoft Corporation. All rights reserved. Terms of Use.