Hi,
You have not provided full information to help you. Below i am trying to help you out on my understanding and your info.
Here i am considering your table structure is...
EmpId,
EmpName,
EmpFullName
.
.
and so on.
Check this ...
Create proc pr_emp_info
(
@pa_empName varchar(100)
)
AS
BEGIN
SELECT EmpId, EmpFullName, Role from EmployeeDetails where empname=@pa_empName
END
Hope this will help you.
Cheers