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

<< Newer    Items 21 to 26 of 26   
 

SUM of FLOAT inconsistency

By brewmanz 2008/10/13 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 4,574 reads

Accessing and changing data 2008

By bitbucket-25253 2008/09/23 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 3,720 reads

Summarizing Data with Aggregate Queries - SQL School Video

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.  Read more...
By Kathi Kellenberger 2008/08/28 | Source: SQLServerCentral.com | Category: video
Rating: |  Discuss |   Briefcase | 4,793 reads

Calculating Mathematical Values in SQL Server

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?  Read more...
By Additional Articles 2008/08/07 | Source: MSSQLTips.com | Category: t-sql
Rating:  Rate this |   Briefcase | 4,891 reads

Windowed Aggregate functions

By Matt Miller (#4) 2008/06/27 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 4,999 reads

Aggregating Correlated Sub-Queries

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:  Read more...
By Additional Articles 2007/10/29 | Source: SQLTeam.com | Category: t-sql
Rating: (not yet rated)  Rate this |   Briefcase | 4,288 reads
<< Newer    Items 21 to 26 of 26   
 
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)