SQL case statement for updating multiple rows

Here is one sample sql satement for updating multiple rows of a table using case statements

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