calling stored procedure inside while loop

[sunshine123]

Hi,

I noticed that in Sql server 2000 it is not possible to call a stored procedure
inside the while loop. I have a while loop similar to the following inside a stored procedure which in turn calls a stored procedure. However an error is thrown.

while (intNumber < 10)
Begin
Exec someStoredProcedure
intNumber = intNumber + 1
End

thanks in advance

[brucevde]

I noticed that in Sql server 2000 it is not possible to call a stored procedure inside the while loop.

It certainly is possible.

However an error is thrown.

Post the error information.

[szlamany]

That is not real T-SQL code - it would be more like this:

declare @intnumber int
set @intnumber=0
while (@intNumber < 10)
Begin
Exec someStoredProcedure
set @intNumber = @intNumber + 1
End

If what you posted was not real code - please post the real code.