select iresidentid , count(distinct nsql ) ; from thankUT GROUP BY 1 INTO CURSOR temp set SELECT temp browse>>hi all,
>>create cusor thankUT ( iresidentid I , nsql I ) >> >>*first >>insert into thankUt ( iresidentid , nsql ) values ( 1 , 1 ) >>insert into thankUt ( iresidentid , nsql ) values ( 1 , 7 ) >> >> >>* second >>insert into thankUt ( iresidentid , nsql ) values ( 2 , 14) >>insert into thankUt ( iresidentid , nsql ) values ( 2 , 14 ) >>insert into thankUt ( iresidentid , nsql ) values ( 2 , 8 ) >>insert into thankUt ( iresidentid , nsql ) values ( 2 , 7 ) >> >>>>
>select count(distinct nsql ) ; > from thankUT >