SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tags T-SQL, ROUND() Rss

   Items 1 to 10 of 10   
 

Saving For Christmas

By Steve Jones 2017/08/22 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 1,092 reads

Rounding Parameters

By Steve Jones 2016/10/05 | Category: round()
Rating: (not yet rated) |  Discuss |   Briefcase | 1,158 reads

Round averages

By Steve Jones 2016/09/29 | Category: aggregate function
Rating: (not yet rated) |  Discuss |   Briefcase | 1,339 reads

Small rounding

By Steve Jones 2016/09/09 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 1,366 reads

Rounding Rules

By Steve Jones 2016/08/23 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 1,376 reads

Round

By Pawel 2015/09/14 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 1,877 reads

Precision required

By David Bridge 2013/03/14 | Category: round()
Rating: (not yet rated) |  Discuss |   Briefcase | 1,883 reads

SQL Server Rounding Functions - Round, Ceiling and Floor

I saw your recent tip on Calculating Mathematical Values in SQL Server and have some related issues as I try to round values in my application. My users and me have a difference of opinion on some of the calculations in our reporting applications. All of the code is in T-SQL, but I think the reporting issues are related to data types and rounding down or rounding up rules. Do you have any insight into these issues? I would like to see some examples with a variety of coding options.  Read more...
By Additional Articles 2013/01/09 | Source: MSSQLTips.com | Category: t-sql
Rating: (not yet rated)  Rate this |   Briefcase | 3,566 reads

Five percent rounded down

By Mike Tanner 2012/10/24 | Category: cast
Rating: (not yet rated) |  Discuss |   Briefcase | 2,226 reads

Are all rounds created equal

By Timothy Bates 2010/10/13 | Category: round()
Rating: (not yet rated) |  Discuss |   Briefcase | 3,026 reads
   Items 1 to 10 of 10   
 
Tags
ceiling() (2)    
floor() (2)    
access (1)    
aggregate function (1)    
cast (1)    
date manipulation (1)    
sum() (1)    
truncation (1)