;-)

>merci Gregory,
>
>c'est beau !
>
>

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

>>>
>>>i want a sql to have 2 in first exemple
>>>i want a sql to have 3 in the second exemple
>>>
>>>thank in advance
>>

>>select count(distinct nsql  ) ;
>>	from thankUT 
>>