Try the following code. . .
DECLARE @MYVAR NVARCHAR(100)
Declare @MyVar2 nvarchar(100)
DECLARE MYTESTCURSOR CURSOR
DYNAMIC
FOR
SELECT EmpID,EmpName FROM Employees
OPEN MYTESTCURSOR
FETCH LAST FROM MYTESTCURSOR INTO @MYVAR,@MyVar2
CLOSE MYTESTCURSOR
DEALLOCATE MYTESTCURSOR
SELECT @MYVAR,@MyVar2