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
no reporting services
The display will be used also to edit the information in the tables
I want to create a stored procedure that will produce the following result set in the format mentioned before