http://www.sqlservercentral.com/Content tagged T-SQL, Aggregates posted on SQLServerCentral.comen-us360sjones@sqlservercentral.com (Steve Jones)http://www.sqlservercentral.com/questions/T-SQL/63214/2008/06/27http://www.sqlservercentral.com/questions/T-SQL/63214/Every now and then you may attempt to calculate an aggregate function -- such as SUM() -- on a correlated subquery, only to encounter the following error:http://www.sqlservercentral.com/redirect/articles/61383/2007/10/29http://www.sqlservercentral.com/redirect/articles/61383/