calling stored procedure inside while loop

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 :)

Quote:

---

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

---

It certainly is possible.

Quote:

---

However an error is thrown.

---

Post the error information.

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

Code:

---

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.