0 - 2 of 2 tags for cursors

Hi,
I am try to use a cursor to loop through multiple values, which is fine if I only use one column.
It doesn't seem to work if I try to fetch more than one column.
e.g.

DECLARE var_a VARCHAR(10);

DECLARE var_b VARCHAR(10);

DECLARE var_c VARCHAR(10);

 

DECLARE crsr CURSOR FOR

Hi All,
I need your help in converting FLAT LOGIC(Flat SQL) Stored procedure to a SET LOGIC(SET SQL). From what I understand, a Flat logic is a cursor based SQL while SET logic works on sets of data.