Microsoft KB Archive/158807

= FIX: Derived Table Generation May Cause Error 206 =

Article ID: 158807

Article Last Modified on 10/3/2003

-

APPLIES TO


 * Microsoft SQL Server 6.5 Standard Edition

-



This article was previously published under Q158807



BUG #: 15800 (6.50)



SYMPTOMS
If a query used to create a derived table selects a user-defined datatype, selecting from the derived table may cause the following error message:

206 16 Operand type clash: %s is incompatible with %s

The following example shows a query that may cause this problem. In the example, au_id from the authors table is a user-defined datatype.

use pubs go  select * from (select a.au_id from authors a   inner join titleauthor ta on a.au_id = ta.au_id   and a.au_fname = "Albert") as a   go



WORKAROUND
To work around this problem, do not use derived tables to select data from columns with user-defined data types.



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

Keywords: kbbug kbfix kbusage KB158807

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.