>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
SQL Server is all about set-based operations. If you can perform your process with set-based, it will be better than using cursors.
If there is absolutely no set-based alternative, then I suggest to read Brad Schulz series about cursors
The Truth about Cursors - Part 1and other parts.
If it's not broken, fix it until it is.
My Blog