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