Microsoft KB Archive/112692

FIX: SELECT with More Than 125 SUM Columns Can Trap Server

PSS ID Number: Q112692 Article last modified on 10-31-1994

4.20

WINDOWS

BUG# NT: 446 (4.2)

= SYMPTOMS =

A SELECT statement with more than 125 SUM columns of INT NULL will cause the SQL Server client process to get an Access Violation.

= WORKAROUND =

To avoid this problem, you can split the table into multiple tables and do a join, or you can do an inner join on the single table.

= STATUS =

Microsoft has confirmed this to be a problem in Microsoft SQL Server version 4.2. This problem was corrected in SQL Server version 4.2P33. For more information, contact your primary support provider.

Additional reference words: 4.20 kernel Windows NT KBCategory: kbprg KBSubcategory: SSrvWinNT

=
================================================================

Copyright Microsoft Corporation 1994.