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

Re: SQL Cursors

From	"Bob Barrows" <reb01501@NOSPAMyahoo.com>
Newsgroups	comp.databases.ms-sqlserver
Subject	Re: SQL Cursors
Date	2012-09-05 18:44 -0400
Organization	A noiseless patient Spider
Message-ID	<k28krp$omu$1@dont-email.me> (permalink)
References	(2 earlier) <k26rme$tgn$1@adenine.netfront.net> <k278v1$sq0$1@dont-email.me> <k27bci$19h8$1@adenine.netfront.net> <k27e25$o1o$1@dont-email.me> <b8a56d24-3706-4798-a7b9-c382a1d96557@googlegroups.com>

Show all headers | View raw

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

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