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 >>
>>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?