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'
Please follow and like us:
SQL Server – How to copy data value in column from one table to another