pivoting, Sql Server

Language: Layout:

create table attributes (AttributeID  int, AttributeName varchar(100))
insert into attributes values (1, 'Hobbies'), (2, 'Name'), (3, 'Gender'), (4, 'IrisColor')

create table table1 (sid int, aid int, vid int)

insert into table1 values (1   ,   2  ,   1)
insert into table1 values (1   ,   3  ,   2)
insert into table1 values (1   ,   4  ,   3)
insert into table1 values (1   ,   1  ,   2)
insert into table1 values (1   ,   1  ,   1)

--select * from table1 
--select * from attributes

select t.sid, a.AttributeName, t.vid
into #temptbl
from ( 
        select sid, aid, vid = STUFF((
                                        SELECT ', ' + cast(t.vid as varchar(10))
                                        FROM table1 t 
                                        WHERE t.[aid] = x.[aid]
                                        FOR XML PATH(''), TYPE).value('.[1]', 'nvarchar(max)'), 1, 2, ''
                                    )  
        from table1 as x 
        group by sid, aid
     ) t join attributes a on a.AttributeID = t.aid

select * from #temptbl

SELECT *   
FROM
(
    select * from #temptbl
) as t
PIVOT( MAX(vid) FOR AttributeName IN (Hobbies,Name,Gender,IrisColor)) AS t1
WHERE sid=1

View schema
Execution time: 0,03 sec, rows selected: 5, rows affected: 9, absolute service time: 0,19 sec