WHILE Loop Not Working

Evening everyone. I am having problems with my WHILE loops.

When I paste the following into the MS SQL query window I get an error message saying there is a problem near 'CURSOR'.


Code:


SELECT Course_ID, Course_Name
INTO CursorTable
FROM NorcatCourses
WHERE (Course_Name LIKE 'XNMM%') AND (Course_Name NOT LIKE '%Presentation')
ORDER BY Course_Name;

/* Declare the cursor */
DECLARE Cursor_original CURSOR
SCROLL
FOR
SELECT Course_ID, Course_Name
FROM CursorTable;

/* Declare the temporary cursor variables
* to be used
*/

DECLARE @Course_ID int;
DECLARE @Course_Name nvarchar(50);

/* Declare tepmorary variables for the cursor copy */
DECLARE @Course_ID_copy int;
DECLARE @Course_Name_copy nvarchar(50);

/* Open the cursor and fetch the first record */
OPEN Cursor_original;
FETCH NEXT FROM Cursor_original INTO @Course_ID, @Course_Name;

WHILE (@@FETCH_STATUS = 0) /* Outer Loop */
BEGIN

/* Declare a second copy of the cursor to be used
* for comparison
*/
DECLARE Cursor_copy CURSOR
SCROLL
FOR
SELECT *
FROM CursorTable;

/* Open Cursor_copy and fetch the first record */
OPEN Cursor_copy;
FETCH NEXT FROM Cursor_copy INTO @Course_ID_copy, @Course_Name_copy;

WHILE (@@FETCH_STATUS = 0) /* Inner Loop */
BEGIN

IF (@Course_Name LIKE '%' + @Course_Name_copy + '%') AND
(@Course_ID < @Course_ID_copy)
BEGIN

DELETE CursorTable
WHERE CURRENT OF Cursor_original;

END;

FETCH NEXT FROM Cursor_copy INTO @Course_ID_copy, @Course_Name_copy;
END; /* Inner Loop */

/* Clean up */
CLOSE Cursor_copy;
DEALLOCATE Cursor_copy;

FETCH NEXT FROM Cursor_original INTO @Course_ID, @Course_Name;
END; /* Outer Loop */

/* Clean up */
CLOSE Cursor_original;
DEALLOCATE Cursor_original;
/* DROP TABLE CursorTable; */



According to all of the tutorials I've read my syntax for a WHILE loop appears to be correct. Where am I going wrong?

Thanks.