INSERT INTO [dbo].[1234] ([StaffID], [Name1], [Name1_1], [DateofBirth], [Gender], [PositionID], [PositionName], [Position_Description], [PayPeriod], [PayRate], [EmailAddress]) VALUES (@StaffID, @Name1, @Name1_1, @DateofBirth, @Gender, @PositionID, @PositionName, @Position_Description, @PayPeriod, @PayRate, @EmailAddress) SELECT StaffID, Name1, Name1_1, DateofBirth, Gender, PositionID, PositionName, Position_Description, PayPeriod, PayRate, EmailAddress FROM dbo.[1234] INSERT INTO [dbo].[marathon-skills-2016-timesheet-import] ([TimesheetID], [NumStaffID], [NumStartDateTime], [EndDateTime], [PaymentAmount]) VALUES (@TimesheetID, @NumStaffID, @NumStartDateTime, @EndDateTime, @PaymentAmount) SELECT TimesheetID, NumStaffID, NumStartDateTime, EndDateTime, PaymentAmount FROM dbo.[marathon-skills-2016-timesheet-import]