Thanks guys. I appreciate the effort. Will try both ways suggested.

DECLARE memcor CURSOR GLOBAL FORWARD_ONLY STATIC FOR

 SELECT  DISTINCT UserID,StatusID,HomeOrgID,Convert(datetime,CancelDate)

 From  tblmembership

 WHERE  Mon = @month

  and Year = @Year

 -- Selects around 500000 rows

 OPEN  memcor

 FETCH NEXT FROM memcor

 INTO  @userID,@StatusID,@HomeClub,@CanDate

Print 'Cursor Rows'

Print @@CURSOR_ROWS

WHILE...

Yes