Month: October 2014

update a
 set a.some_column = b.some_column
 from some_database.dbo.some_table a
 JOIN some_database.dbo.some_table b ON 
      a.some_column = b.some_column
 where a.some_column = 'some_value'