INSERT DOSKA_FORMED_GPGRPR
SELECT (SET @TMP=@TMP+1),a.RAZDEL_NAME,a.ID
FROM DOSKA_RAZDEL a
WHERE EXISTS (	
			  SELECT b.ID
			  FROM DOSKA_GRUPA b
			  WHERE a.ID=b.RAZDEL_ID
			 )

it is possible make insert during select is performed with value which increments 

CREATE TABLE jobs
(
   job_id  smallint
      IDENTITY(1,1)
      PRIMARY KEY CLUSTERED,
   job_desc        varchar(50)     NOT NULL
      DEFAULT 'New Position - title not formalized yet',
   min_lvl tinyint NOT NULL
      CHECK (min_lvl >= 10),
   max_lvl tinyint NOT NULL
      CHECK (max_lvl <= 250)
)

DELETE FROM DOSKA_FORMED_GPGRPR
GO

DECLARE @ORIG_ID D_MAIN_ID,
		@ARRAY_IDX D_MAIN_ID,
		@ORIG_NAME D_DOSKA_RAZDEL_NAME

SET @ARRAY_IDX=0


DECLARE odbor_cr CURSOR FOR
		SELECT a.RAZDEL_NAME,a.ID
		FROM DOSKA_RAZDEL a
		WHERE EXISTS (	
					  SELECT b.ID
					  FROM DOSKA_GRUPA b
					  WHERE a.ID=b.RAZDEL_ID
					 )
		   AND a.ID NOT IN (
						    SELECT ORIG_ID 
						    FROM DOSKA_FORMED_GPGRPR
					        WHERE SECTION_NAME='razdel'	
						   )	

OPEN odbor_cr

FETCH NEXT FROM odbor_cr
INTO @ORIG_NAME,@ORIG_ID

 WHILE @@FETCH_STATUS = 0
 BEGIN
   SET @ARRAY_IDX=@ARRAY_IDX+1	

   PRINT 'CURRENT ID='+CAST(@ORIG_ID AS VARCHAR)	

   INSERT INTO DOSKA_FORMED_GPGRPR(A_TYPE,CAPTION,ARRAY_M,ARRAY_IDX,ORIG_ID,SECTION_NAME)
	    VALUES('razdel_1',@ORIG_NAME,1,@ARRAY_IDX,@ORIG_ID,'razdel')  	

   FETCH NEXT FROM odbor_cr
   INTO @ORIG_NAME,@ORIG_ID	
 END


 CLOSE odbor_cr
 DEALLOCATE odbor_cr


--for checking
SELECT * FROM DOSKA_FORMED_GPGRPR

quote:

---

An identity column CAN help, but you have to create a temp table or put the results into another table with the idenitity, and then use that. Does that make sense, marconi? just create another table with an identity, and put your results into that table. Then you have a row# field you can page by.

---