melegant99
asked on
How to adjust scale of computed column in SQL
Hi,
I have a decimal 18,2 and another 8,2 which i have a computed column for the total
(qty * cost).
The scale of the computed column is 4. I want it to be 2. Or is it not an issue becuase the other two columns are scale of 2 and 2? Issue is half pennies...creating display issues for users...
Thanks.
I have a decimal 18,2 and another 8,2 which i have a computed column for the total
(qty * cost).
The scale of the computed column is 4. I want it to be 2. Or is it not an issue becuase the other two columns are scale of 2 and 2? Issue is half pennies...creating display issues for users...
Thanks.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.