Groups > comp.databases.ms-sqlserver > #1253

Re: SQL Cursors

Newsgroups	comp.databases.ms-sqlserver
Date	2012-09-05 15:36 -0700
References	(1 earlier) <k2577t$kqr$1@dont-email.me> <k26rme$tgn$1@adenine.netfront.net> <k278v1$sq0$1@dont-email.me> <k27bci$19h8$1@adenine.netfront.net> <k27e25$o1o$1@dont-email.me>
Message-ID	<b8a56d24-3706-4798-a7b9-c382a1d96557@googlegroups.com> (permalink)
Subject	Re: SQL Cursors
From	rja.carnegie@gmail.com

Show all headers | View raw

Of course you assumed that the ranking column [num] runs 1, 2, 3, 4, 5, ...
with no numbers missing or duplicated.  Otherwise, reviving the question
of a cursor looks good to me......

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.

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

Back to comp.databases.ms-sqlserver | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

SQL Cursors simisa@tiscalinet.it (simisa) - 2012-09-04 14:29 +0200
  Re: SQL Cursors "Bob Barrows" <reb01501@NOyahooSPAM.com> - 2012-09-04 11:27 -0400
    Re: SQL Cursors sim <simisa@tiscalinet.it> - 2012-09-05 08:32 +0200
      Re: SQL Cursors "Bob Barrows" <reb01501@NOSPAMyahoo.com> - 2012-09-05 06:18 -0400
        Re: SQL Cursors sim <simisa@tiscalinet.it> - 2012-09-05 13:00 +0200
          Re: SQL Cursors "Bob Barrows" <reb01501@NOSPAMyahoo.com> - 2012-09-05 07:45 -0400
            Re: SQL Cursors sim <simisa@tiscalinet.it> - 2012-09-05 18:19 +0200
            Re: SQL Cursors rja.carnegie@gmail.com - 2012-09-05 15:36 -0700
              Re: SQL Cursors "Bob Barrows" <reb01501@NOSPAMyahoo.com> - 2012-09-05 18:44 -0400
                Re: SQL Cursors rja.carnegie@gmail.com - 2012-09-05 16:58 -0700
                Re: SQL Cursors Gene Wirchenko <genew@ocis.net> - 2012-09-05 17:23 -0700
                Re: SQL Cursors rja.carnegie@gmail.com - 2012-09-06 02:50 -0700
              Re: SQL Cursors "Bob Barrows" <reb01501@NOSPAMyahoo.com> - 2012-09-05 18:44 -0400
                Re: SQL Cursors sim <simisa@tiscalinet.it> - 2012-09-06 09:37 +0200

csiph-web