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

Content with tags T-SQL, CEILING() Rss

   Items 1 to 3 of 3   

Saving For Christmas

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


By Steve Jones 2016/10/03 | Category: ceiling()
Rating: (not yet rated) |  Discuss |   Briefcase | 1,227 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,619 reads
   Items 1 to 3 of 3   
floor() (2)    
round() (2)