Import from TXT format - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

Import/Export (DTS) and Replication (2000)

Import from TXT format

Author

Topic

MBeal
Posting Yak Master

110 Posts

Posted - 2004-04-08 : 13:22:26

I have data that comes from a telephone switch that is able to be exported only into a text file. I need to import this data into a SQL table so it can be used. The data is not in a column and row format that lends itself to simple import/export. Do you have any suggestions on how I can strip away only certain pieces of data from a text file like this?

EXAMPLE:
AGENT ACTIVITY (SUMMARY REPORT)
REQUESTED BY CONSOLE (03) AT 01/APR/04 07:02:16

AGENT ID CODE : 000 THROUGH 999
DATES : 03/31/04 THROUGH 03/31/04

AGENT ID: 102 -STEVE N. GROUP NO. : 600

NO. OF ACD CALLS: RING = 3 TALK= 2 ORG= 15
AVE. TIME (SEC): ANS = 0.0 TALK= 460.0
ACT TIME (HH:MM): LOGON= 9:23 D.D = 6:33 ORG= 0:34

AGENT ID: 112 -TIM M. GROUP NO. : 600

and it continues for approximately 20 users. I only need the date, the agent ID, and the data for:
"Ring", "Talk", "Org", "Ans", "Talk", "Logon", "D.D", and "Org"

I append to this file each day making it longer and longer, separated by each daily report and then once each week I need to extract the data out.

Any suggestions?

MBeal

TurdSpatulaWarrior
Starting Member

36 Posts

Posted - 2004-04-08 : 13:54:02

You're probably going to have to write some sort of app to filter things out (perhaps using regular expressions), then write that into SQL. Do you have a more lengthy example of your data? I dislike hairy text manipulation tasks like this.

MBeal
Posting Yak Master

110 Posts

Posted - 2004-04-08 : 14:41:40

Yes... I have more lengthy examples. Here are two days worth of data. There are patterns, but I don't have any idea how to write such an application...

AGENT ACTIVITY (SUMMARY REPORT)
REQUESTED BY CONSOLE (03) AT 01/APR/04 07:02:16

AGENT ID CODE : 000 THROUGH 999
DATES : 03/31/04 THROUGH 03/31/04

AGENT ID: 102 -STEVE N. GROUP NO. : 600

NO. OF ACD CALLS: RING = 3 TALK= 2 ORG= 15
AVE. TIME (SEC): ANS = 0.0 TALK= 460.0
ACT TIME (HH:MM): LOGON= 9:23 D.D = 6:33 ORG= 0:34

AGENT ID: 112 -TIM M. GROUP NO. : 600

NO. OF ACD CALLS: RING = 4 TALK= 4 ORG= 14
AVE. TIME (SEC): ANS = 5.0 TALK= 200.0
ACT TIME (HH:MM): LOGON= 4:30 D.D = 0:27 ORG= 0:18

AGENT ID: 533 -Jeff B. GROUP NO. : 660

NO. OF ACD CALLS: RING = 0 TALK= 0 ORG= 22
AVE. TIME (SEC): ANS = 0.0 TALK= 0.0
ACT TIME (HH:MM): LOGON= 6:09 D.D = 5:43 ORG= 0:25

AGENT ID: 118 -DAVID O. GROUP NO. : 600

NO. OF ACD CALLS: RING = 0 TALK= 0 ORG= 0
AVE. TIME (SEC): ANS = 0.0 TALK= 0.0
ACT TIME (HH:MM): LOGON= 0:00 D.D = 0:00 ORG= 0:00

AGENT ID: 119 -SCOTT L. GROUP NO. : 600

NO. OF ACD CALLS: RING = 0 TALK= 0 ORG= 0
AVE. TIME (SEC): ANS = 0.0 TALK= 0.0
ACT TIME (HH:MM): LOGON= 0:00 D.D = 0:00 ORG= 0:00

AGENT ID: 120 -DAN M. GROUP NO. : 600

