declare @d decimal set @d='2.2875' select round(@d,0)
i need to round it to 2.29...
Nov 10 '10 at 12:00 AM
Nov 10 '10 at 01:20 AM
There's 2 issues here:
you haven't defined the decimal with any precision, so by default is defined as decimal(18,0). When you asign 2.2875 to it, it essentially rounds it, giving 2
the second parameter of the round function is the number of decimal places to round to.
so your code needs to be
declare @d decimal (8,2) --for example
Nov 10 '10 at 12:16 AM
Kev Riley ♦♦
Nov 10 '10 at 12:17 AM
Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.
There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.
Once you sign in you will be able to subscribe for any updates here
Answers and Comments
Need long-form SQL discussion? SQLserverCentral.com is the place.
asked: Nov 10 '10 at 12:00 AM
Seen: 546 times
Last Updated: Nov 10 '10 at 01:20 AM
How to chop-off the decimal digits without allowing the rounding?
Round a number to 2 decimal places
What is DML in T-SQL?
What is a page?
Anyone else see problems with SQL 2005 multiply operator?
Can I full-text search a temporary table?
Calculate running totals
Please can somebody explain how quirky updates work?
reference books needed for data availability and indexing
T-SQL Script to Delete All The Relationships Between A Bunch Of Tables in a Schema and Other Bunch in another Schema?