>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 > > > >