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

Content with tags T-SQL, Aggregates Rss

   Items 1 to 20 of 26    Older >>
 

Bean Counting

By PhyData DBA 2014/05/12 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 1,903 reads

Using Max()

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

T-SQL counts

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

Aggregates in T-SQL

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

Aggregates

By Chirag Patel 2012/12/06 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 2,475 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,578 reads

SUM and Addition of Null

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

Basic of T-SQL

By Naseer Ahmad 2012/08/20 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 3,371 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,362 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,206 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,388 reads

Grouping Sets

By Dee Pavali 2011/08/30 | Category: aggregates
Rating: (not yet rated) |  Discuss |   Briefcase | 2,396 reads

How well do you know MAX?

By VM-723206 2011/08/05 | Category: max()
Rating: (not yet rated) |  Discuss |   Briefcase | 3,169 reads

AVG function

By krishnaroopa senthil 2011/06/21 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 3,620 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,627 reads

Using OVER with an Aggregate Function

By Nakul Vachhrajani 2010/11/04 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 3,126 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,578 reads

COUNT_BIG

By Prakriti Agrawal 2010/03/09 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 4,284 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,319 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,658 reads
   Items 1 to 20 of 26    Older >>
 
Tags
count (2)    
max() (2)    
null (2)    
administration (1)    
automated dba (1)    
date manipulation (1)    
groouping (1)    
growth trend (1)    
maintenance (1)    
maintenance and management (1)    
median (1)    
ranking functions (1)    
report (1)    
running aggregate (1)    
running totals (1)    
space usage (1)    
sql server 2005 (1)    
storage (1)    
to us (1)    
utility (1)    
video (1)