NO. OF ACD CALLS: RING = 13 TALK= 13 ORG= 52
AVE. TIME (SEC): ANS = 3.0 TALK= 200.0
ACT TIME (HH:MM): LOGON= 8:42 D.D = 0:28 ORG= 1:20

AGENT ID: 101 -TODD M. GROUP NO. : 600

NO. OF ACD CALLS: RING = 0 TALK= 0 ORG= 20
AVE. TIME (SEC): ANS = 0.0 TALK= 0.0
ACT TIME (HH:MM): LOGON= 8:40 D.D = 7:51 ORG= 0:49

AGENT ID: 535 -Stephanie S. GROUP NO. : 660

NO. OF ACD CALLS: RING = 0 TALK= 0 ORG= 13
AVE. TIME (SEC): ANS = 0.0 TALK= 0.0
ACT TIME (HH:MM): LOGON= 6:15 D.D = 5:54 ORG= 0:21

AGENT ID: 506 -Barbara P. GROUP NO. : 660

NO. OF ACD CALLS: RING = 0 TALK= 0 ORG= 14
AVE. TIME (SEC): ANS = 0.0 TALK= 0.0
ACT TIME (HH:MM): LOGON= 8:17 D.D = 7:59 ORG= 0:18

AGENT ID: 508 -Jacqi L. GROUP NO. : 660

NO. OF ACD CALLS: RING = 0 TALK= 0 ORG= 32
AVE. TIME (SEC): ANS = 0.0 TALK= 0.0
ACT TIME (HH:MM): LOGON= 7:48 D.D = 7:17 ORG= 0:31

AGENT ID: 527 -Annette B. GROUP NO. : 660

NO. OF ACD CALLS: RING = 1 TALK= 1 ORG= 1
AVE. TIME (SEC): ANS = 0.0 TALK= 200.0
ACT TIME (HH:MM): LOGON= 0:10 D.D = 0:00 ORG= 0:02

AGENT ID: 525 -Megan W. GROUP NO. : 660

NO. OF ACD CALLS: RING = 0 TALK= 0 ORG= 49
AVE. TIME (SEC): ANS = 0.0 TALK= 0.0
ACT TIME (HH:MM): LOGON= 8:16 D.D = 6:50 ORG= 1:26

AGENT ID: 529 -Johanna P. GROUP NO. : 660

NO. OF ACD CALLS: RING = 26 TALK= 26 ORG= 7
AVE. TIME (SEC): ANS = 5.3 TALK= 138.4
ACT TIME (HH:MM): LOGON= 8:42 D.D = 1:24 ORG= 0:10

AGENT ID: 530 -Kim R. GROUP NO. : 660

NO. OF ACD CALLS: RING = 1 TALK= 1 ORG= 18
AVE. TIME (SEC): ANS = 0.0 TALK= 180.0
ACT TIME (HH:MM): LOGON= 8:50 D.D = 8:28 ORG= 0:19

AGENT ID: 534 -Jeremy L. GROUP NO. : 660

NO. OF ACD CALLS: RING = 0 TALK= 0 ORG= 32
AVE. TIME (SEC): ANS = 0.0 TALK= 0.0
ACT TIME (HH:MM): LOGON= 7:49 D.D = 6:47 ORG= 1:02

AGENT ID: 532 -Lisa D. GROUP NO. : 660

NO. OF ACD CALLS: RING = 20 TALK= 17 ORG= 16
AVE. TIME (SEC): ANS = 7.0 TALK= 160.0
ACT TIME (HH:MM): LOGON= 8:59 D.D = 1:17 ORG= 0:20

AGENT ID: 117 -BRIAN N. GROUP NO. : 600

NO. OF ACD CALLS: RING = 15 TALK= 14 ORG= 17
AVE. TIME (SEC): ANS = 5.3 TALK= 338.5
ACT TIME (HH:MM): LOGON= 9:13 D.D = 2:32 ORG= 0:35

AGENT ID: 109 -GORDON Z. GROUP NO. : 600

NO. OF ACD CALLS: RING = 0 TALK= 0 ORG= 0
AVE. TIME (SEC): ANS = 0.0 TALK= 0.0
ACT TIME (HH:MM): LOGON= 0:00 D.D = 0:00 ORG= 0:00

