Update COLUMN Date

update TABLENAME t
set COLUMN_NAME  = (select COLUMN_NAMEfrom TABLENAME where CASE and CASE) ,                COLUMN_NAME= (select COLUMN_NAME from TABLENAME where CASE and CASE)