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