SQL Server stored procedure to horiztonal display a result set

See more:

SQL-Server

SQL-Server-2008

I have the following tables:
assign table (assignID, assignName, points)
table assignpoint table (assignid, studentid, score)

I want to display them in table format as follows
studentid ,assginname1, assignname2, assigname3, etc. total
1 , 90, 80, 90, etc.

How can I do that I know about pivot tables but i can not implement it in my senario mentioned above.

I am using SQL server 2008 and coldfusion
I want to create a stored procedure that will produce the following result set in the format mentioned before