Re: Getting an average ..

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: Jacco Schalkwijk (jacco.please.reply_at_to.newsgroups.mvps.org.invalid)
Date: 12/08/04 

Date: Wed, 8 Dec 2004 10:59:49 -0000

SELECT Licence, AVG(Transcount)
FROM your_table
WHERE recievedDate >= '20040901' AND recievedDate < '20041201'
GROUP BY Licence 

-- 
Jacco Schalkwijk
SQL Server MVP
"Peter Newman" <PeterNewman@discussions.microsoft.com> wrote in message 
news:4839EB25-A03A-4D92-9E33-59C01647F0A8@microsoft.com...
>i have a very large table that contains banking header files for our 
>clients.
> In the header file there is a count of the number of transactions. what i
> would like to do is get an average count of the number of transaction put
> through for september / october & Nov 2004.  the table is to large to 
> create
> ddl code, but the relevent fields are as follows
>
> Licence   varchar 6
> Transcount    int
> recievedDate  datetime
>
> hopeful result
>
> Licence          Average
>
>  111111          22
>  222222        324
>
> etc
>
> I appricate that i am not supplying code and data, but any suggestions 
> would
> be most welcome

Relevant Pages

  • Re: Photo Licence renewal
    ... I don't really want to be without a licence for both these transactions (I frequently need it to hire a car) but if I don't change the address, I won't get the renewal reminder. ... The contact number for Driver Licensing Enquiries is 0870 240 0009 or you can email them direct on drivers.dvla@xxxxxxxxxxxx ...
    (uk.rec.driving)
  • Re: Photo Licence renewal
    ... I don't really want to be without a licence for both these transactions (I frequently need it to hire a car) but if I don't change the address, I won't get the renewal reminder. ... - Scott Adams ...
    (uk.rec.driving)
  • Re: Photo Licence renewal
    ... I don't really want to be without a licence for both these transactions ... frequently need it to hire a car) but if I don't change the address, ...
    (uk.rec.driving)
  • Re: Photo Licence renewal
    ... I don't really want to be without a licence for both these transactions (I ... frequently need it to hire a car) but if I don't change the address, ... I doubt any 'Civil Servant' ever considered such an idea. ...
    (uk.rec.driving)