AGENT ID: 114 -TERRI Z. GROUP NO. : 600

NO. OF ACD CALLS: RING = 0 TALK= 0 ORG= 22
AVE. TIME (SEC): ANS = 0.0 TALK= 0.0
ACT TIME (HH:MM): LOGON= 9:09 D.D = 8:21 ORG= 0:48

AGENT ID: 116 -GREGG G. GROUP NO. : 600

NO. OF ACD CALLS: RING = 0 TALK= 0 ORG= 0
AVE. TIME (SEC): ANS = 0.0 TALK= 0.0
ACT TIME (HH:MM): LOGON= 0:00 D.D = 0:00 ORG= 0:00

-----------------------------------------------------------------
TOTAL OF AGENTS

NO. OF ACD CALLS: RING = 83 TALK= 78 ORG= 344
AVE. TIME (SEC): ANS = 5.0 TALK= 202.0
ACT TIME (HH:MM): LOGON= 120:52 D.D = 77:51 ORG= 9:18

AGENT ACTIVITY (SUMMARY REPORT) : END OF PRINTOUT

AGENT ACTIVITY (SUMMARY REPORT)
REQUESTED BY CONSOLE (03) AT 02/APR/04 08:16:45

AGENT ID CODE : 000 THROUGH 999
DATES : 04/01/04 THROUGH 04/01/04

AGENT ID: 102 -STEVE N. GROUP NO. : 600

NO. OF ACD CALLS: RING = 2 TALK= 2 ORG= 13
AVE. TIME (SEC): ANS = 0.0 TALK= 480.0
ACT TIME (HH:MM): LOGON= 9:11 D.D = 6:09 ORG= 0:15

AGENT ID: 112 -TIM M. GROUP NO. : 600

NO. OF ACD CALLS: RING = 10 TALK= 9 ORG= 25
AVE. TIME (SEC): ANS = 4.0 TALK= 175.5
ACT TIME (HH:MM): LOGON= 8:27 D.D = 1:59 ORG= 1:07

AGENT ID: 533 -Jeff B. GROUP NO. : 660

NO. OF ACD CALLS: RING = 0 TALK= 0 ORG= 39
AVE. TIME (SEC): ANS = 0.0 TALK= 0.0
ACT TIME (HH:MM): LOGON= 14:25 D.D = 14:00 ORG= 0:25

AGENT ID: 118 -DAVID O. GROUP NO. : 600

NO. OF ACD CALLS: RING = 0 TALK= 0 ORG= 0
AVE. TIME (SEC): ANS = 0.0 TALK= 0.0
ACT TIME (HH:MM): LOGON= 0:00 D.D = 0:00 ORG= 0:00

AGENT ID: 119 -SCOTT L. GROUP NO. : 600

NO. OF ACD CALLS: RING = 0 TALK= 0 ORG= 0
AVE. TIME (SEC): ANS = 0.0 TALK= 0.0
ACT TIME (HH:MM): LOGON= 0:00 D.D = 0:00 ORG= 0:00

AGENT ID: 120 -DAN M. GROUP NO. : 600

NO. OF ACD CALLS: RING = 10 TALK= 9 ORG= 6
AVE. TIME (SEC): ANS = 10.0 TALK= 251.1
ACT TIME (HH:MM): LOGON= 8:41 D.D = 1:05 ORG= 0:11

AGENT ID: 101 -TODD M. GROUP NO. : 600

NO. OF ACD CALLS: RING = 0 TALK= 0 ORG= 14
AVE. TIME (SEC): ANS = 0.0 TALK= 0.0
ACT TIME (HH:MM): LOGON= 9:31 D.D = 8:58 ORG= 0:33

AGENT ID: 535 -Stephanie S. GROUP NO. : 660

NO. OF ACD CALLS: RING = 0 TALK= 0 ORG= 11
AVE. TIME (SEC): ANS = 0.0 TALK= 0.0
ACT TIME (HH:MM): LOGON= 7:08 D.D = 6:26 ORG= 0:42

AGENT ID: 506 -Barbara P. GROUP NO. : 660

NO. OF ACD CALLS: RING = 0 TALK= 0 ORG= 20
AVE. TIME (SEC): ANS = 0.0 TALK= 0.0
ACT TIME (HH:MM): LOGON= 8:12 D.D = 7:47 ORG= 0:25

AGENT ID: 508 -Jacqi L. GROUP NO. : 660

NO. OF ACD CALLS: RING = 0 TALK= 0 ORG= 32
AVE. TIME (SEC): ANS = 0.0 TALK= 0.0
ACT TIME (HH:MM): LOGON= 7:58 D.D = 7:07 ORG= 0:51

AGENT ID: 527 -Annette B. GROUP NO. : 660

NO. OF ACD CALLS: RING = 0 TALK= 0 ORG= 0
AVE. TIME (SEC): ANS = 0.0 TALK= 0.0
ACT TIME (HH:MM): LOGON= 0:00 D.D = 0:00 ORG= 0:00

AGENT ID: 525 -Megan W. GROUP NO. : 660

NO. OF ACD CALLS: RING = 0 TALK= 0 ORG= 23
AVE. TIME (SEC): ANS = 0.0 TALK= 0.0
ACT TIME (HH:MM): LOGON= 8:46 D.D = 8:12 ORG= 0:34

AGENT ID: 529 -Johanna P. GROUP NO. : 660

NO. OF ACD CALLS: RING = 19 TALK= 19 ORG= 10
AVE. TIME (SEC): ANS = 6.3 TALK= 154.7
ACT TIME (HH:MM): LOGON= 8:56 D.D = 1:19 ORG= 0:09

AGENT ID: 530 -Kim R. GROUP NO. : 660

NO. OF ACD CALLS: RING = 0 TALK= 0 ORG= 11
AVE. TIME (SEC): ANS = 0.0 TALK= 0.0
ACT TIME (HH:MM): LOGON= 8:49 D.D = 8:39 ORG= 0:11

AGENT ID: 534 -Jeremy L. GROUP NO. : 660

NO. OF ACD CALLS: RING = 0 TALK= 0 ORG= 32
AVE. TIME (SEC): ANS = 0.0 TALK= 0.0
ACT TIME (HH:MM): LOGON= 7:20 D.D = 6:52 ORG= 0:28

AGENT ID: 532 -Lisa D. GROUP NO. : 660

NO. OF ACD CALLS: RING = 17 TALK= 17 ORG= 8
AVE. TIME (SEC): ANS = 5.8 TALK= 224.7
ACT TIME (HH:MM): LOGON= 9:00 D.D = 1:23 ORG= 0:06

AGENT ID: 117 -BRIAN N. GROUP NO. : 600

NO. OF ACD CALLS: RING = 14 TALK= 14 ORG= 18
AVE. TIME (SEC): ANS = 5.7 TALK= 331.4
ACT TIME (HH:MM): LOGON= 8:59 D.D = 2:33 ORG= 0:28

AGENT ID: 109 -GORDON Z. GROUP NO. : 600

NO. OF ACD CALLS: RING = 0 TALK= 0 ORG= 0
AVE. TIME (SEC): ANS = 0.0 TALK= 0.0
ACT TIME (HH:MM): LOGON= 0:00 D.D = 0:00 ORG= 0:00

AGENT ID: 114 -TERRI Z. GROUP NO. : 600

NO. OF ACD CALLS: RING = 1 TALK= 1 ORG= 25
AVE. TIME (SEC): ANS = 0.0 TALK= 60.0
ACT TIME (HH:MM): LOGON= 8:59 D.D = 8:31 ORG= 0:27

AGENT ID: 116 -GREGG G. GROUP NO. : 600

NO. OF ACD CALLS: RING = 0 TALK= 0 ORG= 0
AVE. TIME (SEC): ANS = 0.0 TALK= 0.0
ACT TIME (HH:MM): LOGON= 0:00 D.D = 0:00 ORG= 0:00

-----------------------------------------------------------------
TOTAL OF AGENTS

NO. OF ACD CALLS: RING = 73 TALK= 71 ORG= 287
AVE. TIME (SEC): ANS = 6.0 TALK= 229.0
ACT TIME (HH:MM): LOGON= 134:22 D.D = 91:00 ORG= 6:52

AGENT ACTIVITY (SUMMARY REPORT) : END OF PRINTOUT

There is also a second text file that also needs to be extracted as well. It's only the date and the totals by group (600 / 660) It looks like this...

REQUESTED BY CONSOLE (03) AT 01/APR/04 06:54:06

GROUP NUMBER : 10 THROUGH 999
DATE : 03/31/04
TIMES : 00:00 THROUGH 23:00

GROUP 600 (RESERVATIONS)

NUMBER OF ACD CALLS QUEUED CALLS

NITE/ BUSY/
TIME TOTAL ANS INCMP OVFLW INFLW PICK ANNO (1) (2) (3)

00:00-00:30 0 0 0 0 0 0 0 0 0 0
00:30-01:00 0 0 0 0 0 0 0 0 0 0
01:00-01:30 0 0 0 0 0 0 0 0 0 0
01:30-02:00 0 0 0 0 0 0 0 0 0 0
02:00-02:30 0 0 0 0 0 0 0 0 0 0
02:30-03:00 0 0 0 0 0 0 0 0 0 0
03:00-03:30 0 0 0 0 0 0 0 0 0 0
03:30-04:00 0 0 0 0 0 0 0 0 0 0
04:00-04:30 0 0 0 0 0 0 0 0 0 0
04:30-05:00 0 0 0 0 0 0 0 0 0 0
05:00-05:30 0 0 0 0 0 0 0 0 0 0
05:30-06:00 0 0 0 0 0 0 0 0 0 0
06:00-06:30 0 0 0 0 0 0 0 0 0 0
06:30-07:00 1 1 0 0 0 0 0 0 0 0
07:00-07:30 0 0 0 0 0 0 0 0 0 0
07:30-08:00 1 1 0 0 0 0 0 0 0 0
08:00-08:30 0 0 0 0 0 0 0 0 0 0
08:30-09:00 0 0 0 0 0 0 0 0 0 0
09:00-09:30 1 1 0 0 0 0 0 0 0 0
09:30-10:00 1 1 0 0 0 0 0 0 0 0
10:00-10:30 1 1 0 0 0 0 0 0 0 0
10:30-11:00 4 4 0 0 0 0 0 0 0 0
11:00-11:30 0 0 0 0 0 0 0 0 0 0
11:30-12:00 0 0 0 0 0 0 0 0 0 0
12:00-12:30 6 5 1 0 0 0 0 1 1 0
12:30-13:00 1 1 0 0 0 0 0 0 1 0
13:00-13:30 3 3 0 0 0 0 0 0 0 0
13:30-14:00 2 2 0 0 0 0 0 0 0 0
14:00-14:30 3 3 0 0 0 0 0 0 0 0
14:30-15:00 1 1 0 0 0 0 0 0 0 0
15:00-15:30 0 0 0 0 0 0 0 0 0 0
15:30-16:00 2 2 0 0 0 0 0 0 0 0
16:00-16:30 1 1 0 0 0 0 0 0 0 0
16:30-17:00 1 1 0 0 0 0 0 0 0 0
17:00-17:30 1 1 0 0 0 0 0 0 0 0
17:30-18:00 1 1 0 0 0 0 0 0 0 0
18:00-18:30 5 2 3 0 0 0 0 0 2 0
18:30-19:00 1 1 0 0 0 0 0 0 0 0
19:00-19:30 0 0 0 0 0 0 0 0 0 0
19:30-20:00 0 0 0 0 0 0 0 0 0 0
20:00-20:30 0 0 0 0 0 0 0 0 0 0
20:30-21:00 0 0 0 0 0 0 0 0 0 0
21:00-21:30 0 0 0 0 0 0 0 0 0 0
21:30-22:00 0 0 0 0 0 0 0 0 0 0
22:00-22:30 0 0 0 0 0 0 0 0 0 0
22:30-23:00 0 0 0 0 0 0 0 0 0 0
23:00-23:30 0 0 0 0 0 0 0 0 0 0
23:30-00:00 0 0 0 0 0 0 0 0 0 0
-----------------------------------------------------------------------------
TOTAL 37 33 4 0 0 0 0 1 4 0

