> select s.id, count(*) rank
> from s
> join s r on s.id >= r.id
> group by s.id

Nice trick, i would never imagine something like this :-)

Anyway, i will use a sp. I'm trying to avoid sp's, but performance is
always a main concern.

And using generators is not a perfect solution, because i develop a
multiuser application.

Thanks.