Scenario:
I have a Sql Server instance on English Windows Server.
But I also have my own ITALIAN client with Sql Server Management Studio and SSMS regional settings set to Italian.
So when I extract data, i need separator as follow :
, (comma) for decimal
. (point) for thousands
Example: 1.065,00
Instead , Sql Server Management Studio return me number like:
1065.0000
(point for decimal separator)
If I copy & paste into Excel all data are mess..
Example: point , but i need comma!
How can I do without writing specific query with "Format" or similar?
Thanks