I have a serious problem. Have anybody seen this problem with converting
float to numeric?
Msg 8114, Level 16, State 2
Error converting type float to type numeric.
If I run this query:
result is 123.0 It should be 123.45
And if I run this:
result is 123.45 (should be 123.0)
SQL-server seems to "change" my dots to commas in some way. This problem
suddenly started two days ago. I have used SP4 in last 6 months and never
seen it before.