DECLARE @Parameter1 sqltype
DECLARE @Parameter2 sqltype
-- other parameter ...
DECLARE Cursor_Name CURSOR FOR
SELECT statement
OPEN Approver_Cursor
FETCH NEXT FROM Cursor_Name
INTO @Parameter1, @Parameter2 -- ,other parameter
WHILE @@FETCH_STATUS = 0
BEGIN
-- process code
FETCH NEXT FROM Cursor_Name
INTO @Parameter1, @Parameter2 -- ,other parameter
END
CLOSE Cursor_Name
DEALLOCATE Cursor_Name