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

Content with tags T-SQL, FLOOR() 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,124 reads

The Floor

By Steve Jones 2017/07/31 | Category: floor()
Rating: (not yet rated) |  Discuss |   Briefcase | 1,071 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,573 reads
   Items 1 to 3 of 3   
 
Tags
ceiling() (2)    
round() (2)