Keven Keven - 6 months ago 24
SQL Question

SQL Server- update values from one column in same table to another

I'm trying to overwrite values that are found in TYPE1 with values that are found in TYPE2.

I wrote a fiddle to try it out, but for some reason it isn't updating.

http://www.sqlfiddle.com/#!3/a4733/17

Any reason why my values in TYPE1 are not updating?

Answer

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
Comments