I want to create a StoredProc That takes the results of a StoredProc and then I append two columns from a table. For example:
The original StoredProc returns a students First Name and Last Name, but I also want to display the students teacher's name which
lives in table tblTeacher. Both the Stored Proc and tblTeacher are linked by the StudentID column.
Can this be done? If so, how?
Thanks in advance,