Home Forums SQL Server 2008 SQL Server Newbies Decimal separator missed when pasting into excel from sql query RE: Decimal separator missed when pasting into excel from sql query

  • fbernausberraondo (1/8/2013)


    Thank you very much to you all for your answers. At least I don't feel like a complete newbie as I can see there is not a straightforward solution to this problem.

    I think the same way as GSquared - that this seems to be a problem inside SSMS and since my database is running on windows 2008 server running in English (both the OS server and the SQL Server) I wonder if the results would be the same should the database and OS be in Spanish... maybe I will try this but those being in English is a requirement from our ERP vendor.

    Yeah, I don't think Microsoft anticipated this particular problem. Might try running SSMS in a VM that's set to Spanish. That might work.

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon