>DECLARE @lcField Char(40) >DECLARE @lcField2 Char(40) >DECLARE @lnNumero Integer >DECLARE @lnNumero2 Integer > >WHILE EXISTS (SELECT 1 FROM Relation) >BEGIN > SELECT @lnNumero=Numero,@lcField=Field,@lcField2=Field2 FROM Relation > PRINT 'Update Relation '+@lnNumero+'.' > > SELECT @lnNumero2=Numero FROM Field WHERE Field=@lcField > > UPDATE Relation SET NoField=@lnNumero2 WHERE Numero=@lnNumero > > SELECT @lnNumero2=Numero FROM Field WHERE Field=@lcField2 > > UPDATE Relation SET NoField2=@lnNumero2 WHERE Numero=@lnNumero > >END >I need to select all records at first and loop. I do not think this would do it.