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!