Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Content with tags T-SQL, round Rss

   Items 1 to 2 of 2   

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: | Category: t-sql
Rating: (not yet rated)  Rate this |   Briefcase | 3,469 reads

Are all rounds created equal

By Timothy Bates 2010/10/13 | Category: round
Rating: (not yet rated) |  Discuss |   Briefcase | 3,009 reads
   Items 1 to 2 of 2   
access (1)    
ceiling (1)    
floor (1)