Create table #temp (
pid int,
name varchar (50)
)
insert into #temp select 1,'a' union all
select 2,'b'
select * from #temp
UPDATE #temp
SET name = CASE pid
WHEN 1 THEN 'aa'
WHEN 2 THEN 'bb'
END
WHERE pid IN (1,2)
Modify the highlighted query accordingly
-Shinu