Samuel Vella (4/27/2009)
atoth (4/27/2009)
I still find I need Cursors when Sending out batches of Email notifications from the Server.I would love to replace this with set based handling but I can imagine how...particulary step 2
Adam
you're performing a procedural not a set based operation and the "per-row" function calls means that you will need to use a cursor.
Cursors do have their uses and this is one of them.
Heh... in SQL Server 2005, even that can be done without a cursor. We're just gonna have to wait for it in Barry's series of articles.
--Jeff Moden
Change is inevitable... Change for the better is not.