GROUP 660 (CORPORATE )

NUMBER OF ACD CALLS QUEUED CALLS

NITE/ BUSY/
TIME TOTAL ANS INCMP OVFLW INFLW PICK ANNO (1) (2) (3)

00:00-00:30 0 0 0 0 0 0 0 0 0 0
00:30-01:00 0 0 0 0 0 0 0 0 0 0
01:00-01:30 0 0 0 0 0 0 0 0 0 0
01:30-02:00 0 0 0 0 0 0 0 0 0 0
02:00-02:30 0 0 0 0 0 0 0 0 0 0
02:30-03:00 0 0 0 0 0 0 0 0 0 0
03:00-03:30 0 0 0 0 0 0 0 0 0 0
03:30-04:00 0 0 0 0 0 0 0 0 0 0
04:00-04:30 0 0 0 0 0 0 0 0 0 0
04:30-05:00 0 0 0 0 0 0 0 0 0 0
05:00-05:30 0 0 0 0 0 0 0 0 0 0
05:30-06:00 0 0 0 0 0 0 0 0 0 0
06:00-06:30 0 0 0 0 0 0 0 0 0 0
06:30-07:00 0 0 0 0 0 0 0 0 0 0
07:00-07:30 1 0 0 1 0 0 0 0 0 0
07:30-08:00 3 1 0 2 0 0 0 0 0 0
08:00-08:30 4 3 1 0 0 0 0 1 0 0
08:30-09:00 5 3 2 0 0 0 0 2 0 0
09:00-09:30 5 4 1 0 0 0 0 0 0 0
09:30-10:00 3 3 0 0 0 0 0 0 0 0
10:00-10:30 2 2 0 0 0 0 0 0 0 0
10:30-11:00 5 4 1 0 0 0 0 0 1 0
11:00-11:30 2 2 0 0 0 0 0 0 0 0
11:30-12:00 3 3 0 0 0 0 0 0 0 0
12:00-12:30 3 3 0 0 0 0 0 0 0 0
12:30-13:00 1 1 0 0 0 0 0 0 0 0
13:00-13:30 6 5 1 0 0 0 0 1 0 1
13:30-14:00 2 1 1 0 0 0 0 1 0 0
14:00-14:30 3 2 1 0 0 0 0 0 1 0
14:30-15:00 4 4 0 0 0 0 0 0 0 0
15:00-15:30 2 2 0 0 0 0 0 0 0 0
15:30-16:00 0 0 0 0 0 0 0 0 0 0
16:00-16:30 0 0 0 0 0 0 0 0 0 0
16:30-17:00 2 2 0 0 0 0 0 0 0 0
17:00-17:30 0 0 0 0 0 0 0 0 0 0
17:30-18:00 1 0 1 0 0 0 0 0 1 0
18:00-18:30 0 0 0 0 0 0 0 0 0 0
18:30-19:00 0 0 0 0 0 0 0 0 0 0
19:00-19:30 0 0 0 0 0 0 0 0 0 0
19:30-20:00 0 0 0 0 0 0 0 0 0 0
20:00-20:30 0 0 0 0 0 0 0 0 0 0
20:30-21:00 0 0 0 0 0 0 0 0 0 0
21:00-21:30 0 0 0 0 0 0 0 0 0 0
21:30-22:00 0 0 0 0 0 0 0 0 0 0
22:00-22:30 0 0 0 0 0 0 0 0 0 0
22:30-23:00 0 0 0 0 0 0 0 0 0 0
23:00-23:30 0 0 0 0 0 0 0 0 0 0
23:30-00:00 0 0 0 0 0 0 0 0 0 0
-----------------------------------------------------------------------------
TOTAL 57 45 9 3 0 0 0 5 3 1

