dynamic numbering of results

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Jarrad (jarradp_at_bpmsf.com)
Date: 03/01/04 

Date: Sun, 29 Feb 2004 22:01:08 -0800

am trying to get an sql query that will auto number rankings for me.
The problem is as follows.

Through a number of queries I can load a temporay table with data e.g

Site_ID,Total_Sales,Sales_Dept,Sales_Chips
I need to end up with
Site_ID,Total_Sales,Ranking_TotalSales,Sales_Dept,Ranking_Sales_Dept,Sales_Chips,Ranking_Sales_Chips
for a number of sites ( note that these aren't the actual fields used).
not sure where to go for this one
have had a look at the knowledge base article 186133 and that didn't help me.
Jarrad

Relevant Pages

  • Re: How To Avoid Cartesian Products?
    ... I will also be looking for ways to include the fire and auto queries you ... Create 2 queries (Fire and Auto) to give you a one-record monthly sum per ... Left Join those queries to your Agents table. ...
    (microsoft.public.access.queries)
  • Re: ** Combo box and subform **
    ... the wizard to set it up. ... You can also base multiple subforms on any other field you place on ... the form and can load. ... It also then makes the queries a little more ...
    (microsoft.public.access.forms)
  • Re: Whassup? was [psnip]
    ... Chrissy wrote: ... Yet again, a refusal to respond honestly to any of my queries, and ... another load of insulting contempt hurled into my face. ... you are causing? ...
    (uk.people.support.depression)
  • Re: JPA slow on remote database queryes
    ... so I hope I can load them so fast too.. ... my local area network, I can load thousands of records with JPA too.. ... queries as well as ones big enough to cause the problem to pick up any ... martin@ | Martin Gregorie ...
    (comp.lang.java.programmer)
  • Re: when is a predicate deteted as undefined
    ... This forces you to use two queries or ... ?- [load], call. ... sense to disable dwim if the input does not come from a terminal. ... toplevel: Potential undefined procedure: abc/0 ...
    (comp.lang.prolog)