Math.Round function in VS.NET and round function in SQL Server 2000
-
I have a decimal value 23.25 . When i use the math.round(23.25,1) in VS.NET, the result is 23.2 but with the function: round(23.25,1) in SQL Server 2000, the result is 23.3 :confused: How can i let them return the same value ? Thanks!
See reply in the other forum you posted to (SQL/ADO/ADO.NET). BTW posting the same question to multiple forms is considered to be rude, and will in some cases result in your question being ignored in all places. Absolute faith corrupts as absolutely as absolute power Eric Hoffer The opposite of the religious fanatic is not the fanatical atheist but the gentle cynic who cares not whether there is a god or not. Eric Hoffer
-
See reply in the other forum you posted to (SQL/ADO/ADO.NET). BTW posting the same question to multiple forms is considered to be rude, and will in some cases result in your question being ignored in all places. Absolute faith corrupts as absolutely as absolute power Eric Hoffer The opposite of the religious fanatic is not the fanatical atheist but the gentle cynic who cares not whether there is a god or not. Eric Hoffer
I'm really sorry, Graham! I didn't mean it. Because i don't know which forum the question is suit to ... Besides, i used to face a similar situation. I used to posted a question in C# general but no-one answer me because posting it in SQL is more exactly ... So ... I'm really sorry. I will never repeat it again. By the way, thanks your reply! :)