double meanObject; double Upper = 1.8415; meanObject = Math.Round((Convert.ToDouble(Upper)), 3); ==> Result meanObject = 1.842 <==
Declare @Upper float = 1.8415 select Round(@Upper,3) ==> Result is = 1.841 <==
I want Same Answer in both Ex. C# Code = 1.842 SQL SP = 1.842 (I get the wrong result in SQL SP : 1.841)
double meanObject; double Upper = 1.8415; meanObject = Math.Round((Convert.ToDouble(Upper)), 3); Label1.Text = meanObject.ToString(); //Result 1.842
Declare @Upper float = 1.8415 select Round(@Upper,3)
Declare @Upper money = 1.8415 select Round(@Upper,3) Prob Solved using changing datatype to money ==> SQL Result is = 1.842 <==
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)