update through another table

CREATE PROCEDURE [insert_TERMINATION_TestSp]
	(@TM_#_1 	[int],
	 @FirstName_2 	[nvarchar](50),
	 @LastName_3 	[nvarchar](50),
	 @SocialSecurityNumber_4 	[int],
	 @DateHired_5 	[datetime],
	 @Status_6 	[nvarchar](50),
	 @Title_7 	[nvarchar](50),
	 @DepartmentName_8 	[nvarchar](50))

AS INSERT INTO [GamingCommissiondb].[dbo].[TERMINATION] 
	 ( [TM #],
	 [FirstName],
	 [LastName],
	 [SocialSecurityNumber],
	 [DateHired],
	 [Status],
	 [Title],
	 [DepartmentName]) 
 
VALUES 
	( @TM_#_1,
	 @FirstName_2,
	 @LastName_3,
	 @SocialSecurityNumber_4,
	 @DateHired_5,
	 @Status_6,
	 @Title_7,
	 @DepartmentName_8)
GO