In this blog post, you’ll learn more about the Sybase Error PIVOT error: Too many aggregate functions and IN clause items and the reason for receiving this error
Sybase SQL Error Message
PIVOT error: Too many aggregate functions and IN clause items
Reason for this Error
You specified a PIVOT, but the number of items in the IN clause times the number of aggregate functions exceeds the number of expressions allowed in the SELECT list of the result set.