Re: calling a stored procedure in a while loop



I have not used the 'SQL pane', but my understanding is that it is intended for writing simple queries against a table, and not for complex procedural code. Running the code in a 'Query' window is the correct way.

HTH,

Plamen Ratchev
http://www.SQLStudio.com

.