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