SQLServerCentral.com Articles tagged Aggregates

Generating SubTotals using GROUPING

Fri, 16 Nov 2012 07:00:00 UT

This article explains how to use the GROUPING clause to generate subtotals for rows in a very easy fashion.

Aggregate Function Product()

Mon, 06 Feb 2012 07:00:00 UT

The TSQL aggregate function SUM() gives a number based on the addition of the values of multiple rows to each other. Do the same thing but with multiplication instead of addition.

Cumulative Aggregates in SQL Server Reporting Services

Fri, 27 Jan 2012 07:00:00 UT

In this tip, we will see how to build a report which shows the cumulative sales amount for the current month, current quarter (QTD) and current year (YTD) in a single crosstab (tablix) report, which makes it easy to compare the data.

Get your SQL Server database under version control now!
Version control is standard for applications, but databases haven’t caught up. So how can you bring database development up to speed? Why should you start? Find out…

How to get monthly YTD data

Tue, 24 Jan 2012 07:00:00 UT

This article presents an easy method to get YTD data grouped by months in T-SQL.

Script to calculate the Median value for SQL Server data

Tue, 08 Nov 2011 07:00:00 UT

The standard SQL language has a number of aggregate functions like: SUM, MIN, MAX, AVG, but a common statistics function that SQL Server does not have is a built-in aggregate function for median. The median is the value that falls in the middle of a sorted resultset with equal parts that are smaller and equal parts that are greater. Since there is no built-in implementation for the median, the following is a simple solution I put together to find the median.

A genuine use for a SQL CLR Aggregate

Wed, 29 Dec 2010 07:00:00 UT

When should you use a SQL CLR Aggregate? Lots of people have struggled with this one, but David Poole found a use, and has some interesting performance data analysis as well.

Generating SubTotals using GROUPING

Fri, 16 Nov 2012 07:00:00 UT

This article explains how to use the GROUPING clause to generate subtotals for rows in a very easy fashion.

How to automate your .NET and SQL Server deployments
Deploy .NET code and SQL Server databases in a single repeatable process with Red Gate Deployment Manager. Start deploying with a 28-day trial.

Pivoting, Unpivoting and Aggregating

Wed, 18 Nov 2009 07:00:00 UT

We asked Phil Factor to write a nice simple quick-start guide about aggregation, pivoting and un-pivoting techniques. To do so, he takes us all the way from getting the data from a published source, transferring it to SQL Server, un-pivoting it, storing it in a relational table, aggregating it and finally pivoting the data in a variety of ways.

Median Workbench

Wed, 06 May 2009 06:00:00 UT

SQL Server database engine doesn't have a MEDIAN() aggregate function. This is probably because there are several types of median, such as statistical, financial or vector medians. Calculating Medians are essentially a row-positioning task, since medians are the middle value of an ordered result. Easy to do in SQL? Nope. Joe Celko explains why.

Summarizing Data with Aggregate Queries - SQL School Video

Thu, 28 Aug 2008 06:00:00 UT

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.

Calculating Mathematical Values in SQL Server

Thu, 07 Aug 2008 06:00:00 UT

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?

Aggregating Correlated Sub-Queries

Mon, 29 Oct 2007 06:00:00 UT

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: