Proc UpdateAddress(@Addressid int,@line1 varchar(35),(@line2 varchar(35), (@line3varchar(35), (@line4 varchar(35)) As Insert into AddressHistory (Addressid int, line1 , line2, line3, line4, xline1, xline2, xline3, xline4) (Select Addressid, line1, line2, line3, line4, @line1, @line2, @line3, @line4 from address where addressid = @Addressid ) -- Then update the address table with new values