I have a customer with the following problem.
There is a table named tblMaterials. In one of the columns of the table there are currency numbers stored.
When the customer uses a T-SQL statement, the results shows numbers like: 12.000 and 1.000. In other words it shows the numbers with a period. Now when the customers calls the records with the management studio(opening the table) it shows the same numbers using a comma. In this case 12,000 and 1,000.
How is this possible? Is it perhaps a setting in the Management Studio?
The version of SQL is 2005 (more detail: 9.00.4053.00