rothco (5/27/2011)

---

As a complete beginner I found the article badly mistitled. It was not Cursors for beginners but why not to use cursors for beginners.

A good starting point in...

An example of a cursor you can find in this post http://www.sqlservercentral.com/articles/cursors/65136/, but don't forget to read the discution for there is some discution possible wether it is a good...

Anyone who knows what happens when a phonenumber is NULL?

For 2 reasons I would add an extra filter

1) don't select what you don't need as soon as possible,...

It works fine for SQL 2005 if you add an extra column to the create statement of #sp_who2

CREATE TABLE #sp_who2 ( SPID INT, Status VARCHAR(1000) NULL, Login...