DECLARE @MinTablePK AS int -- or the type of PK field you use for that table
DECLARE @cCode varchar(200)
SELECT @MinTablePK = MIN(PKField) FROM MyTable
WHILE @MinTablePK IS NOT NULL
      BEGIN
          SELECT @cCode = Code FROM MyTable WHERE PKField = @MinTablePK
          UPDATE MyTable2 SET ... WHERE  Code = @cCode
          DELETE FROM MyTable2 WHERE  Code = @cCode
          SELECT @MinTablePK = MIN(PKField) FROM MyTable WHERE PKField > @MinTablePK
      END