>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 > > > >Check this related thread http://social.msdn.microsoft.com/Forums/en-US/databasedesign/thread/5c4778d5-2519-480b-abd0-93b9a90a587d