This is a stored procedure that returns EmployID and the Full Name (both last name and first name first), and is sorted by a parameter.
Using a variable to sort a SQL statement is an unusual technique, the statement is work studying just for that.
