I can't understand, where has this hate of cursors come from. Is it a general DBA thing or something else.

I would have thought that using a cursor/recordset would be much simpler to control than selecting into temp tables/table variables etc.

Is it a performance hangover from SQL 7, I just do not see any performance improvement in 2000.....

Bob