InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 25 May 2013 07:22:59 GMT20http://www.sqlservercentral.com/Forums/Topic1361704-391-1.aspxI had a feeling that would be the case. We're currently migrating an old Datawarehouse from SQL 2000 to SQL 2008 R2 and obviously we want the data to match across the systems. Fixing the problem is easy enough but this means we are left with inconsistencies between the two systems which isn't ideal. Thu, 20 Sep 2012 17:15:17 GMTdougjjjhttp://www.sqlservercentral.com/Forums/Topic1361704-391-1.aspxI've seen this sort of "inconsistent" result on UPDATEs where you're applying multiple rows to a single row and I don't believe it is controlled by a setting.You need to control it by specifying which row of #Test updates the #UpdatedResults table, like by using a WHERE clause.Thu, 20 Sep 2012 00:45:26 GMTdwain.chttp://www.sqlservercentral.com/Forums/Topic1361704-391-1.aspxHi, I've been having a chat with Google and haven't been able to find an answer to it so here goes ...I have 2 servers, one SQL 2008 R2 & the other SQL 2000, both using the same data, same SQL Statements & same Collation and they are returning different results. The SELECT statement of the UPDATE returns multiple rows for each row that is updated. SQL 2008 R2 uses the values from the First row returned and SQL 2000 is using the values from the Last row returned for each update. Example below ... - If I run the code below on a SQL 2008R2 machine the result is 1. - If I run the code below on a SQL 2005 machine the result is 1.- If I run the code below on a SQL 2000 machine the result is 3.[code]CREATE TABLE #Test( Row INT IDENTITY (1, 1), Result INT)CREATE TABLE #UpdateResult( Result INT)INSERT #UpdateResultSELECT 0INSERT #TestSELECT 1INSERT #TestSELECT 2INSERT #TestSELECT 3UPDATE #UpdateResultSET Result = #Test.Result FROM #TestSELECT * FROM #UpdateResultDROP TABLE #UpdateResultDROP TABLE #Test[/code]Questions ...- Huh?- Is this a setting that is specified anywhere? If so can it be changed?Wed, 19 Sep 2012 19:57:59 GMTdougjjj