Stored Proceedure Question, How To Pull An Autogenerate Field Value?

I have a stored proceedure that is adding a record to a database table. When the record is added using an insert statement, the ID field is autogenerated.

I have a second insert statement that inserts into a second table, however, I want/need? to use that ID field in order to link this additional information to the proper record in the initial table.

 Is there an easy way to do a select or just pull the ID?  I was thinking I could do a select before the final insert using 2 or 3 required fields of which used in a select altogether would be unique, but before I did that, I wanted to see if I was missing a better way. I posted the code below....

 set ANSI_NULLS ON

set QUOTED_IDENTIFIER ON

go

 

ALTER PROCEDURE [dbo].[Add_Employee_Data]

(

@LastName as varchar(100),@FirstName as varchar(100),

@MiddleName as varchar(100),@Position as varchar(100),

@Department as varchar(100),

@DirectDial as varchar(100),

@Ext as varchar(100),

@Fax as varchar(100),

@HomePhone as varchar(100),

@CellPhone as varchar(100),

@Partner as varchar(100),

@TimeKeeper as varchar(100),

@Notary as varchar(100),

@Practice as varchar(100),

@SummerAddress as varchar(250),

@SummerPhone as varchar(100),

@LegalNonLegal as varchar(100),

@Bar as varchar(100),

@OtherEmail as varchar(100),

@HomeAddressComplete as varchar(100),

@HomeAddress as varchar(100),

@HomeCity as varchar(100),

@HomeState as varchar(100),

@HomeZip as varchar(100),

@School as varchar(100),

@Degree as varchar(100),

@Status as varchar(100),

@Floor as varchar(100)) AS

DECLARE @Code as varchar(100)

 

INSERT Into tblMain2(LastName,FirstName,MI,Position,Dept,Extension,DirectDial,[FAX DID],HomePhone,CellularPhone,SpousePartner,

TimeKeeper,Notary,PrGroup,SummerAddress,SummerPhone,LegalNonLegal,Bar,OtherEmail,HomeAddressComplete,HomeAddress,HomeCity,

HomeState,HomeZip,Floor,Active)

Values(@LastName,@FirstName,@MiddleName,@Position,@Department,@Ext,@DirectDial,@Fax,@HomePhone,@CellPhone,@Partner,@TimeKeeper,

@Notary,@Practice,@SummerAddress,@SummerPhone,@LegalNonLegal,@Bar,@OtherEmail,@HomeAddressComplete,@HomeAddress,

@HomeCity,@HomeState,@HomeZip,@Floor,@Status)

<<<<< Put select statement here to pull in @Code where LastName = @LastName  and Extension =@Ext ??

INSERT Into Education(Code,CollegeSchool,DegreeCert) Values(@Code,@School,@Degree)