I have 4 rows in a table and I need to update row 3 and 4
to 1 and 2 with a new values and delete row 3 and 4 after
is done. Any help would greatly appreciate. Please look
at me desire result. Once again, Thank you for your help.
drop table #Temp
CREATE TABLE #Temp
Policy_id INT NULL,
NamedInsured_id INT NULL,
First_nm VARCHAR(15) NULL,
Last_nm VARCHAR(15) NULL,
Birth_dt DATETIME NULL,
HomePhone_nb CHAR(10) NULL
INSERT #Temp VALUES (183074, 1, 'Peter', 'BUMACOD', '1960-
INSERT #Temp VALUES (183074, 2, 'EVELYN', 'BUMACOD', ...