SQLServerCentral: Content tagged Aggregates

Aggregate Function Product()

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. Read more...

By Paul McPherson 2012/02/06 | Source: SQLServerCentral.com | Category: t-sql

Rating:

|

Discuss |

Briefcase | 7,254 reads

Cumulative Aggregates in SQL Server Reporting Services

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. Read more...

By Additional Articles 2012/01/27 | Source: MSSQLTips.com | Category: aggregates

Rating:

Rate this |

Briefcase | 1,601 reads

How to get monthly YTD data

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

By Kautuk 2012/01/24 | Source: SQLServerCentral.com | Category: t-sql

Rating:

|

Discuss |

Briefcase | 10,118 reads

Script to calculate the Median value for SQL Server data

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. Read more...

By Additional Articles 2011/11/08 | Source: MSSQLTips.com | Category: aggregates

Rating:

Rate this |

Briefcase | 2,003 reads

Grouping Sets

By Dee Pavali 2011/08/30 | Category: aggregates

Rating: (not yet rated) |

Discuss |

Briefcase | 2,043 reads

Total Data Rows Data

This script will return the total amount of data rows in a database Read more...

By BinaryDigit 2011/08/19 | Source: SQLServerCentral.com | Category: summary

Rating:

|

Discuss |

Briefcase | 753 reads

How well do you know MAX?

By VM-723206 2011/08/05 | Category: max()

Rating: (not yet rated) |

Discuss |

Briefcase | 2,760 reads

AVG function

By krishnaroopa senthil 2011/06/21 | Category: t-sql

Rating: (not yet rated) |

Discuss |

Briefcase | 3,266 reads

CLR Aggregate to Concatenate delimited strings

One must be carefull unless the input is sorted by the value passed to the function and there is no paralelism there is no guarantee that the resulting value will be sorted. Read more...

By Gokhan Varol 2011/01/27 | Source: SQLServerCentral.com | Category: string

Rating: (not yet rated) |

Discuss |

Briefcase | 674 reads

SQL Function to get Max, Min values from given collection of values

This func returns the max value,min value and count of values from collection of values Read more...

By Bharat Panthee 2011/01/20 | Source: SQLServerCentral.com | Category: aggregates

Rating:

|

Discuss |

Briefcase | 1,381 reads

Function to generate sql statement returning max value

SQL script generator for max value Read more...

By SoftJunk 2011/01/18 | Source: SQLServerCentral.com | Category: max

Rating:

|

Discuss |

Briefcase | 1,276 reads

A genuine use for a SQL CLR Aggregate

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. Read more...

By David Poole 2010/12/29 | Source: SQLServerCentral.com | Category: sqlclr

Rating:

|

Discuss |

Briefcase | 7,970 reads

Using OVER with an Aggregate Function

By Nakul Vachhrajani 2010/11/04 | Category: t-sql

Rating: (not yet rated) |

Discuss |

Briefcase | 2,817 reads

Generating SubTotals using GROUPING

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

By Sunil Chandurkar 2010/07/13 | Source: SQLServerCentral.com | Category: groouping

Rating:

|

Discuss |

Briefcase | 15,272 reads

COUNT_BIG

By Prakriti Agrawal 2010/03/09 | Category: t-sql

Rating: (not yet rated) |

Discuss |

Briefcase | 4,032 reads

Pivoting, Unpivoting and Aggregating

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. Read more...

By Additional Articles 2009/11/18 | Source: SimpleTalk | Category: aggregates

Rating:

Rate this |

Briefcase | 3,847 reads

Three Sample reports for the Automated DBA: Space Usage SnapShotter

1100 largest indexes by total buffer cache usage; 100 largest tables by total reserved pages; Largest tables in each database with running total of space usage and growth since last snapshot Read more...

By Jesse Roberge 2009/07/13 | Source: SQLServerCentral.com | Category: administration

Rating:

|

Discuss |

Briefcase | 2,053 reads

Median Workbench

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. Read more...

By Additional Articles 2009/05/06 | Source: SimpleTalk | Category: t-sql

Rating: (not yet rated) Rate this |

Briefcase | 1,443 reads