A co-worker helped with this. His solution

declare @contact_type table(contactTypeID int,contactType varchar(50))

declare @resident table(residentID int,firstName varchar(50), lastName varchar(50))

declare @resident_contact table(residentContactID int,contactName varchar(50),residentID int,contactTypeID int)

insert into @contact_type (contactTypeID, contactType)

values(1,'Emergency')

,(2,'Spouse')

insert into @resident(residentID,firstName,lastName)

values...