Cursors vs. Queries

buddies, situation: a processing must take place on every row of a table, and output results to another table, that can't be done via an...

We have a program that is opening a recordset as a forward only cursor. What we are experiencing is that the cursor is being opened thousan...

We have a program that is opening a recordset as a forward only cursor. What we are experiencing is that the cursor is being opened thousand...

I know cursors are controversial and can cause performance, etc. issues. The question I'm about to pose is because of performance concer...

I always try to use a SELECT and avoid CURSOR logic - whenever possible - but this time I can't even think of a way to SET-base this ope...

Not sure what you want, really. but you may want to try a subquery. select count(*) from yourtable a where exists(select * from yourtable b ...

I always try to use a SELECT and avoid CURSOR logic - whenever possible - bu t this time I can't even think of a way to SET-base this op...