declare @d decimal set @d='2.2875' select round(@d,0)
i need to round it to 2.29...
Nov 10, 2010 at 12:00 AM
Nov 10, 2010 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, 2010 at 12:16 AM
Kev Riley ♦♦
Nov 10, 2010 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
Need long-form SQL discussion? SQLserverCentral.com is the place.
asked: Nov 10, 2010 at 12:00 AM
Seen: 715 times
Last Updated: Nov 10, 2010 at 01:20 AM
How to chop-off the decimal digits without allowing the rounding?
Round a number to 2 decimal places
How do I call a static member of a CLR type?
The ‘FIFO Stock Inventory’ SQL Problem
Displaying fields from a result set on the same line
Entity RelationShip Diagram
Identity column Problem
Convert DateTime to Numeric
Seeder question: order by error?
Running scripts in ssms