Posted by Michael.Suarez on 03/17/06 22:43

I'm a fan of temp tables:

create table #results
(ssn varchar(10)
title varchar(10),
location varchar(32))

insert #results (ssn)
values ('322')
insert #results (ssn)
values ('536')
insert #results (ssn)
values ('258')
insert #results (ssn)
values ('478')
insert #results (ssn)
values ('861')

update r
set r.title = t.title,
r.location = t.location
from #results r,
table_1 t
where r.ssn = t.ssn
and t.title = 'EX'
and t.location = 'DALLAS'


select * from #results

[Back to original message]