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

Re: SQL Cursors

Received	by 10.224.27.14 with SMTP id g14mr395691qac.1.1346884586956; Wed, 05 Sep 2012 15:36:26 -0700 (PDT)
Received	by 10.52.99.8 with SMTP id em8mr18633vdb.16.1346884586935; Wed, 05 Sep 2012 15:36:26 -0700 (PDT)
Path	csiph.com!v102.xanadu-bbs.net!xanadu-bbs.net!news.glorb.com!v8no30503qap.0!news-out.google.com!da15ni51772qab.0!nntp.google.com!b19no34309qas.0!postnews.google.com!glegroupsg2000goo.googlegroups.com!not-for-mail
Newsgroups	comp.databases.ms-sqlserver
Date	Wed, 5 Sep 2012 15:36:26 -0700 (PDT)
In-Reply-To	<k27e25$o1o$1@dont-email.me>
Complaints-To	groups-abuse@google.com
Injection-Info	glegroupsg2000goo.googlegroups.com; posting-host=92.40.104.75; posting-account=dELd-gkAAABehNzDMBP4sfQElk2tFztP
NNTP-Posting-Host	92.40.104.75
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>
User-Agent	G2/1.0
MIME-Version	1.0
Message-ID	<b8a56d24-3706-4798-a7b9-c382a1d96557@googlegroups.com> (permalink)
Subject	Re: SQL Cursors
From	rja.carnegie@gmail.com
Injection-Date	Wed, 05 Sep 2012 22:36:26 +0000
Content-Type	text/plain; charset=ISO-8859-1
Xref	csiph.com comp.databases.ms-sqlserver:1253

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