TOTAL OF ASSIGNED GROUPS BY THE HOUR

NUMBER OF ACD CALLS QUEUED CALLS

NITE/ BUSY/
TIME TOTAL ANS INCMP OVFLW INFLW PICK ANNO (1) (2) (3)

00:00-00:30 0 0 0 0 0 0 0 0 0 0
00:30-01:00 0 0 0 0 0 0 0 0 0 0
01:00-01:30 0 0 0 0 0 0 0 0 0 0
01:30-02:00 0 0 0 0 0 0 0 0 0 0
02:00-02:30 0 0 0 0 0 0 0 0 0 0
02:30-03:00 0 0 0 0 0 0 0 0 0 0
03:00-03:30 0 0 0 0 0 0 0 0 0 0
03:30-04:00 0 0 0 0 0 0 0 0 0 0
04:00-04:30 0 0 0 0 0 0 0 0 0 0
04:30-05:00 0 0 0 0 0 0 0 0 0 0
05:00-05:30 0 0 0 0 0 0 0 0 0 0
05:30-06:00 0 0 0 0 0 0 0 0 0 0
06:00-06:30 0 0 0 0 0 0 0 0 0 0
06:30-07:00 1 1 0 0 0 0 0 0 0 0
07:00-07:30 1 0 0 1 0 0 0 0 0 0
07:30-08:00 4 2 0 2 0 0 0 0 0 0
08:00-08:30 4 3 1 0 0 0 0 1 0 0
08:30-09:00 5 3 2 0 0 0 0 2 0 0
09:00-09:30 6 5 1 0 0 0 0 0 0 0
09:30-10:00 4 4 0 0 0 0 0 0 0 0
10:00-10:30 3 3 0 0 0 0 0 0 0 0
10:30-11:00 9 8 1 0 0 0 0 0 1 0
11:00-11:30 2 2 0 0 0 0 0 0 0 0
11:30-12:00 3 3 0 0 0 0 0 0 0 0
12:00-12:30 9 8 1 0 0 0 0 1 1 0
12:30-13:00 2 2 0 0 0 0 0 0 1 0
13:00-13:30 9 8 1 0 0 0 0 1 0 1
13:30-14:00 4 3 1 0 0 0 0 1 0 0
14:00-14:30 6 5 1 0 0 0 0 0 1 0
14:30-15:00 5 5 0 0 0 0 0 0 0 0
15:00-15:30 2 2 0 0 0 0 0 0 0 0
15:30-16:00 2 2 0 0 0 0 0 0 0 0
16:00-16:30 1 1 0 0 0 0 0 0 0 0
16:30-17:00 3 3 0 0 0 0 0 0 0 0
17:00-17:30 1 1 0 0 0 0 0 0 0 0
17:30-18:00 2 1 1 0 0 0 0 0 1 0
18:00-18:30 5 2 3 0 0 0 0 0 2 0
18:30-19:00 1 1 0 0 0 0 0 0 0 0
19:00-19:30 0 0 0 0 0 0 0 0 0 0
19:30-20:00 0 0 0 0 0 0 0 0 0 0
20:00-20:30 0 0 0 0 0 0 0 0 0 0
20:30-21:00 0 0 0 0 0 0 0 0 0 0
21:00-21:30 0 0 0 0 0 0 0 0 0 0
21:30-22:00 0 0 0 0 0 0 0 0 0 0
22:00-22:30 0 0 0 0 0 0 0 0 0 0
22:30-23:00 0 0 0 0 0 0 0 0 0 0
23:00-23:30 0 0 0 0 0 0 0 0 0 0
23:30-00:00 0 0 0 0 0 0 0 0 0 0
-----------------------------------------------------------------------------
TOTAL 94 78 13 3 0 0 0 6 7 1

ACD GROUP ACTIVITY (DETAIL REPORT) : END OF PRINTOUT

MBeal

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources