Mr Jesper,

I think this is the technique what U have meant.

****************************************************

eg:-

SELECT @id=MIN(id) FROM TABLE1

SET @minid=@id

WHILE @minid IS NOT NULL

BEGIN

------

-------

-------

SELECT @minid=MIN(id) FROM TABLE1 WHERE id > @minid

END

***********************************************************

If this is the technique if a table is very big that

doesn't help i feel. Every time U will have to check

the minimum of that table for manipulations.

Actually I know 3 techniques which are replacement for the

Cursors.

1) Using Temp tables

2) Using Table Variables

3) Finding the MIN value and manipulating row by row

I wanted some other technique which can be actually used on

big tables so that the manipulations does work faster.

regards

shown