HI

In foxpro I would use Cursors for various purposes.

IN SQL2005 I want to create a cursor or equivalent.

What do others do about this.

Should I just select my results into a table which I then drop when I've done with it or is that a bad thing to do.

And if it is bad why ?

(this is for a process that may be run weekly or possibly daily).

Thanks

Nick