No candidates in the list for FETCH NEXT ... INTO
FETCH NEXT FROM tmp INTO<space>
When you add the @ so the statement looks like this:
The candidate list becomes empty.
This is with SQL Prompt 22.214.171.124 Pro.
MCP, MCTS, MCITP DBA
Winona State University
"Quality, like Success, is a Journey, not a Destination" - William Soranno '92