Nth Row to local variable

and Also would I be able to use WHEN conditions after the PRINT statement just in case a situation arises where I need to store values based on conditions?

Something like this

WHILE @@FETCH_STATUS=0
BEGIN
PRINT  @STUDENT_MARKS WHEN GRADE = 'A'
--EXEC (@VALUE)
FETCH NEXT FROM CUR INTO @STUDENT_MARKS
END 
CLOSE CUR

Yes, We can use a condition while retrieving the data.

-- USING CASE STATEMENT

DECLARE @STUDENT_GRADE VARCHAR(10)
DECLARE CUR CURSOR LOCAL
FOR SELECT CASE WHEN MARKS<80 THEN 'FAIL'
            WHEN MARKS>80 THEN 'PASS' END AS RESULT FROM STUDENT
OPEN CUR
FETCH NEXT FROM CUR INTO @STUDENT_GRADE
WHILE @@FETCH_STATUS=0
BEGIN
PRINT  @STUDENT_GRADE
--EXEC (@VALUE)
FETCH NEXT FROM CUR INTO @STUDENT_GRADE
END 
CLOSE CUR

-- USING WHERE CONDTION

DECLARE @STUDENT_GRADE VARCHAR(10)
DECLARE CUR CURSOR LOCAL
FOR SELECT STUDENT_NAME FROM STUDENT1 WHERE MARKS>60
OPEN CUR
FETCH NEXT FROM CUR INTO @STUDENT_GRADE
WHILE @@FETCH_STATUS=0
BEGIN
PRINT  @STUDENT_GRADE
--EXEC (@VALUE)
FETCH NEXT FROM CUR INTO @STUDENT_GRADE
END 
CLOSE CUR

Thanks.

---

bala krishna