Re: percentages of top 10 tallies

From: Tom Moreau (tom_at_dont.spam.me.cips.ca)
Date: 10/06/04 

Date: Wed, 6 Oct 2004 12:39:48 -0400

Hugo is using what is called a derived table. You must specify an alias -
in this case, T - or you will get an error. 

-- 
Tom
---------------------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com
"Mortar" <a@b.com> wrote in message
news:41641441.5804890@nntp.wlfdle.phub.net.cable.rogers.com...
thanks for the help guys.
a quick question: what is the capital T for in Hugo's query? It seems
I can change it to anything and it still works, but if I remove it, it
doesn't.
On Wed, 6 Oct 2004 08:33:25 -0400, "Tom Moreau"
<tom@dont.spam.me.cips.ca> wrote:
>OK, got it.  My solution uses less IO and yours has the lowest query cost.
>The Orders table in Northwind is quite small.  I'm curious as to what the
>performance would be with a larger table.
>
>-- 
>Tom
>
>---------------------------------------------------------------
>Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
>SQL Server MVP
>Columnist, SQL Server Professional
>Toronto, ON Canada
>www.pinnaclepublishing.com
>
>
>"Hugo Kornelis" <hugo@pe_NO_rFact.in_SPAM_fo> wrote in message
>news:fqo7m090v69aauutqfm8vg2tusv828v8n4@4ax.com...
>On Wed, 6 Oct 2004 07:36:45 -0400, Tom Moreau wrote:
>
>>Interesting.  I don't get the same percentages as you:
>
>Hi Tom,
>
>That's because Steve uses with ties and you don't.
>
>Best, Hugo
>-- 
>
>(Remove _NO_ and _SPAM_ to get my e-mail address)
>

Relevant Pages

  • Re: One Web Service updates SQL, the other cant
    ... Here is the dialog between Tom and I. ... Columnist, SQL Server Professional ... "Steve Ricketts" wrote in message ... I guess its because this is my first Web Service and I> just used the access methods I knew. ...
    (microsoft.public.vb.database.ado)
  • Re: SELECT by quarter of hour
    ... It should be much faster than the alternatives because it costs only a ... BG, SQL Server MVP ... "Tom Moreau" wrote in message ... > "Tom Moreau" wrote in message ...
    (microsoft.public.sqlserver.programming)
  • Re: How to clear memory usage after executing queries ?
    ... Uh, Tom, if the pages that have been the cache the longest are constantly ... SQL Server will push pages out of memory only if it has to read new ... > pages into memory. ...
    (microsoft.public.sqlserver.programming)
  • Re: Can Indexes effect Bulk Insert/Update Operations
    ... Siz wrote: ... > Thanks Tom, ... > Let me clear you the current scenario. ... >> Columnist, SQL Server Professional ...
    (microsoft.public.sqlserver.programming)
  • Re: TRIGGER NEEDED SHOWING CREDIT CARD AUTH
    ... Hugo - Don't rightly know if a view would work for us because each table is ... separate database and instance of SQL Server. ... What this trigger would do is write "Y" to the credit card authorized field ...
    (microsoft.public.sqlserver.programming)