Registrations are now open. Join us today!
There is still a lot of work to do on the wiki yet! More information about editing can be found here.
Already have an account?

Microsoft KB Archive/103748

From BetaArchive Wiki

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).

   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
© 2001 Microsoft Corporation. All rights reserved. Terms of Use.