T-SQL Cursors (autoreminder)

DECLARE thecursor CURSOR FOR SELECT ...;
OPEN thecursor;
FETCH NEXT FROM thecursor INTO @thevariable;
WHILE @@FETCH_STATUS = 0
BEGIN
...
FETCH NEXT FROM thecursor INTO @thevariable;
END
CLOSE thecursor;
DEALLOCATE thecursor;