Hello,
I have this Store Procedure and i am new in "Cursor" programming

The store Procedure is this

CREATE PROCEDURE Testing_Cursor AS
DECLARE @AccCode varchar(12)
DECLARE @YEAR varchar(4)
Declare CODE CURSOR
FOR
SELECT DISTINCT(NLAcc_Code)
FROM NLMovement_TMP
OPEN CODE
BEGIN
FETCH NEXT FROM  CODE INTO @AccCode
WHILE @@FETCH_STATUS = 0
  BEGIN
   DECLARE CYEAR CURSOR
    FOR SELECT DISTINCT(AccYear) FROM  NLMOVEMENT_TMP WHERE
NLACC_CODE=@ACCCODE
    OPEN CYEAR
    FETCH NEXT FROM CYEAR INTO @YEAR
    WHILE @@FETCH_STATUS = 0
      BEGIN
    SELECT SUM(MOVEMENT)
    FROM NLMOVEMENT_TMP
    WHERE NLACC_CODE=@ACCCODE
    AND ACCYEAR=@YEAR
      END
    CLOSE CYEAR
END
END
CLOSE CODE
GO
I have an endless lopp in the second WHILE @@FETCH_STATUS = 0
it avtually never goes into the begin - end code after .
Am i using the WHILE statment correct??
Can anyone find the what is wrong with it??

Thanks
Savvas

INSERT table (column1, column2) (@variable, '100')
Simple JOIN turned ugly - Help!
Is the SQL Server Service Running?
Grouping,Paging Logic
sORTING ACROSS MULTIPLE COLUMN