Very Computer

Hi.  I am writing regarding an error message I have come across with SQL
Server 6.5.  The error is the following:

error number 227, severity 16  Maximum number of vector aggregates exceeded
(125 max, 126 found).

Is there a way to get around this?  I have not found ANY documentation on
this particular error and I cannot find any server setting that can be
changed regarding this.  I have 3 clients who have all experienced this now
and are getting upset.

What I am doing is trying to summarize data in a table.  This table has 2
text fields on it (the key) and up to 240 FLOAT fields.  I am writing the
query as:

INSERT INTO TABLEX (KEY1,KEY2,DATA1,DATA2,...,DATAN)
SELECT KEY1,KEY2,SUM(DATA1) DATA1, SUM(DATA2) DATA2,... SUM(DATAN) DATAN
FROM TABLE2
GROUP BY KEY1,KEY2.

This query works fine until I have 125 or more data columns.

Any ideas would be greatly appreciated.
Thanks!

Rob,

 I very much doubt this limit is user changeable.  You'll have to usetemp
table(s) and split the query up.

 Neil Pike MVP/MCSE.  Protech Computing Ltd
 (Please post ALL replies to the newsgroup only unless indicated otherwise)
 For SQL FAQ entries see www.ntfaq.com/sql.html
 and http://www.swynk.com/faq/sql/sqlserverfaq.asp
 and GO MSSQL Lib 1 on Compuserve