declare @d decimal
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: 819 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 to convert a decimal to the nearest quarter?
how to create execute package task
How to check table is empty or not if query is generated dynamically
How to write html code in sql server 2005?
find maximum value
stored procedure to take data from query
sqlserver dateadd function
Get column names appended to results