Update values from one column in same table to another in SQL Server
You put select query before update queries, so you just see initial data. Put select * from stuff;
to the end of list.
This works for me
select * from stuff
update stuff
set TYPE1 = TYPE2
where TYPE1 is null;
update stuff
set TYPE1 = TYPE2
where TYPE1 ='Blank';
select * from stuff
UPDATE a
SET a.column1 = b.column2
FROM myTable a
INNER JOIN myTable b
on a.myID = b.myID
in order for both "a" and "b" to work, both aliases must be defined
UPDATE TABLE_NAME SET COLUMN_A = COLUMN_B;
Much easier. At least on Oracle SQL, i don't know if this works on other dialects as well.