Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
floker
Starting Member
6 Posts |
 Posted - 2010-01-04 : 05:41:45
|
| Hi all,We recently moved from one sql server to another. Both are sql 2000 servers. I have a query that I have to use almost every day to make some statistics. Within the query I have something like sum(.......). On the old server the result gave me 2 digits after the decimal point. Now it gives me a lot of digits. Is there any setting in the sql server to change this or how does it come? Query has not changed, only the server. |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2010-01-04 : 06:03:37
|
The only thing that come to my mind is if you are using money as column datatype in the aggregation and your windows operating system locale is different from before.
N 56°04'39.26"E 12°55'05.63" |
 |
|
|
floker
Starting Member
6 Posts |
Posted - 2010-01-04 : 06:26:41
|
| Hi Peso, thank you for your help. I've found the problem.I'm using SQL Query Analyzer to run my queries. It seems to be that the option to use the regional settings was not selected (Tools/Options/Connections..."Use regional settings...")Not it's all displaying fine! |
|
|
|
|
|
|
Digits after decimal point