Hi,

I would like to write a stored procedure that returns a resultset.

e.g. select student_id, student_subject, subject_marks
from student_results
where student_class_no = ?

The input parameter is student_class_no (see ? as per above SQL).
The output is a resultset, with each result consisting of student_id,
student_subject, subject_marks.

Can anyone advise how this is done in sql server stored procedure?

Thanks,
June Moore.