Knowledge Base

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

Article ID: 131908

Article Last Modified on 11/14/2003

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