title: pass parameter in table valued function using select statement
body: <p>I have created a table valued return function which returns me a table . here is call of my function as follow </p>
  
  <pre><code>SELECT * FROM dbo.[StateFixedTaxesCalculation](3020,16,1,1006)
  </code></pre>
  
  <p>and its working OK for me , now i want to use this function call in a select statment , so i can pass <code>16</code> which is basically <code>employeeId</code> dynamically. </p>
  
  <p>So i have decided to use inner join with table returned by that function . Like this </p>
  
  <pre><code>SELECT * FROM Employee as E
  INNER JOIN  dbo.[StateFixedTaxesCalculation](3020,16,1,1006) as TC   ON TC.EmployeeId=E.EmployeeId
  </code></pre>
  
  <p>but now how can i pass <code>16</code> as dynamic value of all <code>employeeId</code> one by one . </p>