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
 

----------------------------------------------------------------------
The information in this article applies to:
 
  - Microsoft SQL Server version 4.2
----------------------------------------------------------------------
 
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.
 
   Example
   -------
   select sum(c2), sum(c3), sum(c4), ... sum(c124), sum(c125), sum(c126)
   from t1
   group by c1
 
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.
