From: reb01501@NOSPAMyahoo.com   
      
   rja.carnegie@gmail.com wrote:   
   > Of course you assumed that the ranking column [num] runs 1, 2, 3, 4,   
   > 5, ... with no numbers missing or duplicated.   
      
   I could only go by the data offered.   
      
   >  Otherwise, reviving   
   > the question of a cursor looks good to me......   
      
   Why? What would it solve, and how?   
      
   >   
   > I forget whether calculating a rank by Transact-SQL first appeared in   
   > edition 2005 - and whether those same issues come up.  But if the data   
   > is historic and not changing, then performing the calculation while   
   > a user is waiting may be not best.   
      
   YMMV   
      
   >   
   > An advantage of recommending a solution without a cursor is that if   
   > the question is someone's assignment at college, then you aren't   
   > being helpful.  :-)   
      
   That assumes I want to be helpful to someone doing their homework   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)