MS SQL Server – When is a CURSOR good?
Many times when I’ve written stored procedures, etc. I use a CURSOR at first and later find some performance issue with my procedure.
Every thing I read says CURSORS are awful, cause unnecessary locking, etc. and performance testing proves the same.
My question is when do you use a CURSOR and in what situations are they useful or good?
If there is no use, why would they make such a bad control structure/type for SQL?