CODEWITHSUNDEEP
sqlsql-servert-sqlgrouping-sets
Val K
Val K

Reputation: 331

32 column limit for grouping sets

I am still working on sql 2005 to sql 2014 server migration.

With the older server, using COMPUTE BY, I was able to create a report that had 57 columns with some of those column being aggregate fields. There was no limit to the amount of columns I can use in one report(one query).

With the new sql 2014, I am using grouping sets to get the same results but I run into a limitation. I cannot put all my columns into one grouping set and then get the subtotals and the grand total:

Too many expressions are specified in the GROUP BY clause. The maximum number is 32 when grouping sets are supplied.

Is there a way I can supply more columns or is there a way around this limitation?

I have also attached the image to better understand what is going on..Query image

Upvotes: 1

Views: 1683

Answers (0)

Related Questions