RedGate SQL Prompt - Cursor Snippet mistake
YES, it is incorrect.  The inner FETCH NEXT should go at the END of the loop.  The code above would result in the following:

Hello, I am # 2
Hello, I am # 3
Hello, I am # 4
Hello, I am # 5
Hello, I am # 5


Correcting the problem, and putting the FETCH NEXT at the end of the loop, results in the correct &amp; expected output:

Hello, I am # 1
Hello, I am # 2
Hello, I am # 3
Hello, I am # 4
Hello, I am # 5


Now to go submit this to RedGate...