http://www.sqlservercentral.com/Articles tagged T-SQL, Aggregates posted on SQLServerCentral.comen-us360sjones@sqlservercentral.com (Steve Jones)Learn how to summarize the values of your data using aggregate functions such as COUNT(), SUM(), and AVG() from MVP Kathi Kellenberger. Grouping and aggregate filters are covered as well.http://www.sqlservercentral.com/articles/Video/63815/2008/08/28http://www.sqlservercentral.com/articles/Video/63815/In our application we have the need to perform mathematical calculations. Right now we are doing so in our front end application. Unfortunately we are starting to experience performance problems with large data sets and differences in calculations due to developers using different logic. We are seeking some other options to perform the calculations. Does SQL Server perform basic mathematical calculations?http://www.sqlservercentral.com/redirect/articles/63898/2008/08/07http://www.sqlservercentral.com/redirect/articles/63898/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/