create table #t (name varchar( 10 ),type int,value int)
insert into #t select 'a', 0 , 0  union select 'a', 1 , 1  union select 'a', 2 , 0 
insert into #t select 'b', 0 , 1  union select 'b', 1 , 1  union select 'b', 2 , 1 

select t1.name,t1.value,t2.value,t3.value,
cast(t1.value as varchar( 1 ))+cast(t2.value as varchar( 1 ))+cast(t3.value as varchar( 1 )) as code
from (select * from #t where type= 0 ) as t1
left outer join (select * from #t where type= 1 ) as t2 on t2.name=t1.name
left outer join (select * from #t where type= 2 ) as t3 on t3.name=t2.name

drop table #t