May be you have missed to put the filter using `WHERE`
Try this
create proc [dbo].[YourSpName]
(
@EmployeeId int
)
as
begin
select FirstName,LastName,UserType,Salary,Date
From Employee Emp
inner join EmployeeDetails empdetails on Emp.EmployeeID=EmployeeDetails.EmployeeID
where Emp.EmployeeID=@EmployeeId
end
Hope, it helps :)