SELECT MAX(qty) as MaxQty ; FROM mytable ; INTO ARRAY laMaxQty CREATE CURSOR crsTemp ( Qty I) FOR i=1 TO laMaxQty[1] INSERT INTO crsTemp VALUES (i) ENDFOR SELECT mt.Desc ; FROM mytable mt ; JOIN crsTemp ct ON ct.Qty <= mt.qty ; INTO CURSOR crsResult>Hi all,
>Qty Desc > 3 Hello > 2 Goodbye >>And get a resulting table of:
>Hello >Hello >Hello >Goodbye >Goodbye >>is this possible or must I just use the old Scan and Insert method?