Microsoft KB Archive/131908

= BUG: Many UNIONs in One Query May Cause a 702 Error =

Article ID: 131908

Article Last Modified on 11/14/2003

-

APPLIES TO


 * Microsoft SQL Server 4.21a Standard Edition
 * Microsoft SQL Server 6.0 Standard Edition
 * Microsoft SQL Server 6.5 Standard Edition

-



This article was previously published under Q131908



BUG#: 9828 (SQLBUG_60) 16990 (SQLBUG_65)



SYMPTOMS
A query that UNIONs together many SELECT statements may fail with a 702 error.



RESOLUTION
Rephrase the query so it does not use as many UNIONS, possibly by selecting into a temp table in separate queries.



STATUS
Microsoft has confirmed this to be a problem in the products listed at the beginning of this article.



MORE INFORMATION
In the replication a SELECT from authors in pubs was UNIONed 42 times.

Additional query words: sql6 dblib cursor Windows NT

Keywords: kbbug kbprogramming KB131908

-

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

© Microsoft Corporation. All rights reserved.