>DECLARE @lcField Char(40) >DECLARE @lcField2 Char(40) >DECLARE @lnNumero Integer >DECLARE @lnNumero2 Integer >DECLARE @loRecord nvarchar(128) > >DECLARE @crsRelation TABLE (Numero (the type here), > Field (type here), > Field2 (type here), > ID int IDENTITY(1,1)) >INSERT INTO crsRelation >SELECT Numero,Field,Field2 FROM Relation >DECLARE @id int, @maxid int >SELECT @maxid = MAX(Id) FROM @crsRelation >SET @Id = 1 >WHILE @Id <= @MaxId > BEGIN > SELECT ..... > > > SET @Id = @Id + 1 > END >Thanks