thanks much that helped..

sorry about that , i should have said 3 tables.

movie(id, title, yr, score, votes, director)

actor(id, name)

casting(movieid, actorid, ord)

Thanks much it worked and if i want to extend the pgm to calculate the percentage and give them the grade like A,B, C..

Then how do i write?

i appreciate your...

but when i excuted i got this below err msg,

Msg 201, Level 16, State 4, Procedure procname, Line 0

Procedure or function 'procname' expects parameter '@result', which was not supplied.

...