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.
Once you sign in you will be able to subscribe for any updates here
Answers and Comments
asked: Nov 10 '10 at 12:00 AM
Seen: 370 times
Last Updated: Nov 10 '10 at 01:20 AM
Round a number to 2 decimal places
find ranges in groups which are identified by a flag
Pivot sql in 2k5
How to compare datetime
To write an sql query
Conditional Join - Does a CASE in the ON part of a join still allow indexes & optimal performance etc?
How to restrict the stored procedure calling twice on submit ?
Obtaining the Number of working days in a month
Build history table based on two tables
Copyright © 2002-2012 Simple Talk Publishing. All Rights Reserved. If you have any queries, please contact the site administrators.Ask SQL Server Central is a community service provided by Red Gate.