transformer ça 06 0 371.4600 06 1 209.3000 06 2 6871.6000 06 3 3495.7900 12 1 2300.3500 12 2 4159.2200 12 3 1731.8800 en 0 1 2 3 06 371.46 209.3 6871.6 3495 12 NULL 2300.35 4159.22 1731.88 -------------------------------------------------------------- DECLARE SCAN_CURSOR CURSOR FOR SELECT * FROM TABLE_ECLATEE OPEN SCAN_CURSOR DECLARE @CHAMP1 type, @CHAMP2 type, @CHAMP3 type, @COUNT1 int FETCH NEXT FROM SCAN_CURSOR WHILE @@FETCH_STATUS = 0 BEGIN FETCH NEXT FROM Employee_Cursor into @CHAMP1,@CHAMP2,@CHAMP3 SELECT @COUNT1=count(*) from TABLE_CONSOLIDEE where COLONNE1=@CHAMP1 IF @COUNT1 = 0 BEGIN INSERT INTO TABLE_CONSOLIDEE (@CHAMP2) VALUES (@CHAMP3) where COL1 = @CHAMP1 END ELSE BEGIN UPDATE TABLE_CONSOLIDEE SET @CHAMP2=@CHAMP3 where COL1=@CHAMP1 END END CLOSE SCAN_CURSOR DEALLOCATE SCAN_CURSOR