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

Re: SQL Cursors

Path	csiph.com!newsfeed.hal-mli.net!feeder3.hal-mli.net!newsfeed.hal-mli.net!feeder1.hal-mli.net!de-l.enfer-du-nord.net!feeder2.enfer-du-nord.net!eternal-september.org!feeder.eternal-september.org!mx04.eternal-september.org!.POSTED!not-for-mail
From	"Bob Barrows" <reb01501@NOSPAMyahoo.com>
Newsgroups	comp.databases.ms-sqlserver
Subject	Re: SQL Cursors
Date	Wed, 5 Sep 2012 18:44:22 -0400
Organization	A noiseless patient Spider
Lines	27
Message-ID	<k28krp$omu$1@dont-email.me> (permalink)
References	<k24s53$1ph$1@news.newsland.it> <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> <b8a56d24-3706-4798-a7b9-c382a1d96557@googlegroups.com>
Injection-Date	Wed, 5 Sep 2012 22:48:25 +0000 (UTC)
Injection-Info	mx04.eternal-september.org; posting-host="bd099084a2caba1d0ebe690afacb9523"; logging-data="25310"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX185ZixUC7gtVliFQHWab/Z4j9cEXSuOrEI="
X-MimeOLE	Produced By Microsoft MimeOLE V6.00.2900.6157
X-RFC2646	Format=Flowed; Original
X-Newsreader	Microsoft Outlook Express 6.00.2900.5931
Cancel-Lock	sha1:Zouh5I2qTzYofl8FSKOSaPNylrY=
X-Priority	3
X-MSMail-Priority	Normal
Xref	csiph.com comp.databases.ms-sqlserver:1255

Show key headers only | 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