Hi,

I have used the following approach for now,

ALTER   PROCEDURE GetCurrentStudentName_New

@stuTable varchar(30),@permNum varchar(7),@stuName varchar(80) OUTPUT

AS