pass parameter in table valued function using select statement
use outer/cross apply:
select *from Employee as E cross apply dbo.[StateFixedTaxesCalculation](3020, E.EmployeeId, 1, 1006) as TCif you still have to filter by TC.EmployeeId = E.EmployeeId, you can do this with subquery:
select *from Employee as E cross apply ( select TT.* from dbo.[StateFixedTaxesCalculation](3020, E.EmployeeId, 1, 1006) as TT where TT.EmployeeId = E.EmployeeId ) as TC