I have two tables here is the description:
Employees (E_ID(Primary key), Name, Address)
EmployeeEmails( E_ID(Foreign Key), EmailID(Primary Key), email)

I want to write a stored procedure which will insert record in Employees as well as Multiple Emails related to that perticular employee in EmployeeEmails Table....

I'll appreciate little help.