Nice answer.

Thanks for your help.

And the INSERTED.EmployeeID would have the next identity value that is added to the Employee table in it's insert?

Thank you for your reply but.....
This is the example right out of Microsoft's specifications.  They have created a table variable with 5 fields and only specify 3 in the...