jeudi 21 juillet 2016

how to update a resulting table from a query

i m trying to update a table which is a shorter version of my original table. What i have is the following:

UPDATE (SELECT * FROM bookings_tbl
where ACCOUNT LIKE 'RENTA%' AND PART_TYPE ='HARDWARE')
SET PART_TYPE= 'EQUIPO' WHERE PART_TYPE='HARDWARE';

don't know if it s possible, but i would like to have what is stated as HARDWARE in that small table saying EQUIPO. i m using micros SQL Server Mgmt Studio

Aucun commentaire:

Enregistrer un commentaire