Problem with Decimal Places and Rounding off [Resolved]

Posted by Vuyiswamb under Sql Server on 8/10/2014 | Points: 10 | Views : 1192 | Status : [Member] [MVP] [Administrator] | Replies : 1
Good Day All

i have a Following Query

1) Query 1

DECLARE @FINALVAUE VARCHAR(MAX) =   (Convert(decimal,@CAUSATIVE_FACTORS_ID) - 1) +   Convert(decimal,@LU_PERCENTAGE_FAILURE_IN_SAMPLE_ID) + Convert(decimal,@LU_REPORTING_HISTORY_ID)  
PRINT @FINALVAUE -- the answer is 3


The Calculation is like this

2) Query 2

DECLARE @FINAL VARCHAR(MAX) 
SET @FINAL= (4-1) + 0.08 + 0.2
SELECT @FINAL -- the asnwer is 3.28



The first Query i am retrieving values from the Variables which are varchar and converting to decimal and doing the calculations. and the second Query i am just taking the value as is. i used this to debug in trying to solve this problem. My problem here in the first Query in the @FINALVAUE variable the answer is "3" and in the second Query the answer is "3.28"
, i want the first Query to display the same value which is "3.28"

Thanks

Thank you for posting at Dotnetfunda
[Administrator]



Responses

Posted by: Vuyiswamb on: 8/10/2014 [Member] [MVP] [Administrator] NotApplicable | Points: 25

Up
0
Down

Resolved
I resolved the Problem by using decimal(10,2)in all the conversions

Thanks

Thank you for posting at Dotnetfunda
[Administrator]

Vuyiswamb, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response