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