SQL cursor to convert rows and columns

If exists (select object_id (N 'tempdb .. # t '))
Begin
Drop table # T
End
Create Table # T
(
S nvarchar (4000 ),
Id int
)
Declare @ A nvarchar (4000)
Declare @ IDC int
Declare @ tablename nvarchar (256)
Declare tnames_cursor cursor
For

Select sortid from alink group by sortid

open tnames_cursor
fetch next from tnames_cursor into @ tablename
while (@ fetch_status = 0)
begin
set @ IDC = @ tablename
select @ A = isnull (name, '') + ',' + isnull (@, '') from alink where sortid = @ IDC and passed = 0
insert into # T (S, ID) values (@ A, @ IDC)
fetch next from tnames_cursor into @ tablename
end
close tnames_cursor
deallocate tnames_cursor
select * from # T