Microsoft KB Archive/103748
BUG: SELECT with More than 125 SUM Columns Can GP Fault Server
The information in this article applies to:
- Microsoft SQL Server version 4.2x
NT: 446 (4.2)
A SELECT statement with more than 125 SUM columns of INT NULL will cause SQL Server to get a general protection fault (GP fault).
Example ------- select sum(c2), sum(c3), sum(c4), ... sum(c124), sum(c125), sum(c126) from t1 group by c1
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.
Microsoft has confirmed this to be a problem in Microsoft SQL Server version 4.2.
Additional query words: kernel
Keywords : kbprogramming
Issue type : kbbug
Technology : kbSQLServSearch kbAudDeveloper kbSQLServ420OS2
Last Reviewed: January 4, 2000