select Lit_LosFK, Lit_Date ; from LOSSITEM ; where str(Lit_LosFK, 6) + dtos(Lit_Date) in ; (select PADR(str(Lit_LosFK, 6),6) + min(dtos(Lit_Date)) from LOSSITEM group by Lit_LosFK) ; group by 1, 2 ; into cursor curFIRSTLOSSPAYMENT1 nofilterThanks,
>select Lit_LosFK, Lit_Date ; > from AI!LOSSITEM ; > where str(Lit_LosFK, 6) + dtos(Lit_Date) in ; > (select str(Lit_LosFK, 6) + min(dtos(Lit_Date)) from AI!LOSSITEM group by Lit_LosFK) ; > group by 1, 2 ; > into cursor curFIRSTLOSSPAYMENT1 nofilter > > >select str(Lit_LosFK, 6) + min(dtos(Lit_Date)) as TmpKey ; > from AI!LOSSITEM ; > group by Lit_LosFK ; > INTO CURSOR curTemp nofilter > >select Lit_LosFK, Lit_Date ; > from AI!LOSSITEM ; > where str(Lit_LosFK, 6) + dtos(Lit_Date) in ; > (SELECT TmpKey FROM curTemp) ; > group by 1, 2 ; > into cursor curFIRSTLOSSPAYMENT2 nofilter >