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

Re: SQL Cursors

Path	csiph.com!v102.xanadu-bbs.net!xanadu-bbs.net!news.glorb.com!news.netfront.net!not-for-mail
From	sim <simisa@tiscalinet.it>
Newsgroups	comp.databases.ms-sqlserver
Subject	Re: SQL Cursors
Date	Thu, 6 Sep 2012 09:37:05 +0200
Organization	Netfront http://www.netfront.net/
Lines	38
Message-ID	<k29jr1$2c9k$1@adenine.netfront.net> (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> <k28lus$t25$1@dont-email.me>
NNTP-Posting-Host	78.134.2.216
Mime-Version	1.0
Content-Type	text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding	8bit
X-Trace	adenine.netfront.net 1346917026 78132 78.134.2.216 (6 Sep 2012 07:37:06 GMT)
X-Complaints-To	news@netfront.net
NNTP-Posting-Date	Thu, 6 Sep 2012 07:37:06 +0000 (UTC)
User-Agent	Unison/2.1.9
Xref	csiph.com comp.databases.ms-sqlserver:1260

Show key headers only | View raw

On 2012-09-05 22:44:22 +0000, Bob Barrows said:

> 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

I used the rank from DTS in field NUM…the solution from Bob for me it's 
perfect !

Now i have the Agent's Hit Parade :-) with delta value from one agent 
to the top 1 and a ranked list.

Very happy, thanks again.


--- Posted via news://freenews.netfront.net/ - Complaints to news@netfront.net ---

Back to comp.databases.ms-sqlserver | Previous | Next — Previous 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