The closest to VFP cursor would be a table variable or temp table but first you have to decide if you need it at all.
>
>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
--sb--