Two ways

1. Declare the employee columns as input params to proc, in asp before calling InsertAccidentRep call another proc to retrieve them from employee table and then pass them to InsertAccidentRep proc.

2. Do not declare the employee columns as input params to proc but instead declare them as variables. Select the variables from the employee table using @empid and use these variables in your insert statement.

Either will do and choice depends on how much flexibilty you want.