|
|
Posted by Roy Harvey on 11/20/06 21:17
First, it appears from the test data that it already has filtered down
to ONLY the "top 25 by week", so the code below assumes that. If the
top 25 has to be drived on the fly things change a good bit.
This might help you get to what you need.
SELECT WeekID,
BeginDate,
EndDate,
Region,
Unit,
(SELECT count(*)
FROM GPFCount2 as B
WHERE A.Unit = B.Unit
AND B.WeekID BETWEEN A.WeekID - 4 and B.WeekID) as
WeekCount
FROM GPFCount2 as A
Note that a problem with the code you provided is the line in the
subquery:
Where WeekID Between WeekID - 4 and WeekID
Without any qualifiers all three references to WeeekID are from the
same row, which is not much of a test. See the difference between
that and the equivelent line in the version
Roy Harvey
Beacon Falls, CT
On 20 Nov 2006 11:45:03 -0800, "Jennifer" <J.Evans.1970@gmail.com>
wrote:
>I have a table that I am trying to do a query on.
>
>Table is named GPFCount2.
>
>CREATE TABLE [GPFCount2] (
> [WeekID] [int] NULL ,
> [BeginDate] [datetime] NULL ,
> [EndDate] [datetime] NULL ,
> [Region] [int] NULL ,
> [Unit] [int] NULL ,
> [GPFCount] [int] NULL
>) ON [PRIMARY]
>
>For example:
>30 ,'11/11/2006 15:00:00','11/18/2006 14:59:59', 8000 , 192 , 14
>
>The above says that unit 92 had 14 GPFs during the week of 11/11/2006
>3PM to 11/18/2006 2:59:59 PM. Unit 192 is part of region 8000. The
>time period covered was week 30.
>
>What I want to see is the number of times the unit has been in the top
>25 list over the last 5 weeks. Unit 192 is in the top 25 list for
>Weeks, 30, 29, 28, and 26.
>
>So my result set for this unit should be:
>30 ,'11/11/2006 15:00:00','11/18/2006 14:59:59', 8000 , 192 , 14, 4
>
>The 4 being the number of times in the last 5 weeks that unit 192 was
>in the top 25.
>
>And then for Week 29, assuming unit 192 is in the top 25 for weeks
>29,28 and 26 (and not 27 or 25), then it would be 3. And the results
>from the query would be:
>29 ,'11/04/2006 15:00:00','11/11/2006 14:59:59', 8000 , 192 , 14, 3
>
>This is the query I was working with, but it's not working. I'm not
>too sure how to make this work.
>
>Select A.weekid,
> A.begindate,
> A.EndDate,
> A.region,
> A.unit,
> A.gpfcount,
> B.UnitCount
>>From gpfcount2 A
>Join
> (Select WeekID,
> Unit,
> Count(Unit) UnitCount
> From gpfcount2
> Where WeekID Between WeekID - 4 and WeekID
> Group By Unit,WeekID
> ) B
>On A.Unit = B.Unit
>
>Thanks,
>Jennifer
>
>INSERTS FOR TABLE (There are inserts only for weeks 30 through 20 for
>brevity's sake):
>
>insert into GPFCount2 select 30 ,'11/11/2006 15:00:00','11/18/2006
>14:59:59', 4000 , 898 , 22
>insert into GPFCount2 select 30 ,'11/11/2006 15:00:00','11/18/2006
>14:59:59', 8000 , 777 , 21
>insert into GPFCount2 select 30 ,'11/11/2006 15:00:00','11/18/2006
>14:59:59', 9000 , 846 , 21
>insert into GPFCount2 select 30 ,'11/11/2006 15:00:00','11/18/2006
>14:59:59', 8000 , 907 , 20
>insert into GPFCount2 select 30 ,'11/11/2006 15:00:00','11/18/2006
>14:59:59', 9000 , 608 , 18
>insert into GPFCount2 select 30 ,'11/11/2006 15:00:00','11/18/2006
>14:59:59', 4000 , 40 , 17
>insert into GPFCount2 select 30 ,'11/11/2006 15:00:00','11/18/2006
>14:59:59', 8000 , 107 , 17
>insert into GPFCount2 select 30 ,'11/11/2006 15:00:00','11/18/2006
>14:59:59', 4000 , 723 , 17
>insert into GPFCount2 select 30 ,'11/11/2006 15:00:00','11/18/2006
>14:59:59', 8000 , 60 , 15
>insert into GPFCount2 select 30 ,'11/11/2006 15:00:00','11/18/2006
>14:59:59', 4000 , 78 , 15
>insert into GPFCount2 select 30 ,'11/11/2006 15:00:00','11/18/2006
>14:59:59', 8000 , 300 , 15
>insert into GPFCount2 select 30 ,'11/11/2006 15:00:00','11/18/2006
>14:59:59', 8000 , 317 , 15
>insert into GPFCount2 select 30 ,'11/11/2006 15:00:00','11/18/2006
>14:59:59', 8000 , 658 , 15
>insert into GPFCount2 select 30 ,'11/11/2006 15:00:00','11/18/2006
>14:59:59', 8000 , 719 , 15
>insert into GPFCount2 select 30 ,'11/11/2006 15:00:00','11/18/2006
>14:59:59', 8000 , 782 , 15
>insert into GPFCount2 select 30 ,'11/11/2006 15:00:00','11/18/2006
>14:59:59', 8000 , 2 , 14
>insert into GPFCount2 select 30 ,'11/11/2006 15:00:00','11/18/2006
>14:59:59', 8000 , 192 , 14
>insert into GPFCount2 select 30 ,'11/11/2006 15:00:00','11/18/2006
>14:59:59', 8000 , 362 , 14
>insert into GPFCount2 select 30 ,'11/11/2006 15:00:00','11/18/2006
>14:59:59', 8000 , 456 , 14
>insert into GPFCount2 select 30 ,'11/11/2006 15:00:00','11/18/2006
>14:59:59', 4000 , 607 , 14
>insert into GPFCount2 select 30 ,'11/11/2006 15:00:00','11/18/2006
>14:59:59', 9000 , 609 , 14
>insert into GPFCount2 select 30 ,'11/11/2006 15:00:00','11/18/2006
>14:59:59', 7000 , 715 , 14
>insert into GPFCount2 select 30 ,'11/11/2006 15:00:00','11/18/2006
>14:59:59', 8000 , 182 , 13
>insert into GPFCount2 select 30 ,'11/11/2006 15:00:00','11/18/2006
>14:59:59', 4000 , 712 , 13
>insert into GPFCount2 select 30 ,'11/11/2006 15:00:00','11/18/2006
>14:59:59', 4000 , 588 , 12
>insert into GPFCount2 select 29 ,'11/04/2006 15:00:00','11/11/2006
>14:59:59', 8000 , 191 , 19
>insert into GPFCount2 select 29 ,'11/04/2006 15:00:00','11/11/2006
>14:59:59', 4000 , 450 , 17
>insert into GPFCount2 select 29 ,'11/04/2006 15:00:00','11/11/2006
>14:59:59', 4000 , 498 , 17
>insert into GPFCount2 select 29 ,'11/04/2006 15:00:00','11/11/2006
>14:59:59', 8000 , 192 , 16
>insert into GPFCount2 select 29 ,'11/04/2006 15:00:00','11/11/2006
>14:59:59', 8000 , 445 , 16
>insert into GPFCount2 select 29 ,'11/04/2006 15:00:00','11/11/2006
>14:59:59', 9000 , 742 , 16
>insert into GPFCount2 select 29 ,'11/04/2006 15:00:00','11/11/2006
>14:59:59', 4000 , 532 , 15
>insert into GPFCount2 select 29 ,'11/04/2006 15:00:00','11/11/2006
>14:59:59', 9000 , 540 , 14
>insert into GPFCount2 select 29 ,'11/04/2006 15:00:00','11/11/2006
>14:59:59', 7000 , 715 , 14
>insert into GPFCount2 select 29 ,'11/04/2006 15:00:00','11/11/2006
>14:59:59', 9000 , 184 , 13
>insert into GPFCount2 select 29 ,'11/04/2006 15:00:00','11/11/2006
>14:59:59', 8000 , 288 , 12
>insert into GPFCount2 select 29 ,'11/04/2006 15:00:00','11/11/2006
>14:59:59', 8000 , 313 , 12
>insert into GPFCount2 select 29 ,'11/04/2006 15:00:00','11/11/2006
>14:59:59', 4000 , 78 , 10
>insert into GPFCount2 select 29 ,'11/04/2006 15:00:00','11/11/2006
>14:59:59', 7000 , 598 , 10
>insert into GPFCount2 select 29 ,'11/04/2006 15:00:00','11/11/2006
>14:59:59', 7000 , 610 , 10
>insert into GPFCount2 select 29 ,'11/04/2006 15:00:00','11/11/2006
>14:59:59', 8000 , 840 , 10
>insert into GPFCount2 select 29 ,'11/04/2006 15:00:00','11/11/2006
>14:59:59', 8000 , 918 , 10
>insert into GPFCount2 select 29 ,'11/04/2006 15:00:00','11/11/2006
>14:59:59', 7000 , 221 , 9
>insert into GPFCount2 select 29 ,'11/04/2006 15:00:00','11/11/2006
>14:59:59', 7000 , 452 , 9
>insert into GPFCount2 select 29 ,'11/04/2006 15:00:00','11/11/2006
>14:59:59', 8000 , 594 , 9
>insert into GPFCount2 select 29 ,'11/04/2006 15:00:00','11/11/2006
>14:59:59', 9000 , 608 , 9
>insert into GPFCount2 select 29 ,'11/04/2006 15:00:00','11/11/2006
>14:59:59', 9000 , 706 , 9
>insert into GPFCount2 select 29 ,'11/04/2006 15:00:00','11/11/2006
>14:59:59', 4000 , 35 , 8
>insert into GPFCount2 select 29 ,'11/04/2006 15:00:00','11/11/2006
>14:59:59', 8000 , 112 , 8
>insert into GPFCount2 select 29 ,'11/04/2006 15:00:00','11/11/2006
>14:59:59', 7000 , 218 , 8
>insert into GPFCount2 select 28 ,'10/28/2006 15:00:00','11/04/2006
>14:59:59', 4000 , 542 , 30
>insert into GPFCount2 select 28 ,'10/28/2006 15:00:00','11/04/2006
>14:59:59', 4000 , 35 , 26
>insert into GPFCount2 select 28 ,'10/28/2006 15:00:00','11/04/2006
>14:59:59', 8000 , 695 , 26
>insert into GPFCount2 select 28 ,'10/28/2006 15:00:00','11/04/2006
>14:59:59', 8000 , 924 , 26
>insert into GPFCount2 select 28 ,'10/28/2006 15:00:00','11/04/2006
>14:59:59', 4000 , 533 , 25
>insert into GPFCount2 select 28 ,'10/28/2006 15:00:00','11/04/2006
>14:59:59', 4000 , 878 , 18
>insert into GPFCount2 select 28 ,'10/28/2006 15:00:00','11/04/2006
>14:59:59', 8000 , 12 , 17
>insert into GPFCount2 select 28 ,'10/28/2006 15:00:00','11/04/2006
>14:59:59', 4000 , 139 , 17
>insert into GPFCount2 select 28 ,'10/28/2006 15:00:00','11/04/2006
>14:59:59', 8000 , 698 , 17
>insert into GPFCount2 select 28 ,'10/28/2006 15:00:00','11/04/2006
>14:59:59', 4000 , 458 , 16
>insert into GPFCount2 select 28 ,'10/28/2006 15:00:00','11/04/2006
>14:59:59', 8000 , 528 , 16
>insert into GPFCount2 select 28 ,'10/28/2006 15:00:00','11/04/2006
>14:59:59', 8000 , 740 , 16
>insert into GPFCount2 select 28 ,'10/28/2006 15:00:00','11/04/2006
>14:59:59', 4000 , 911 , 16
>insert into GPFCount2 select 28 ,'10/28/2006 15:00:00','11/04/2006
>14:59:59', 4000 , 778 , 14
>insert into GPFCount2 select 28 ,'10/28/2006 15:00:00','11/04/2006
>14:59:59', 8000 , 192 , 13
>insert into GPFCount2 select 28 ,'10/28/2006 15:00:00','11/04/2006
>14:59:59', 4000 , 550 , 13
>insert into GPFCount2 select 28 ,'10/28/2006 15:00:00','11/04/2006
>14:59:59', 9000 , 738 , 13
>insert into GPFCount2 select 28 ,'10/28/2006 15:00:00','11/04/2006
>14:59:59', 8000 , 2 , 12
>insert into GPFCount2 select 28 ,'10/28/2006 15:00:00','11/04/2006
>14:59:59', 9000 , 176 , 12
>insert into GPFCount2 select 28 ,'10/28/2006 15:00:00','11/04/2006
>14:59:59', 4000 , 450 , 12
>insert into GPFCount2 select 28 ,'10/28/2006 15:00:00','11/04/2006
>14:59:59', 8000 , 571 , 12
>insert into GPFCount2 select 28 ,'10/28/2006 15:00:00','11/04/2006
>14:59:59', 7000 , 715 , 12
>insert into GPFCount2 select 28 ,'10/28/2006 15:00:00','11/04/2006
>14:59:59', 8000 , 840 , 12
>insert into GPFCount2 select 28 ,'10/28/2006 15:00:00','11/04/2006
>14:59:59', 9000 , 875 , 12
>insert into GPFCount2 select 28 ,'10/28/2006 15:00:00','11/04/2006
>14:59:59', 8000 , 925 , 12
>insert into GPFCount2 select 27 ,'10/21/2006 15:00:00','10/28/2006
>14:59:59', 8000 , 123 , 34
>insert into GPFCount2 select 27 ,'10/21/2006 15:00:00','10/28/2006
>14:59:59', 8000 , 192 , 32
>insert into GPFCount2 select 27 ,'10/21/2006 15:00:00','10/28/2006
>14:59:59', 4000 , 264 , 19
>insert into GPFCount2 select 27 ,'10/21/2006 15:00:00','10/28/2006
>14:59:59', 4000 , 601 , 18
>insert into GPFCount2 select 27 ,'10/21/2006 15:00:00','10/28/2006
>14:59:59', 9000 , 875 , 17
>insert into GPFCount2 select 27 ,'10/21/2006 15:00:00','10/28/2006
>14:59:59', 4000 , 550 , 16
>insert into GPFCount2 select 27 ,'10/21/2006 15:00:00','10/28/2006
>14:59:59', 7000 , 761 , 15
>insert into GPFCount2 select 27 ,'10/21/2006 15:00:00','10/28/2006
>14:59:59', 4000 , 141 , 14
>insert into GPFCount2 select 27 ,'10/21/2006 15:00:00','10/28/2006
>14:59:59', 8000 , 3 , 11
>insert into GPFCount2 select 27 ,'10/21/2006 15:00:00','10/28/2006
>14:59:59', 4000 , 745 , 11
>insert into GPFCount2 select 27 ,'10/21/2006 15:00:00','10/28/2006
>14:59:59', 4000 , 750 , 11
>insert into GPFCount2 select 27 ,'10/21/2006 15:00:00','10/28/2006
>14:59:59', 9000 , 816 , 11
>insert into GPFCount2 select 27 ,'10/21/2006 15:00:00','10/28/2006
>14:59:59', 8000 , 190 , 10
>insert into GPFCount2 select 27 ,'10/21/2006 15:00:00','10/28/2006
>14:59:59', 9000 , 506 , 10
>insert into GPFCount2 select 27 ,'10/21/2006 15:00:00','10/28/2006
>14:59:59', 4000 , 533 , 10
>insert into GPFCount2 select 27 ,'10/21/2006 15:00:00','10/28/2006
>14:59:59', 8000 , 899 , 10
>insert into GPFCount2 select 27 ,'10/21/2006 15:00:00','10/28/2006
>14:59:59', 4000 , 903 , 10
>insert into GPFCount2 select 27 ,'10/21/2006 15:00:00','10/28/2006
>14:59:59', 8000 , 175 , 9
>insert into GPFCount2 select 27 ,'10/21/2006 15:00:00','10/28/2006
>14:59:59', 8000 , 300 , 9
>insert into GPFCount2 select 27 ,'10/21/2006 15:00:00','10/28/2006
>14:59:59', 8000 , 311 , 9
>insert into GPFCount2 select 27 ,'10/21/2006 15:00:00','10/28/2006
>14:59:59', 9000 , 397 , 9
>insert into GPFCount2 select 27 ,'10/21/2006 15:00:00','10/28/2006
>14:59:59', 4000 , 450 , 9
>insert into GPFCount2 select 27 ,'10/21/2006 15:00:00','10/28/2006
>14:59:59', 4000 , 597 , 9
>insert into GPFCount2 select 27 ,'10/21/2006 15:00:00','10/28/2006
>14:59:59', 9000 , 743 , 9
>insert into GPFCount2 select 27 ,'10/21/2006 15:00:00','10/28/2006
>14:59:59', 4000 , 878 , 9
>insert into GPFCount2 select 26 ,'10/14/2006 15:00:00','10/21/2006
>14:59:59', 8000 , 782 , 20
>insert into GPFCount2 select 26 ,'10/14/2006 15:00:00','10/21/2006
>14:59:59', 8000 , 192 , 19
>insert into GPFCount2 select 26 ,'10/14/2006 15:00:00','10/21/2006
>14:59:59', 8000 , 317 , 18
>insert into GPFCount2 select 26 ,'10/14/2006 15:00:00','10/21/2006
>14:59:59', 8000 , 60 , 16
>insert into GPFCount2 select 26 ,'10/14/2006 15:00:00','10/21/2006
>14:59:59', 8000 , 695 , 16
>insert into GPFCount2 select 26 ,'10/14/2006 15:00:00','10/21/2006
>14:59:59', 8000 , 85 , 15
>insert into GPFCount2 select 26 ,'10/14/2006 15:00:00','10/21/2006
>14:59:59', 8000 , 190 , 14
>insert into GPFCount2 select 26 ,'10/14/2006 15:00:00','10/21/2006
>14:59:59', 4000 , 592 , 13
>insert into GPFCount2 select 26 ,'10/14/2006 15:00:00','10/21/2006
>14:59:59', 4000 , 439 , 12
>insert into GPFCount2 select 26 ,'10/14/2006 15:00:00','10/21/2006
>14:59:59', 8000 , 576 , 12
>insert into GPFCount2 select 26 ,'10/14/2006 15:00:00','10/21/2006
>14:59:59', 8000 , 349 , 11
>insert into GPFCount2 select 26 ,'10/14/2006 15:00:00','10/21/2006
>14:59:59', 9000 , 509 , 11
>insert into GPFCount2 select 26 ,'10/14/2006 15:00:00','10/21/2006
>14:59:59', 9000 , 563 , 11
>insert into GPFCount2 select 26 ,'10/14/2006 15:00:00','10/21/2006
>14:59:59', 9000 , 816 , 11
>insert into GPFCount2 select 26 ,'10/14/2006 15:00:00','10/21/2006
>14:59:59', 8000 , 280 , 10
>insert into GPFCount2 select 26 ,'10/14/2006 15:00:00','10/21/2006
>14:59:59', 8000 , 123 , 9
>insert into GPFCount2 select 26 ,'10/14/2006 15:00:00','10/21/2006
>14:59:59', 9000 , 337 , 9
>insert into GPFCount2 select 26 ,'10/14/2006 15:00:00','10/21/2006
>14:59:59', 8000 , 388 , 9
>insert into GPFCount2 select 26 ,'10/14/2006 15:00:00','10/21/2006
>14:59:59', 4000 , 601 , 9
>insert into GPFCount2 select 26 ,'10/14/2006 15:00:00','10/21/2006
>14:59:59', 8000 , 698 , 9
>insert into GPFCount2 select 26 ,'10/14/2006 15:00:00','10/21/2006
>14:59:59', 7000 , 715 , 9
>insert into GPFCount2 select 26 ,'10/14/2006 15:00:00','10/21/2006
>14:59:59', 9000 , 812 , 9
>insert into GPFCount2 select 26 ,'10/14/2006 15:00:00','10/21/2006
>14:59:59', 9000 , 832 , 9
>insert into GPFCount2 select 26 ,'10/14/2006 15:00:00','10/21/2006
>14:59:59', 9000 , 368 , 8
>insert into GPFCount2 select 26 ,'10/14/2006 15:00:00','10/21/2006
>14:59:59', 4000 , 490 , 8
>insert into GPFCount2 select 25 ,'10/07/2006 15:00:00','10/14/2006
>14:59:59', 8000 , 777 , 26
>insert into GPFCount2 select 25 ,'10/07/2006 15:00:00','10/14/2006
>14:59:59', 8000 , 907 , 22
>insert into GPFCount2 select 25 ,'10/07/2006 15:00:00','10/14/2006
>14:59:59', 4000 , 597 , 18
>insert into GPFCount2 select 25 ,'10/07/2006 15:00:00','10/14/2006
>14:59:59', 8000 , 285 , 17
>insert into GPFCount2 select 25 ,'10/07/2006 15:00:00','10/14/2006
>14:59:59', 8000 , 396 , 17
>insert into GPFCount2 select 25 ,'10/07/2006 15:00:00','10/14/2006
>14:59:59', 4000 , 439 , 17
>insert into GPFCount2 select 25 ,'10/07/2006 15:00:00','10/14/2006
>14:59:59', 4000 , 450 , 17
>insert into GPFCount2 select 25 ,'10/07/2006 15:00:00','10/14/2006
>14:59:59', 9000 , 781 , 17
>insert into GPFCount2 select 25 ,'10/07/2006 15:00:00','10/14/2006
>14:59:59', 4000 , 898 , 13
>insert into GPFCount2 select 25 ,'10/07/2006 15:00:00','10/14/2006
>14:59:59', 8000 , 906 , 13
>insert into GPFCount2 select 25 ,'10/07/2006 15:00:00','10/14/2006
>14:59:59', 8000 , 12 , 12
>insert into GPFCount2 select 25 ,'10/07/2006 15:00:00','10/14/2006
>14:59:59', 4000 , 745 , 12
>insert into GPFCount2 select 25 ,'10/07/2006 15:00:00','10/14/2006
>14:59:59', 9000 , 748 , 12
>insert into GPFCount2 select 25 ,'10/07/2006 15:00:00','10/14/2006
>14:59:59', 8000 , 840 , 12
>insert into GPFCount2 select 25 ,'10/07/2006 15:00:00','10/14/2006
>14:59:59', 9000 , 875 , 12
>insert into GPFCount2 select 25 ,'10/07/2006 15:00:00','10/14/2006
>14:59:59', 4000 , 889 , 12
>insert into GPFCount2 select 25 ,'10/07/2006 15:00:00','10/14/2006
>14:59:59', 8000 , 192 , 11
>insert into GPFCount2 select 25 ,'10/07/2006 15:00:00','10/14/2006
>14:59:59', 8000 , 749 , 11
>insert into GPFCount2 select 25 ,'10/07/2006 15:00:00','10/14/2006
>14:59:59', 8000 , 755 , 11
>insert into GPFCount2 select 25 ,'10/07/2006 15:00:00','10/14/2006
>14:59:59', 8000 , 107 , 10
>insert into GPFCount2 select 25 ,'10/07/2006 15:00:00','10/14/2006
>14:59:59', 4000 , 443 , 10
>insert into GPFCount2 select 25 ,'10/07/2006 15:00:00','10/14/2006
>14:59:59', 9000 , 540 , 10
>insert into GPFCount2 select 25 ,'10/07/2006 15:00:00','10/14/2006
>14:59:59', 8000 , 595 , 10
>insert into GPFCount2 select 25 ,'10/07/2006 15:00:00','10/14/2006
>14:59:59', 8000 , 839 , 10
>insert into GPFCount2 select 25 ,'10/07/2006 15:00:00','10/14/2006
>14:59:59', 8000 , 190 , 9
>insert into GPFCount2 select 24 ,'09/30/2006 15:00:00','10/07/2006
>14:59:59', 8000 , 907 , 29
>insert into GPFCount2 select 24 ,'09/30/2006 15:00:00','10/07/2006
>14:59:59', 8000 , 12 , 25
>insert into GPFCount2 select 24 ,'09/30/2006 15:00:00','10/07/2006
>14:59:59', 8000 , 695 , 17
>insert into GPFCount2 select 24 ,'09/30/2006 15:00:00','10/07/2006
>14:59:59', 8000 , 777 , 17
>insert into GPFCount2 select 24 ,'09/30/2006 15:00:00','10/07/2006
>14:59:59', 4000 , 778 , 17
>insert into GPFCount2 select 24 ,'09/30/2006 15:00:00','10/07/2006
>14:59:59', 8000 , 788 , 17
>insert into GPFCount2 select 24 ,'09/30/2006 15:00:00','10/07/2006
>14:59:59', 4000 , 439 , 16
>insert into GPFCount2 select 24 ,'09/30/2006 15:00:00','10/07/2006
>14:59:59', 8000 , 566 , 16
>insert into GPFCount2 select 24 ,'09/30/2006 15:00:00','10/07/2006
>14:59:59', 4000 , 723 , 16
>insert into GPFCount2 select 24 ,'09/30/2006 15:00:00','10/07/2006
>14:59:59', 7000 , 774 , 16
>insert into GPFCount2 select 24 ,'09/30/2006 15:00:00','10/07/2006
>14:59:59', 4000 , 40 , 15
>insert into GPFCount2 select 24 ,'09/30/2006 15:00:00','10/07/2006
>14:59:59', 8000 , 396 , 14
>insert into GPFCount2 select 24 ,'09/30/2006 15:00:00','10/07/2006
>14:59:59', 4000 , 607 , 14
>insert into GPFCount2 select 24 ,'09/30/2006 15:00:00','10/07/2006
>14:59:59', 8000 , 175 , 13
>insert into GPFCount2 select 24 ,'09/30/2006 15:00:00','10/07/2006
>14:59:59', 8000 , 336 , 12
>insert into GPFCount2 select 24 ,'09/30/2006 15:00:00','10/07/2006
>14:59:59', 4000 , 498 , 12
>insert into GPFCount2 select 24 ,'09/30/2006 15:00:00','10/07/2006
>14:59:59', 9000 , 781 , 12
>insert into GPFCount2 select 24 ,'09/30/2006 15:00:00','10/07/2006
>14:59:59', 8000 , 829 , 12
>insert into GPFCount2 select 24 ,'09/30/2006 15:00:00','10/07/2006
>14:59:59', 9000 , 140 , 11
>insert into GPFCount2 select 24 ,'09/30/2006 15:00:00','10/07/2006
>14:59:59', 8000 , 311 , 11
>insert into GPFCount2 select 24 ,'09/30/2006 15:00:00','10/07/2006
>14:59:59', 9000 , 448 , 11
>insert into GPFCount2 select 24 ,'09/30/2006 15:00:00','10/07/2006
>14:59:59', 4000 , 514 , 11
>insert into GPFCount2 select 24 ,'09/30/2006 15:00:00','10/07/2006
>14:59:59', 4000 , 791 , 11
>insert into GPFCount2 select 24 ,'09/30/2006 15:00:00','10/07/2006
>14:59:59', 4000 , 139 , 10
>insert into GPFCount2 select 24 ,'09/30/2006 15:00:00','10/07/2006
>14:59:59', 4000 , 551 , 10
>insert into GPFCount2 select 23 ,'09/23/2006 15:00:00','09/30/2006
>14:59:59', 8000 , 788 , 33
>insert into GPFCount2 select 23 ,'09/23/2006 15:00:00','09/30/2006
>14:59:59', 4000 , 723 , 24
>insert into GPFCount2 select 23 ,'09/23/2006 15:00:00','09/30/2006
>14:59:59', 8000 , 192 , 18
>insert into GPFCount2 select 23 ,'09/23/2006 15:00:00','09/30/2006
>14:59:59', 9000 , 397 , 15
>insert into GPFCount2 select 23 ,'09/23/2006 15:00:00','09/30/2006
>14:59:59', 8000 , 166 , 13
>insert into GPFCount2 select 23 ,'09/23/2006 15:00:00','09/30/2006
>14:59:59', 4000 , 498 , 13
>insert into GPFCount2 select 23 ,'09/23/2006 15:00:00','09/30/2006
>14:59:59', 8000 , 695 , 13
>insert into GPFCount2 select 23 ,'09/23/2006 15:00:00','09/30/2006
>14:59:59', 4000 , 898 , 13
>insert into GPFCount2 select 23 ,'09/23/2006 15:00:00','09/30/2006
>14:59:59', 4000 , 264 , 12
>insert into GPFCount2 select 23 ,'09/23/2006 15:00:00','09/30/2006
>14:59:59', 4000 , 601 , 12
>insert into GPFCount2 select 23 ,'09/23/2006 15:00:00','09/30/2006
>14:59:59', 4000 , 694 , 12
>insert into GPFCount2 select 23 ,'09/23/2006 15:00:00','09/30/2006
>14:59:59', 8000 , 396 , 11
>insert into GPFCount2 select 23 ,'09/23/2006 15:00:00','09/30/2006
>14:59:59', 9000 , 708 , 11
>insert into GPFCount2 select 23 ,'09/23/2006 15:00:00','09/30/2006
>14:59:59', 4000 , 733 , 11
>insert into GPFCount2 select 23 ,'09/23/2006 15:00:00','09/30/2006
>14:59:59', 4000 , 439 , 10
>insert into GPFCount2 select 23 ,'09/23/2006 15:00:00','09/30/2006
>14:59:59', 8000 , 527 , 10
>insert into GPFCount2 select 23 ,'09/23/2006 15:00:00','09/30/2006
>14:59:59', 4000 , 550 , 10
>insert into GPFCount2 select 23 ,'09/23/2006 15:00:00','09/30/2006
>14:59:59', 8000 , 190 , 9
>insert into GPFCount2 select 23 ,'09/23/2006 15:00:00','09/30/2006
>14:59:59', 7000 , 217 , 9
>insert into GPFCount2 select 23 ,'09/23/2006 15:00:00','09/30/2006
>14:59:59', 8000 , 399 , 9
>insert into GPFCount2 select 23 ,'09/23/2006 15:00:00','09/30/2006
>14:59:59', 9000 , 425 , 9
>insert into GPFCount2 select 23 ,'09/23/2006 15:00:00','09/30/2006
>14:59:59', 9000 , 609 , 9
>insert into GPFCount2 select 23 ,'09/23/2006 15:00:00','09/30/2006
>14:59:59', 9000 , 728 , 9
>insert into GPFCount2 select 23 ,'09/23/2006 15:00:00','09/30/2006
>14:59:59', 8000 , 787 , 9
>insert into GPFCount2 select 23 ,'09/23/2006 15:00:00','09/30/2006
>14:59:59', 4000 , 131 , 8
>insert into GPFCount2 select 22 ,'09/16/2006 15:00:00','09/23/2006
>14:59:59', 9000 , 604 , 28
>insert into GPFCount2 select 22 ,'09/16/2006 15:00:00','09/23/2006
>14:59:59', 7000 , 223 , 18
>insert into GPFCount2 select 22 ,'09/16/2006 15:00:00','09/23/2006
>14:59:59', 4000 , 723 , 18
>insert into GPFCount2 select 22 ,'09/16/2006 15:00:00','09/23/2006
>14:59:59', 9000 , 724 , 17
>insert into GPFCount2 select 22 ,'09/16/2006 15:00:00','09/23/2006
>14:59:59', 7000 , 598 , 15
>insert into GPFCount2 select 22 ,'09/16/2006 15:00:00','09/23/2006
>14:59:59', 8000 , 3 , 14
>insert into GPFCount2 select 22 ,'09/16/2006 15:00:00','09/23/2006
>14:59:59', 4000 , 550 , 13
>insert into GPFCount2 select 22 ,'09/16/2006 15:00:00','09/23/2006
>14:59:59', 7000 , 619 , 13
>insert into GPFCount2 select 22 ,'09/16/2006 15:00:00','09/23/2006
>14:59:59', 9000 , 397 , 12
>insert into GPFCount2 select 22 ,'09/16/2006 15:00:00','09/23/2006
>14:59:59', 9000 , 540 , 12
>insert into GPFCount2 select 22 ,'09/16/2006 15:00:00','09/23/2006
>14:59:59', 4000 , 601 , 12
>insert into GPFCount2 select 22 ,'09/16/2006 15:00:00','09/23/2006
>14:59:59', 4000 , 490 , 11
>insert into GPFCount2 select 22 ,'09/16/2006 15:00:00','09/23/2006
>14:59:59', 4000 , 498 , 11
>insert into GPFCount2 select 22 ,'09/16/2006 15:00:00','09/23/2006
>14:59:59', 8000 , 658 , 11
>insert into GPFCount2 select 22 ,'09/16/2006 15:00:00','09/23/2006
>14:59:59', 8000 , 782 , 11
>insert into GPFCount2 select 22 ,'09/16/2006 15:00:00','09/23/2006
>14:59:59', 4000 , 823 , 11
>insert into GPFCount2 select 22 ,'09/16/2006 15:00:00','09/23/2006
>14:59:59', 8000 , 334 , 10
>insert into GPFCount2 select 22 ,'09/16/2006 15:00:00','09/23/2006
>14:59:59', 7000 , 774 , 10
>insert into GPFCount2 select 22 ,'09/16/2006 15:00:00','09/23/2006
>14:59:59', 4000 , 870 , 10
>insert into GPFCount2 select 22 ,'09/16/2006 15:00:00','09/23/2006
>14:59:59', 4000 , 43 , 9
>insert into GPFCount2 select 22 ,'09/16/2006 15:00:00','09/23/2006
>14:59:59', 9000 , 549 , 9
>insert into GPFCount2 select 22 ,'09/16/2006 15:00:00','09/23/2006
>14:59:59', 8000 , 192 , 8
>insert into GPFCount2 select 22 ,'09/16/2006 15:00:00','09/23/2006
>14:59:59', 4000 , 443 , 8
>insert into GPFCount2 select 22 ,'09/16/2006 15:00:00','09/23/2006
>14:59:59', 8000 , 527 , 8
>insert into GPFCount2 select 22 ,'09/16/2006 15:00:00','09/23/2006
>14:59:59', 8000 , 566 , 8
>insert into GPFCount2 select 21 ,'09/09/2006 15:00:00','09/16/2006
>14:59:59', 8000 , 407 , 21
>insert into GPFCount2 select 21 ,'09/09/2006 15:00:00','09/16/2006
>14:59:59', 7000 , 451 , 20
>insert into GPFCount2 select 21 ,'09/09/2006 15:00:00','09/16/2006
>14:59:59', 4000 , 723 , 19
>insert into GPFCount2 select 21 ,'09/09/2006 15:00:00','09/16/2006
>14:59:59', 8000 , 755 , 17
>insert into GPFCount2 select 21 ,'09/09/2006 15:00:00','09/16/2006
>14:59:59', 8000 , 286 , 14
>insert into GPFCount2 select 21 ,'09/09/2006 15:00:00','09/16/2006
>14:59:59', 8000 , 336 , 14
>insert into GPFCount2 select 21 ,'09/09/2006 15:00:00','09/16/2006
>14:59:59', 8000 , 285 , 13
>insert into GPFCount2 select 21 ,'09/09/2006 15:00:00','09/16/2006
>14:59:59', 4000 , 778 , 13
>insert into GPFCount2 select 21 ,'09/09/2006 15:00:00','09/16/2006
>14:59:59', 4000 , 89 , 12
>insert into GPFCount2 select 21 ,'09/09/2006 15:00:00','09/16/2006
>14:59:59', 4000 , 264 , 12
>insert into GPFCount2 select 21 ,'09/09/2006 15:00:00','09/16/2006
>14:59:59', 8000 , 445 , 12
>insert into GPFCount2 select 21 ,'09/09/2006 15:00:00','09/16/2006
>14:59:59', 9000 , 176 , 11
>insert into GPFCount2 select 21 ,'09/09/2006 15:00:00','09/16/2006
>14:59:59', 4000 , 292 , 11
>insert into GPFCount2 select 21 ,'09/09/2006 15:00:00','09/16/2006
>14:59:59', 4000 , 324 , 11
>insert into GPFCount2 select 21 ,'09/09/2006 15:00:00','09/16/2006
>14:59:59', 8000 , 349 , 11
>insert into GPFCount2 select 21 ,'09/09/2006 15:00:00','09/16/2006
>14:59:59', 9000 , 480 , 11
>insert into GPFCount2 select 21 ,'09/09/2006 15:00:00','09/16/2006
>14:59:59', 7000 , 715 , 11
>insert into GPFCount2 select 21 ,'09/09/2006 15:00:00','09/16/2006
>14:59:59', 8000 , 201 , 10
>insert into GPFCount2 select 21 ,'09/09/2006 15:00:00','09/16/2006
>14:59:59', 8000 , 396 , 10
>insert into GPFCount2 select 21 ,'09/09/2006 15:00:00','09/16/2006
>14:59:59', 9000 , 469 , 10
>insert into GPFCount2 select 21 ,'09/09/2006 15:00:00','09/16/2006
>14:59:59', 4000 , 578 , 10
>insert into GPFCount2 select 21 ,'09/09/2006 15:00:00','09/16/2006
>14:59:59', 9000 , 724 , 10
>insert into GPFCount2 select 21 ,'09/09/2006 15:00:00','09/16/2006
>14:59:59', 8000 , 132 , 9
>insert into GPFCount2 select 21 ,'09/09/2006 15:00:00','09/16/2006
>14:59:59', 4000 , 262 , 9
>insert into GPFCount2 select 21 ,'09/09/2006 15:00:00','09/16/2006
>14:59:59', 8000 , 288 , 9
>insert into GPFCount2 select 20 ,'09/02/2006 15:00:00','09/09/2006
>14:59:59', 4000 , 723 , 33
>insert into GPFCount2 select 20 ,'09/02/2006 15:00:00','09/09/2006
>14:59:59', 4000 , 550 , 27
>insert into GPFCount2 select 20 ,'09/02/2006 15:00:00','09/09/2006
>14:59:59', 8000 , 2 , 25
>insert into GPFCount2 select 20 ,'09/02/2006 15:00:00','09/09/2006
>14:59:59', 8000 , 349 , 20
>insert into GPFCount2 select 20 ,'09/02/2006 15:00:00','09/09/2006
>14:59:59', 4000 , 911 , 20
>insert into GPFCount2 select 20 ,'09/02/2006 15:00:00','09/09/2006
>14:59:59', 8000 , 829 , 18
>insert into GPFCount2 select 20 ,'09/02/2006 15:00:00','09/09/2006
>14:59:59', 8000 , 396 , 17
>insert into GPFCount2 select 20 ,'09/02/2006 15:00:00','09/09/2006
>14:59:59', 8000 , 782 , 17
>insert into GPFCount2 select 20 ,'09/02/2006 15:00:00','09/09/2006
>14:59:59', 8000 , 60 , 16
>insert into GPFCount2 select 20 ,'09/02/2006 15:00:00','09/09/2006
>14:59:59', 8000 , 320 , 15
>insert into GPFCount2 select 20 ,'09/02/2006 15:00:00','09/09/2006
>14:59:59', 7000 , 587 , 15
>insert into GPFCount2 select 20 ,'09/02/2006 15:00:00','09/09/2006
>14:59:59', 8000 , 788 , 15
>insert into GPFCount2 select 20 ,'09/02/2006 15:00:00','09/09/2006
>14:59:59', 8000 , 796 , 14
>insert into GPFCount2 select 20 ,'09/02/2006 15:00:00','09/09/2006
>14:59:59', 4000 , 81 , 13
>insert into GPFCount2 select 20 ,'09/02/2006 15:00:00','09/09/2006
>14:59:59', 8000 , 285 , 13
>insert into GPFCount2 select 20 ,'09/02/2006 15:00:00','09/09/2006
>14:59:59', 4000 , 501 , 13
>insert into GPFCount2 select 20 ,'09/02/2006 15:00:00','09/09/2006
>14:59:59', 4000 , 292 , 12
>insert into GPFCount2 select 20 ,'09/02/2006 15:00:00','09/09/2006
>14:59:59', 9000 , 799 , 12
>insert into GPFCount2 select 20 ,'09/02/2006 15:00:00','09/09/2006
>14:59:59', 9000 , 430 , 11
>insert into GPFCount2 select 20 ,'09/02/2006 15:00:00','09/09/2006
>14:59:59', 4000 , 450 , 11
>insert into GPFCount2 select 20 ,'09/02/2006 15:00:00','09/09/2006
>14:59:59', 8000 , 790 , 11
>insert into GPFCount2 select 20 ,'09/02/2006 15:00:00','09/09/2006
>14:59:59', 4000 , 898 , 11
>insert into GPFCount2 select 20 ,'09/02/2006 15:00:00','09/09/2006
>14:59:59', 8000 , 399 , 10
>insert into GPFCount2 select 20 ,'09/02/2006 15:00:00','09/09/2006
>14:59:59', 4000 , 745 , 10
>insert into GPFCount2 select 20 ,'09/02/2006 15:00:00','09/09/2006
>14:59:59', 4000 , 750 , 10
Navigation:
[Reply to this message]
|