|
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
Navigation:
[Reply to this message]
|