5 Comments

1. Vincent D'Souza says:

   January 20, 2012 at 12:38 pm

   Here is the simplied version of that… enjoy…

   CREATE TABLE #MatchIDs
   (
   UpdateAction varchar(50),
   Table_1_EmployeeID int,
   Table_2_EmployeeID int
   )

   MERGE INTO Table_1 AS TARGET
   USING Table_2 AS SOURCE
   ON TARGET.id = SOURCE.id
   WHEN MATCHED THEN
   UPDATE SET TARGET.FristName = SOURCE.FIRSTNAME
   , TARGET.LASTNAME = SOURCE.LASTNAME
   WHEN NOT MATCHED THEN
   INSERT (FirstName, LASTNAME)
   VALUES (SOURCE.FIRSTNAME, SOURCE.LASTNAME)
   OUTPUT $action, t2.EmployeeID ,t1.EmployeeID into #MatchIDs;

   Reply to this comment
2. Varun Varghese says:

   December 22, 2011 at 5:27 am

   I tried this, but I am getting the following error: Msg 4104, Level 16, State 1, Line 30
   The multi-part identifier “t1.EmployeeID” could not be bound.

   Any ideas what could be wrong. Thanks in advance.

   Reply to this comment
3. fotis says:

   February 25, 2011 at 4:27 am

   briliant piece of code!

   Reply to this comment
4. Ben says:

   February 18, 2010 at 8:58 am

   Hi,

   I really need to do this but am using SQL 2005 – is there any way that this can be done?

   Reply to this comment
   • Derek D. says:

     April 7, 2010 at 8:16 am

     Hi Ben, sorry for the late reply. Unfortunately I don’t think there is.. At least that I know of.

     Reply to this comment