August 19, 2005 at 9:39 am
I have a column with a calculated controls. The column data type is decimal with scale 2, however once I put the calculated formula, the scale field is dimmed and i get a scale of 4.
The question is how to get the scale to 2 and the other thing is: Is there a technique by which you alter the default scale value for all decimal fields in the database to 2
August 19, 2005 at 9:47 am
decimal(4, 2) * decimal(4, 2) = decimal(8,4)
99.99 * 99.99 = 9998.0001
No you can't set the default scale on the server.
August 19, 2005 at 10:59 am
So, is there a way to get rid of the right two numbers to get 9998.00 ?
August 19, 2005 at 11:05 am
It's the application's job.
August 19, 2005 at 2:03 pm
Would this help?
select 15.25*16.29
--248.4225
select cast(15.25*16.29 as decimal(8,2))
--248.42
Michelle
August 20, 2005 at 12:13 am
This worked great, thanks
Viewing 6 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy