Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag Aggregates Rss

   Items 1 to 20 of 40    Older >>
 

Counting Rows

By Shiva N 2015/08/31 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 1,342 reads

Not Again!

By Steve Knox 2015/02/18 | Category: aggregates
Rating: (not yet rated) |  Discuss |   Briefcase | 2,364 reads

Getting Distinct

By Steve Jones 2015/01/23 | Category: count()
Rating: (not yet rated) |  Discuss |   Briefcase | 2,497 reads

Distinct Counts

By Steve Jones 2015/01/22 | Category: count()
Rating: (not yet rated) |  Discuss |   Briefcase | 2,295 reads

COUNT NULLs

By Steve Jones 2015/01/21 | Category: count()
Rating: (not yet rated) |  Discuss |   Briefcase | 2,446 reads

Counting values

By Steve Jones 2015/01/14 | Category: count()
Rating: (not yet rated) |  Discuss |   Briefcase | 2,428 reads

Bean Counting

By PhyData DBA 2014/05/12 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 2,045 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 2014/02/05 (first published: 2010/12/29) | Source: SQLServerCentral.com | Category: sqlclr
Rating: |  Discuss |   Briefcase | 14,588 reads

Using Max()

By Rob Stebbens 2013/11/08 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 3,098 reads

T-SQL counts

By Samith C 2013/10/02 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 2,794 reads

Script to get max dates on tables that contain a certain column.

This script will allow you to get maximum date associated with tables that contain a certain column.   Read more...
By Kishore T 2013/03/18 | Source: SQLServerCentral.com | Category: aggregates
Rating: |  Discuss |   Briefcase | 1,103 reads

Aggregates in T-SQL

By P. Praveena 2012/12/21 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 2,311 reads

Aggregates

By Chirag Patel 2012/12/06 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 2,547 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 2012/11/16 (first published: 2010/07/13) | Source: SQLServerCentral.com | Category: groouping
Rating: |  Discuss |   Briefcase | 26,648 reads

SUM and Addition of Null

By iBar 2012/11/05 | Category: aggregates
Rating: (not yet rated) |  Discuss |   Briefcase | 1,736 reads

Basic of T-SQL

By Naseer Ahmad 2012/08/20 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 3,447 reads

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 | 8,397 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 | 2,378 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 | 11,284 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,489 reads
   Items 1 to 20 of 40    Older >>
 
Tags
t-sql (31)    
count() (5)    
count (2)    
max() (2)    
null (2)    
sqlclr (2)    
administration (1)    
automated dba (1)    
date manipulation (1)    
delimited (1)    
groouping (1)    
growth trend (1)    
maintenance (1)    
maintenance and management (1)    
max (1)    
median (1)    
pivot (1)    
ranking functions (1)    
report (1)    
rows count (1)    
running aggregate (1)    
running totals (1)    
security (1)    
space usage (1)    
sql server 2005 (1)    
storage (1)    
string (1)    
summary (1)    
to us (1)    
utility (1)    
video (1)