SQLServerCentral / Discuss Content Posted by Steve Jones / Article Discussions / Article Discussions by Author / You are a database administer for a multi-national... / Latest PostsInstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 22 May 2013 14:08:41 GMT20RE: You are a database administer for a multi-national...http://www.sqlservercentral.com/Forums/Topic490202-32-1.aspx[quote][b]L' Eomot Inversé (2/17/2013)[/b][hr]SET Language doesn't solve the problem. Currencies are probably different too, and that is going to have to be deal with. Of the options offered, a staging table will definitely work whereas setting language might work if you are lucky and date format is the only issue.[/quote]I agree. For the given problem, even just setting the date format would work. Even though the two languages are very similar, there are going to be other things to consider. This is why I don't go for certification... since I would actually consider the best answer to load a staging table and massage the data, I had to make a choice between what I thought the author of the question was looking for and what the actual correct answer is.Sun, 17 Feb 2013 09:40:37 GMTJeff ModenRE: You are a database administer for a multi-national...http://www.sqlservercentral.com/Forums/Topic490202-32-1.aspx[quote][b]Ric Sierra (4/24/2008)[/b][hr]The best way could be send the date in ANSI format: yyyy-mm-dd[/quote]I agree except it should be YYYYMMDD. The dashes aren't actually part of ISO or ANSI.Sun, 17 Feb 2013 09:37:19 GMTJeff ModenRE: You are a database administer for a multi-national...http://www.sqlservercentral.com/Forums/Topic490202-32-1.aspxSET Language doesn't solve the problem. Currencies are probably different too, and that is going to have to be deal with. Of the options offered, a staging table will definitely work whereas setting language might work if you are lucky and date format is the only issue.Sun, 17 Feb 2013 06:08:42 GMTL' Eomot InverséRE: You are a database administer for a multi-national...http://www.sqlservercentral.com/Forums/Topic490202-32-1.aspxvery godd question..looking for the solution of this from a long timeFri, 12 Oct 2012 01:19:32 GMTkapil_kkRE: You are a database administer for a multi-national...http://www.sqlservercentral.com/Forums/Topic490202-32-1.aspxThe best way could be send the date in ANSI format: yyyy-mm-ddThu, 24 Apr 2008 12:28:02 GMTRic SierraYou are a database administer for a multi-national...http://www.sqlservercentral.com/Forums/Topic490202-32-1.aspxComments posted to this topic are about the item [B]<A HREF="/questions/SQL+Server+Development/60145/">You are a database administer for a multi-national...</A>[/B]Thu, 24 Apr 2008 12:25:28 GMTSteve Jones - SSC Editor