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

Articles with tag ROUND() Rss

Search for any content tagged round()

   Items 1 to 3 of 3   

SQL for 8-year-old Math…But Be Careful of Implicit Type Conversion

How we can use SQL to solve a math problem published in The Guardian...but with a caution about implicit type conversion.  Read more...
By David Rueter 2015/07/14 | Source: | Category: math
Rating: |  Discuss |   Briefcase | 7,136 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: | Category: t-sql
Rating: (not yet rated)  Rate this |   Briefcase | 3,496 reads

Custom Rounding and Truncation of Numbers in MDX

MDX applies "bankers' rounding" algorithm in its ROUND() function. This article shows you how to avoid that and round like in T-SQL and Excel.  Read more...
By Boyan Penev 2009/10/06 | Source: | Category: mdx
Rating: |  Discuss |   Briefcase | 3,338 reads
   Items 1 to 3 of 3