How Can I Store Data In One Row Instead Of 10 Rows?

Hi

I have this stored procedure using Table Variable.

-------------------------------------------------------------------------------------------------------------------------------

create procedure sp_matching @pid Int

AS
declare @tbl table (MAID int, image varchar(100))

insert @tbl
select MAID, image from products
where pid in (select top 10 mid from matching1 where pid=@pid order by newid())

select * from @tbl

GO

---------------------------------------------------------------------------------------------------------------------------------

When I run this sp, i have table with 10 rows. But what I really need to do is to store all data in one row like:

PID, MAID1, Image1, MAID2, Image2, ..... MAID9, Image9, MAID10, Image10

 

How can I do this? Please help me out for this.

Thanks.