-
Hi
I have a Stored Procedure with Cursor, I open the cursor out while as:
open cr_Agenda
fetch next from cr_Agenda into @Whr_ini, @Whr_fim,@wlocal,@wnom_loc,@Wccu
while (@@FETCH_STATUS = 0)
begin
<statements>
fetch next from cr_Agenda into @Whr_ini, @Whr_fim,@wlocal,@wnom_loc,@wccu
end
When it read the last row +1 , Where Is wrong ?
Server: Msg 16915, Level 16, State 1, Line -1074292529
A cursor with the name 'cr_Agenda' already exists.
-
interesting....I use this code with the Northwind DB in SQL 7 and it works fine:
Code:
CREATE PROCEDURE spu_test AS
declare @MyCustomerID varchar(50)
Declare MyCursor cursor for
select CustomerID from Customers
open MyCursor
fetch next from MyCursor into @MyCustomerID
while (@@FETCH_STATUS = 0)
begin
print @MyCustomerID
fetch next from MyCursor into @MyCustomerID
end
