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
 General SQL Server Forums
 New to SQL Server Programming
 Time Difference in SQL Server

Author  Topic 

swl681
Starting Member

15 Posts
Posted - 2007-12-06 : 10:16:12
I am new to SQL Server and am trying to write a query that subtracts the time difference in the same column. I need to know the time difference between BatchSequence 2, LoadSequence 1 and BatchSequence 13, LoadSequence 3. Below is an example of the data. Thanks in advacne for the help!

BatchSequence LoadSequence ScanLabel ProcessDate
13 1 Part Number 11/1/2007 6:08:02 AM
13 2 Scan Trace 11/1/2007 6:08:03 AM
13 3 Slot Position 11/1/2007 6:08:04 AM
2 1 Part Number 11/1/2007 5:53:06 AM
2 2 Scan Trace 11/1/2007 5:53:07 AM
2 3 Slot Position 11/1/2007 5:53:08 AM

SwePeso
Patron Saint of Lost Yaks

30421 Posts
Posted - 2007-12-06 : 10:20:44
Using 2005 or 2000?


E 12°55'05.25"
N 56°04'39.16"
Go to Top of Page

swl681
Starting Member

15 Posts
Posted - 2007-12-06 : 10:27:08
Sorry about that, it is SQL Server 2000
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

30421 Posts
Posted - 2007-12-06 : 10:31:09
SELECT DATEDIFF(MINUTE, p, q) AS DifferenceInMinutes
FROM (
SELECT MIN(ProcessDate) AS p, MAX(ProcessDate) AS q
FROM YourTable1
) AS d


E 12°55'05.25"
N 56°04'39.16"
Go to Top of Page

swl681
Starting Member

15 Posts
Posted - 2007-12-06 : 10:36:39
Thank you for your prompt response but I am not understanding what p and q are and what is going on, could you give me a little more detail I am a noob...sorry!
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

30421 Posts
Posted - 2007-12-06 : 10:37:42
p and q are just column names (aliases in fact).
d is the alias name for the derived table.


E 12°55'05.25"
N 56°04'39.16"
Go to Top of Page

swl681
Starting Member

15 Posts
Posted - 2007-12-06 : 10:47:42
I see, thank you for your help. There is still on thing that I am struggling with and that is the above data is a subset of a much larger table so I need to somehow specify that it needs to pull the date difference from BatchSequence 2, LoadSequence 1 and BatchSequence 13, LoadSequence 3. I really appreciate your help! THANK YOU!
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

30421 Posts
Posted - 2007-12-06 : 10:59:35
[code]SELECT DATEDIFF(MINUTE, mi, ma) AS DiffMinutes
FROM (
SELECT MIN(ProcessDate) AS mi,
MAX(ProcessDate) AS ma
FROM Table1
WHERE (BatchSequence = 2 AND LoadSequence = 1)
OR (BatchSequence = 13 AND LoadSequence = 3)
) AS d[/code]

E 12°55'05.25"
N 56°04'39.16"
Go to Top of Page

swl681
Starting Member

15 Posts
Posted - 2007-12-06 : 12:19:26
The below works perfect, thank you very much. The next issue I am running into though is that there are multiple BatchSequence's and LoadSequence's. What I am hoping to do is get the time difference per LoadID and I am not sure how to do that. Thank you again for your help, I really do appreciate it!
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

30421 Posts
Posted - 2007-12-06 : 15:13:56
You maybe should post some more sample data?
And your expected output...


E 12°55'05.25"
N 56°04'39.16"
Go to Top of Page

swl681
Starting Member

15 Posts
Posted - 2007-12-07 : 09:00:01
Below is some sample data. I have thousands of LoadID's. What I am trying to capture is the average time difference between the BatchSequence 2, LoadSequence 1 and BatchSequence 13, LoadSequence 3 for each LoadID and than break it out by shift and than month. The shifts are also based on time, 1st shift is from 6:00am to 3:00pm and 2nd shift is from 3:30pm to 12:00am. I appreciate your time and help and if anymore detailed is needed please let me know. Thanks Again!!!

ProcessDate LoadID LoadSequence ScanSequence BatchSequence
12/3/2007 6:33:54 AM 39355 1 1 3
12/3/2007 6:33:55 AM 39355 1 2 3
12/3/2007 6:39:22 AM 39355 9 3 11
12/3/2007 6:36:57 AM 39355 10 1 8
12/3/2007 6:36:58 AM 39355 10 2 8
12/3/2007 6:36:59 AM 39355 10 3 8
12/3/2007 6:40:19 AM 39355 11 1 13
12/3/2007 6:40:20 AM 39355 11 2 13
12/3/2007 6:40:20 AM 39355 11 3 13
12/3/2007 6:38:45 AM 39355 12 1 10
12/3/2007 6:38:47 AM 39355 12 2 10
12/3/2007 6:38:48 AM 39355 12 3 10
12/3/2007 6:39:45 AM 39355 13 1 12
12/3/2007 6:39:46 AM 39355 13 2 12
12/3/2007 6:39:47 AM 39355 13 3 12
12/3/2007 6:33:57 AM 39355 1 3 3
12/3/2007 6:33:00 AM 39355 2 1 1
12/3/2007 6:33:01 AM 39355 2 2 1
12/3/2007 6:33:02 AM 39355 2 3 1
12/3/2007 6:35:08 AM 39355 3 1 5
12/3/2007 6:35:09 AM 39355 3 2 5
12/3/2007 6:35:11 AM 39355 3 3 5
12/3/2007 6:33:31 AM 39355 4 1 2
12/3/2007 6:33:32 AM 39355 4 2 2
12/3/2007 6:33:33 AM 39355 4 3 2
12/3/2007 6:36:11 AM 39355 5 1 7
12/3/2007 6:36:12 AM 39355 5 2 7
12/3/2007 6:36:14 AM 39355 5 3 7
12/3/2007 6:34:17 AM 39355 6 1 4
12/3/2007 6:34:18 AM 39355 6 2 4
12/3/2007 6:34:19 AM 39355 6 3 4
12/3/2007 6:37:26 AM 39355 7 1 9
12/3/2007 6:37:27 AM 39355 7 2 9
12/3/2007 6:37:28 AM 39355 7 3 9
12/3/2007 6:35:42 AM 39355 8 1 6
12/3/2007 6:35:43 AM 39355 8 2 6
12/3/2007 6:35:43 AM 39355 8 3 6
12/3/2007 6:39:16 AM 39355 9 1 11
12/3/2007 6:39:18 AM 39355 9 2 11
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

30421 Posts
Posted - 2007-12-07 : 09:17:55
Only one LoadID in the sample data?
And none of the sample data matches the wanted configuration.

E 12°55'05.25"
N 56°04'39.16"
Go to Top of Page

swl681
Starting Member

15 Posts
Posted - 2007-12-07 : 09:22:17
Here are few more LoadID's. Thank you for your time and interest in my noob problem, I really do appreciate it!

ProcessDate LoadID LoadSequence ScanSequence BatchSequence
12/3/2007 6:33:54 AM 39355 1 1 3
12/3/2007 6:33:55 AM 39355 1 2 3
12/3/2007 6:33:57 AM 39355 1 3 3
12/3/2007 6:33:00 AM 39355 2 1 1
12/3/2007 6:33:01 AM 39355 2 2 1
12/3/2007 6:33:02 AM 39355 2 3 1
12/3/2007 6:35:08 AM 39355 3 1 5
12/3/2007 6:35:09 AM 39355 3 2 5
12/3/2007 6:35:11 AM 39355 3 3 5
12/3/2007 6:33:31 AM 39355 4 1 2
12/3/2007 6:33:32 AM 39355 4 2 2
12/3/2007 6:33:33 AM 39355 4 3 2
12/3/2007 6:36:11 AM 39355 5 1 7
12/3/2007 6:36:12 AM 39355 5 2 7
12/3/2007 6:36:14 AM 39355 5 3 7
12/3/2007 6:34:17 AM 39355 6 1 4
12/3/2007 6:34:18 AM 39355 6 2 4
12/3/2007 6:34:19 AM 39355 6 3 4
12/3/2007 6:37:26 AM 39355 7 1 9
12/3/2007 6:37:27 AM 39355 7 2 9
12/3/2007 6:37:28 AM 39355 7 3 9
12/3/2007 6:35:42 AM 39355 8 1 6
12/3/2007 6:35:43 AM 39355 8 2 6
12/3/2007 6:35:43 AM 39355 8 3 6
12/3/2007 6:39:16 AM 39355 9 1 11
12/3/2007 6:39:18 AM 39355 9 2 11
12/3/2007 6:39:22 AM 39355 9 3 11
12/3/2007 6:36:57 AM 39355 10 1 8
12/3/2007 6:36:58 AM 39355 10 2 8
12/3/2007 6:36:59 AM 39355 10 3 8
12/3/2007 6:40:19 AM 39355 11 1 13
12/3/2007 6:40:20 AM 39355 11 2 13
12/3/2007 6:40:20 AM 39355 11 3 13
12/3/2007 6:38:45 AM 39355 12 1 10
12/3/2007 6:38:47 AM 39355 12 2 10
12/3/2007 6:38:48 AM 39355 12 3 10
12/3/2007 6:39:45 AM 39355 13 1 12
12/3/2007 6:39:46 AM 39355 13 2 12
12/3/2007 6:39:47 AM 39355 13 3 12
12/3/2007 6:44:04 AM 39356 1 1 3
12/3/2007 6:44:05 AM 39356 1 2 3
12/3/2007 6:44:06 AM 39356 1 3 3
12/3/2007 6:42:55 AM 39356 2 1 1
12/3/2007 6:42:56 AM 39356 2 2 1
12/3/2007 6:42:58 AM 39356 2 3 1
12/3/2007 6:45:11 AM 39356 3 1 5
12/3/2007 6:45:12 AM 39356 3 2 5
12/3/2007 6:45:13 AM 39356 3 3 5
12/3/2007 6:43:29 AM 39356 4 1 2
12/3/2007 6:43:30 AM 39356 4 2 2
12/3/2007 6:43:31 AM 39356 4 3 2
12/3/2007 6:48:12 AM 39356 5 1 7
12/3/2007 6:48:13 AM 39356 5 2 7
12/3/2007 6:48:15 AM 39356 5 3 7
12/3/2007 6:44:38 AM 39356 6 1 4
12/3/2007 6:44:39 AM 39356 6 2 4
12/3/2007 6:44:40 AM 39356 6 3 4
12/3/2007 6:49:35 AM 39356 7 1 9
12/3/2007 6:49:37 AM 39356 7 2 9
12/3/2007 6:49:38 AM 39356 7 3 9
12/3/2007 6:47:35 AM 39356 8 1 6
12/3/2007 6:47:38 AM 39356 8 2 6
12/3/2007 6:47:40 AM 39356 8 3 6
12/3/2007 6:51:15 AM 39356 9 1 11
12/3/2007 6:51:16 AM 39356 9 2 11
12/3/2007 6:51:17 AM 39356 9 3 11
12/3/2007 6:48:44 AM 39356 10 1 8
12/3/2007 6:48:45 AM 39356 10 2 8
12/3/2007 6:48:46 AM 39356 10 3 8
12/3/2007 6:52:07 AM 39356 11 1 13
12/3/2007 6:52:08 AM 39356 11 2 13
12/3/2007 6:52:10 AM 39356 11 3 13
12/3/2007 6:50:16 AM 39356 12 1 10
12/3/2007 6:50:17 AM 39356 12 2 10
12/3/2007 6:50:18 AM 39356 12 3 10
12/3/2007 6:51:36 AM 39356 13 1 12
12/3/2007 6:51:37 AM 39356 13 2 12
12/3/2007 6:51:39 AM 39356 13 3 12
12/3/2007 7:13:38 AM 39357 1 1 3
12/3/2007 7:13:39 AM 39357 1 2 3
12/3/2007 7:13:43 AM 39357 1 3 3
12/3/2007 7:12:49 AM 39357 2 1 1
12/3/2007 7:12:50 AM 39357 2 2 1
12/3/2007 7:12:51 AM 39357 2 3 1
12/3/2007 7:14:40 AM 39357 3 1 5
12/3/2007 7:14:41 AM 39357 3 2 5
12/3/2007 7:14:42 AM 39357 3 3 5
12/3/2007 7:13:14 AM 39357 4 1 2
12/3/2007 7:13:15 AM 39357 4 2 2
12/3/2007 7:13:16 AM 39357 4 3 2
12/3/2007 7:16:09 AM 39357 5 1 7
12/3/2007 7:16:10 AM 39357 5 2 7
12/3/2007 7:16:11 AM 39357 5 3 7
12/3/2007 7:14:09 AM 39357 6 1 4
12/3/2007 7:14:09 AM 39357 6 2 4
12/3/2007 7:14:11 AM 39357 6 3 4
12/3/2007 7:17:36 AM 39357 7 1 9
12/3/2007 7:17:37 AM 39357 7 2 9
12/3/2007 7:17:38 AM 39357 7 3 9
12/3/2007 7:15:26 AM 39357 8 1 6
12/3/2007 7:15:27 AM 39357 8 2 6
12/3/2007 7:15:28 AM 39357 8 3 6
12/3/2007 7:23:01 AM 39357 9 1 11
12/3/2007 7:23:02 AM 39357 9 2 11
12/3/2007 7:23:04 AM 39357 9 3 11
12/3/2007 7:16:40 AM 39357 10 1 8
12/3/2007 7:16:41 AM 39357 10 2 8
12/3/2007 7:16:46 AM 39357 10 3 8
12/3/2007 7:23:11 AM 39357 11 1 13
12/3/2007 7:23:12 AM 39357 11 2 13
12/3/2007 7:23:13 AM 39357 11 3 13
12/3/2007 7:19:52 AM 39357 12 1 10
12/3/2007 7:19:53 AM 39357 12 2 10
12/3/2007 7:19:55 AM 39357 12 3 10
12/3/2007 7:23:05 AM 39357 13 1 12
12/3/2007 7:23:07 AM 39357 13 2 12
12/3/2007 7:23:08 AM 39357 13 3 12
12/3/2007 7:26:56 AM 39358 1 1 3
12/3/2007 7:26:57 AM 39358 1 2 3
12/3/2007 7:26:58 AM 39358 1 3 3
12/3/2007 7:25:33 AM 39358 2 1 1
12/3/2007 7:25:34 AM 39358 2 2 1
12/3/2007 7:25:35 AM 39358 2 3 1
12/3/2007 7:31:45 AM 39358 3 1 5
12/3/2007 7:31:46 AM 39358 3 2 5
12/3/2007 7:31:47 AM 39358 3 3 5
12/3/2007 7:26:19 AM 39358 4 1 2
12/3/2007 7:26:20 AM 39358 4 2 2
12/3/2007 7:26:21 AM 39358 4 3 2
12/3/2007 7:32:31 AM 39358 5 1 7
12/3/2007 7:32:32 AM 39358 5 2 7
12/3/2007 7:32:33 AM 39358 5 3 7
12/3/2007 7:27:42 AM 39358 6 1 4
12/3/2007 7:27:43 AM 39358 6 2 4
12/3/2007 7:27:44 AM 39358 6 3 4
12/3/2007 7:33:22 AM 39358 7 1 9
12/3/2007 7:33:22 AM 39358 7 2 9
12/3/2007 7:33:23 AM 39358 7 3 9
12/3/2007 7:32:10 AM 39358 8 1 6
12/3/2007 7:32:11 AM 39358 8 2 6
12/3/2007 7:32:12 AM 39358 8 3 6
12/3/2007 7:34:18 AM 39358 9 1 11
12/3/2007 7:34:19 AM 39358 9 2 11
12/3/2007 7:34:22 AM 39358 9 3 11
12/3/2007 7:32:50 AM 39358 10 1 8
12/3/2007 7:32:51 AM 39358 10 2 8
12/3/2007 7:32:52 AM 39358 10 3 8
12/3/2007 7:35:34 AM 39358 11 1 13
12/3/2007 7:35:35 AM 39358 11 2 13
12/3/2007 7:35:36 AM 39358 11 3 13
12/3/2007 7:33:45 AM 39358 12 1 10
12/3/2007 7:33:46 AM 39358 12 2 10
12/3/2007 7:33:47 AM 39358 12 3 10
12/3/2007 7:35:02 AM 39358 13 1 12
12/3/2007 7:35:03 AM 39358 13 2 12
12/3/2007 7:35:04 AM 39358 13 3 12
12/3/2007 7:38:17 AM 39359 1 1 3
12/3/2007 7:38:18 AM 39359 1 2 3
12/3/2007 7:38:19 AM 39359 1 3 3
12/3/2007 7:37:05 AM 39359 2 1 1
12/3/2007 7:37:06 AM 39359 2 2 1
12/3/2007 7:37:07 AM 39359 2 3 1
12/3/2007 7:39:21 AM 39359 3 1 5
12/3/2007 7:39:22 AM 39359 3 2 5
12/3/2007 7:39:25 AM 39359 3 3 5
12/3/2007 7:37:47 AM 39359 4 1 2
12/3/2007 7:37:48 AM 39359 4 2 2
12/3/2007 7:37:49 AM 39359 4 3 2
12/3/2007 7:40:31 AM 39359 5 1 7
12/3/2007 7:40:33 AM 39359 5 2 7
12/3/2007 7:40:34 AM 39359 5 3 7
12/3/2007 7:38:50 AM 39359 6 1 4
12/3/2007 7:38:51 AM 39359 6 2 4
12/3/2007 7:38:53 AM 39359 6 3 4
12/3/2007 7:41:39 AM 39359 7 1 9
12/3/2007 7:41:40 AM 39359 7 2 9
12/3/2007 7:41:42 AM 39359 7 3 9
12/3/2007 7:39:53 AM 39359 8 1 6
12/3/2007 7:39:54 AM 39359 8 2 6
12/3/2007 7:39:55 AM 39359 8 3 6
12/3/2007 7:42:44 AM 39359 9 1 11
12/3/2007 7:42:45 AM 39359 9 2 11
12/3/2007 7:42:49 AM 39359 9 3 11
12/3/2007 7:41:06 AM 39359 10 1 8
12/3/2007 7:41:07 AM 39359 10 2 8
12/3/2007 7:41:08 AM 39359 10 3 8
12/3/2007 7:43:54 AM 39359 11 1 13
12/3/2007 7:43:55 AM 39359 11 2 13
12/3/2007 7:43:56 AM 39359 11 3 13
12/3/2007 7:42:02 AM 39359 12 1 10
12/3/2007 7:42:13 AM 39359 12 2 10
12/3/2007 7:42:14 AM 39359 12 3 10
12/3/2007 7:43:10 AM 39359 13 1 12
12/3/2007 7:43:11 AM 39359 13 2 12
12/3/2007 7:43:13 AM 39359 13 3 12
12/3/2007 7:46:25 AM 39360 1 1 3
12/3/2007 7:46:26 AM 39360 1 2 3
12/3/2007 7:46:28 AM 39360 1 3 3
12/3/2007 7:45:33 AM 39360 2 1 1
12/3/2007 7:45:34 AM 39360 2 2 1
12/3/2007 7:45:36 AM 39360 2 3 1
12/3/2007 7:47:15 AM 39360 3 1 5
12/3/2007 7:47:16 AM 39360 3 2 5
12/3/2007 7:47:18 AM 39360 3 3 5
12/3/2007 7:46:01 AM 39360 4 1 2
12/3/2007 7:46:02 AM 39360 4 2 2
12/3/2007 7:46:04 AM 39360 4 3 2
12/3/2007 7:48:15 AM 39360 5 1 7
12/3/2007 7:48:16 AM 39360 5 2 7
12/3/2007 7:48:18 AM 39360 5 3 7
12/3/2007 7:46:49 AM 39360 6 1 4
12/3/2007 7:46:50 AM 39360 6 2 4
12/3/2007 7:46:51 AM 39360 6 3 4
12/3/2007 7:50:01 AM 39360 7 1 9
12/3/2007 7:50:02 AM 39360 7 2 9
12/3/2007 7:50:04 AM 39360 7 3 9
12/3/2007 7:47:46 AM 39360 8 1 6
12/3/2007 7:47:48 AM 39360 8 2 6
12/3/2007 7:47:49 AM 39360 8 3 6
12/3/2007 7:50:54 AM 39360 9 1 11
12/3/2007 7:50:55 AM 39360 9 2 11
12/3/2007 7:50:58 AM 39360 9 3 11
12/3/2007 7:49:42 AM 39360 10 1 8
12/3/2007 7:49:43 AM 39360 10 2 8
12/3/2007 7:49:45 AM 39360 10 3 8
12/3/2007 7:51:34 AM 39360 11 1 13
12/3/2007 7:51:35 AM 39360 11 2 13
12/3/2007 7:51:36 AM 39360 11 3 13
12/3/2007 7:50:30 AM 39360 12 1 10
12/3/2007 7:50:31 AM 39360 12 2 10
12/3/2007 7:50:32 AM 39360 12 3 10
12/3/2007 7:51:16 AM 39360 13 1 12
12/3/2007 7:51:17 AM 39360 13 2 12
12/3/2007 7:51:18 AM 39360 13 3 12
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

30421 Posts
Posted - 2007-12-07 : 09:25:54
Try this
SELECT	LoadID,
	DATEDIFF(MINUTE, mi, ma) AS DiffMinutes
FROM	(
		SELECT		LoadID,
				MIN(ProcessDate) AS mi,
				MAX(ProcessDate) AS ma
		FROM		@Sample
		WHERE		(BatchSequence = 2 AND LoadSequence = 1)
				OR (BatchSequence = 13 AND LoadSequence = 3)
		GROUP BY	LoadID
	) AS d


E 12°55'05.25"
N 56°04'39.16"
Go to Top of Page

swl681
Starting Member

15 Posts
Posted - 2007-12-07 : 09:28:58
That is not bringing any data back, it runs with out error but just returns the two columns LoadID and DiffMinu as empty.
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

30421 Posts
Posted - 2007-12-07 : 09:43:11
That is because you have no data available that matches the criteria

BatchSequence = 2 AND LoadSequence = 1

nor

BatchSequence = 13 AND LoadSequence = 3





E 12°55'05.25"
N 56°04'39.16"
Go to Top of Page

swl681
Starting Member

15 Posts
Posted - 2007-12-07 : 10:13:31
Great point I apologize for the error, what I wanted instead of BatchSequence was ScanSequence. Below I changed it and it returned all the LoadID's with a time difference but they were all equal to 0.

SELECT LoadID, DATEDIFF([MINUTE], mi, ma) AS DiffMinutes
FROM (SELECT LoadID, MIN(ProcessDate) AS mi, MAX(ProcessDate) AS ma
FROM [Scan Detail]
WHERE (ScanSequence = 2 AND LoadSequence = 2) OR
(ScanSequence = 13 AND LoadSequence = 3)
GROUP BY LoadID) d
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

30421 Posts
Posted - 2007-12-07 : 10:49:35
Not better. However, I get result when using BatchSequence and ScanSequence.
If you want help, you must learn to express your business rules properly.
DECLARE	@Sample TABLE (ProcessDate DATETIME, LoadID INT, LoadSequence INT, ScanSequence INT, BatchSequence INT)

INSERT	@Sample
SELECT	'12/3/2007 6:33:54 AM', 39355, 1, 1, 3 UNION ALL
SELECT	'12/3/2007 6:33:55 AM', 39355, 1, 2, 3 UNION ALL
SELECT	'12/3/2007 6:33:57 AM', 39355, 1, 3, 3 UNION ALL
SELECT	'12/3/2007 6:33:00 AM', 39355, 2, 1, 1 UNION ALL
SELECT	'12/3/2007 6:33:01 AM', 39355, 2, 2, 1 UNION ALL
SELECT	'12/3/2007 6:33:02 AM', 39355, 2, 3, 1 UNION ALL
SELECT	'12/3/2007 6:35:08 AM', 39355, 3, 1, 5 UNION ALL
SELECT	'12/3/2007 6:35:09 AM', 39355, 3, 2, 5 UNION ALL
SELECT	'12/3/2007 6:35:11 AM', 39355, 3, 3, 5 UNION ALL
SELECT	'12/3/2007 6:33:31 AM', 39355, 4, 1, 2 UNION ALL
SELECT	'12/3/2007 6:33:32 AM', 39355, 4, 2, 2 UNION ALL
SELECT	'12/3/2007 6:33:33 AM', 39355, 4, 3, 2 UNION ALL
SELECT	'12/3/2007 6:36:11 AM', 39355, 5, 1, 7 UNION ALL
SELECT	'12/3/2007 6:36:12 AM', 39355, 5, 2, 7 UNION ALL
SELECT	'12/3/2007 6:36:14 AM', 39355, 5, 3, 7 UNION ALL
SELECT	'12/3/2007 6:34:17 AM', 39355, 6, 1, 4 UNION ALL
SELECT	'12/3/2007 6:34:18 AM', 39355, 6, 2, 4 UNION ALL
SELECT	'12/3/2007 6:34:19 AM', 39355, 6, 3, 4 UNION ALL
SELECT	'12/3/2007 6:37:26 AM', 39355, 7, 1, 9 UNION ALL
SELECT	'12/3/2007 6:37:27 AM', 39355, 7, 2, 9 UNION ALL
SELECT	'12/3/2007 6:37:28 AM', 39355, 7, 3, 9 UNION ALL
SELECT	'12/3/2007 6:35:42 AM', 39355, 8, 1, 6 UNION ALL
SELECT	'12/3/2007 6:35:43 AM', 39355, 8, 2, 6 UNION ALL
SELECT	'12/3/2007 6:35:43 AM', 39355, 8, 3, 6 UNION ALL
SELECT	'12/3/2007 6:39:16 AM', 39355, 9, 1, 11 UNION ALL
SELECT	'12/3/2007 6:39:18 AM', 39355, 9, 2, 11 UNION ALL
SELECT	'12/3/2007 6:39:22 AM', 39355, 9, 3, 11 UNION ALL
SELECT	'12/3/2007 6:36:57 AM', 39355, 10, 1, 8 UNION ALL
SELECT	'12/3/2007 6:36:58 AM', 39355, 10, 2, 8 UNION ALL
SELECT	'12/3/2007 6:36:59 AM', 39355, 10, 3, 8 UNION ALL
SELECT	'12/3/2007 6:40:19 AM', 39355, 11, 1, 13 UNION ALL
SELECT	'12/3/2007 6:40:20 AM', 39355, 11, 2, 13 UNION ALL
SELECT	'12/3/2007 6:40:20 AM', 39355, 11, 3, 13 UNION ALL
SELECT	'12/3/2007 6:38:45 AM', 39355, 12, 1, 10 UNION ALL
SELECT	'12/3/2007 6:38:47 AM', 39355, 12, 2, 10 UNION ALL
SELECT	'12/3/2007 6:38:48 AM', 39355, 12, 3, 10 UNION ALL
SELECT	'12/3/2007 6:39:45 AM', 39355, 13, 1, 12 UNION ALL
SELECT	'12/3/2007 6:39:46 AM', 39355, 13, 2, 12 UNION ALL
SELECT	'12/3/2007 6:39:47 AM', 39355, 13, 3, 12 UNION ALL
SELECT	'12/3/2007 6:44:04 AM', 39356, 1, 1, 3 UNION ALL
SELECT	'12/3/2007 6:44:05 AM', 39356, 1, 2, 3 UNION ALL
SELECT	'12/3/2007 6:44:06 AM', 39356, 1, 3, 3 UNION ALL
SELECT	'12/3/2007 6:42:55 AM', 39356, 2, 1, 1 UNION ALL
SELECT	'12/3/2007 6:42:56 AM', 39356, 2, 2, 1 UNION ALL
SELECT	'12/3/2007 6:42:58 AM', 39356, 2, 3, 1 UNION ALL
SELECT	'12/3/2007 6:45:11 AM', 39356, 3, 1, 5 UNION ALL
SELECT	'12/3/2007 6:45:12 AM', 39356, 3, 2, 5 UNION ALL
SELECT	'12/3/2007 6:45:13 AM', 39356, 3, 3, 5 UNION ALL
SELECT	'12/3/2007 6:43:29 AM', 39356, 4, 1, 2 UNION ALL
SELECT	'12/3/2007 6:43:30 AM', 39356, 4, 2, 2 UNION ALL
SELECT	'12/3/2007 6:43:31 AM', 39356, 4, 3, 2 UNION ALL
SELECT	'12/3/2007 6:48:12 AM', 39356, 5, 1, 7 UNION ALL
SELECT	'12/3/2007 6:48:13 AM', 39356, 5, 2, 7 UNION ALL
SELECT	'12/3/2007 6:48:15 AM', 39356, 5, 3, 7 UNION ALL
SELECT	'12/3/2007 6:44:38 AM', 39356, 6, 1, 4 UNION ALL
SELECT	'12/3/2007 6:44:39 AM', 39356, 6, 2, 4 UNION ALL
SELECT	'12/3/2007 6:44:40 AM', 39356, 6, 3, 4 UNION ALL
SELECT	'12/3/2007 6:49:35 AM', 39356, 7, 1, 9 UNION ALL
SELECT	'12/3/2007 6:49:37 AM', 39356, 7, 2, 9 UNION ALL
SELECT	'12/3/2007 6:49:38 AM', 39356, 7, 3, 9 UNION ALL
SELECT	'12/3/2007 6:47:35 AM', 39356, 8, 1, 6 UNION ALL
SELECT	'12/3/2007 6:47:38 AM', 39356, 8, 2, 6 UNION ALL
SELECT	'12/3/2007 6:47:40 AM', 39356, 8, 3, 6 UNION ALL
SELECT	'12/3/2007 6:51:15 AM', 39356, 9, 1, 11 UNION ALL
SELECT	'12/3/2007 6:51:16 AM', 39356, 9, 2, 11 UNION ALL
SELECT	'12/3/2007 6:51:17 AM', 39356, 9, 3, 11 UNION ALL
SELECT	'12/3/2007 6:48:44 AM', 39356, 10, 1, 8 UNION ALL
SELECT	'12/3/2007 6:48:45 AM', 39356, 10, 2, 8 UNION ALL
SELECT	'12/3/2007 6:48:46 AM', 39356, 10, 3, 8 UNION ALL
SELECT	'12/3/2007 6:52:07 AM', 39356, 11, 1, 13 UNION ALL
SELECT	'12/3/2007 6:52:08 AM', 39356, 11, 2, 13 UNION ALL
SELECT	'12/3/2007 6:52:10 AM', 39356, 11, 3, 13 UNION ALL
SELECT	'12/3/2007 6:50:16 AM', 39356, 12, 1, 10 UNION ALL
SELECT	'12/3/2007 6:50:17 AM', 39356, 12, 2, 10 UNION ALL
SELECT	'12/3/2007 6:50:18 AM', 39356, 12, 3, 10 UNION ALL
SELECT	'12/3/2007 6:51:36 AM', 39356, 13, 1, 12 UNION ALL
SELECT	'12/3/2007 6:51:37 AM', 39356, 13, 2, 12 UNION ALL
SELECT	'12/3/2007 6:51:39 AM', 39356, 13, 3, 12 UNION ALL
SELECT	'12/3/2007 7:13:38 AM', 39357, 1, 1, 3 UNION ALL
SELECT	'12/3/2007 7:13:39 AM', 39357, 1, 2, 3 UNION ALL
SELECT	'12/3/2007 7:13:43 AM', 39357, 1, 3, 3 UNION ALL
SELECT	'12/3/2007 7:12:49 AM', 39357, 2, 1, 1 UNION ALL
SELECT	'12/3/2007 7:12:50 AM', 39357, 2, 2, 1 UNION ALL
SELECT	'12/3/2007 7:12:51 AM', 39357, 2, 3, 1 UNION ALL
SELECT	'12/3/2007 7:14:40 AM', 39357, 3, 1, 5 UNION ALL
SELECT	'12/3/2007 7:14:41 AM', 39357, 3, 2, 5 UNION ALL
SELECT	'12/3/2007 7:14:42 AM', 39357, 3, 3, 5 UNION ALL
SELECT	'12/3/2007 7:13:14 AM', 39357, 4, 1, 2 UNION ALL
SELECT	'12/3/2007 7:13:15 AM', 39357, 4, 2, 2 UNION ALL
SELECT	'12/3/2007 7:13:16 AM', 39357, 4, 3, 2 UNION ALL
SELECT	'12/3/2007 7:16:09 AM', 39357, 5, 1, 7 UNION ALL
SELECT	'12/3/2007 7:16:10 AM', 39357, 5, 2, 7 UNION ALL
SELECT	'12/3/2007 7:16:11 AM', 39357, 5, 3, 7 UNION ALL
SELECT	'12/3/2007 7:14:09 AM', 39357, 6, 1, 4 UNION ALL
SELECT	'12/3/2007 7:14:09 AM', 39357, 6, 2, 4 UNION ALL
SELECT	'12/3/2007 7:14:11 AM', 39357, 6, 3, 4 UNION ALL
SELECT	'12/3/2007 7:17:36 AM', 39357, 7, 1, 9 UNION ALL
SELECT	'12/3/2007 7:17:37 AM', 39357, 7, 2, 9 UNION ALL
SELECT	'12/3/2007 7:17:38 AM', 39357, 7, 3, 9 UNION ALL
SELECT	'12/3/2007 7:15:26 AM', 39357, 8, 1, 6 UNION ALL
SELECT	'12/3/2007 7:15:27 AM', 39357, 8, 2, 6 UNION ALL
SELECT	'12/3/2007 7:15:28 AM', 39357, 8, 3, 6 UNION ALL
SELECT	'12/3/2007 7:23:01 AM', 39357, 9, 1, 11 UNION ALL
SELECT	'12/3/2007 7:23:02 AM', 39357, 9, 2, 11 UNION ALL
SELECT	'12/3/2007 7:23:04 AM', 39357, 9, 3, 11 UNION ALL
SELECT	'12/3/2007 7:16:40 AM', 39357, 10, 1, 8 UNION ALL
SELECT	'12/3/2007 7:16:41 AM', 39357, 10, 2, 8 UNION ALL
SELECT	'12/3/2007 7:16:46 AM', 39357, 10, 3, 8 UNION ALL
SELECT	'12/3/2007 7:23:11 AM', 39357, 11, 1, 13 UNION ALL
SELECT	'12/3/2007 7:23:12 AM', 39357, 11, 2, 13 UNION ALL
SELECT	'12/3/2007 7:23:13 AM', 39357, 11, 3, 13 UNION ALL
SELECT	'12/3/2007 7:19:52 AM', 39357, 12, 1, 10 UNION ALL
SELECT	'12/3/2007 7:19:53 AM', 39357, 12, 2, 10 UNION ALL
SELECT	'12/3/2007 7:19:55 AM', 39357, 12, 3, 10 UNION ALL
SELECT	'12/3/2007 7:23:05 AM', 39357, 13, 1, 12 UNION ALL
SELECT	'12/3/2007 7:23:07 AM', 39357, 13, 2, 12 UNION ALL
SELECT	'12/3/2007 7:23:08 AM', 39357, 13, 3, 12 UNION ALL
SELECT	'12/3/2007 7:26:56 AM', 39358, 1, 1, 3 UNION ALL
SELECT	'12/3/2007 7:26:57 AM', 39358, 1, 2, 3 UNION ALL
SELECT	'12/3/2007 7:26:58 AM', 39358, 1, 3, 3 UNION ALL
SELECT	'12/3/2007 7:25:33 AM', 39358, 2, 1, 1 UNION ALL
SELECT	'12/3/2007 7:25:34 AM', 39358, 2, 2, 1 UNION ALL
SELECT	'12/3/2007 7:25:35 AM', 39358, 2, 3, 1 UNION ALL
SELECT	'12/3/2007 7:31:45 AM', 39358, 3, 1, 5 UNION ALL
SELECT	'12/3/2007 7:31:46 AM', 39358, 3, 2, 5 UNION ALL
SELECT	'12/3/2007 7:31:47 AM', 39358, 3, 3, 5 UNION ALL
SELECT	'12/3/2007 7:26:19 AM', 39358, 4, 1, 2 UNION ALL
SELECT	'12/3/2007 7:26:20 AM', 39358, 4, 2, 2 UNION ALL
SELECT	'12/3/2007 7:26:21 AM', 39358, 4, 3, 2 UNION ALL
SELECT	'12/3/2007 7:32:31 AM', 39358, 5, 1, 7 UNION ALL
SELECT	'12/3/2007 7:32:32 AM', 39358, 5, 2, 7 UNION ALL
SELECT	'12/3/2007 7:32:33 AM', 39358, 5, 3, 7 UNION ALL
SELECT	'12/3/2007 7:27:42 AM', 39358, 6, 1, 4 UNION ALL
SELECT	'12/3/2007 7:27:43 AM', 39358, 6, 2, 4 UNION ALL
SELECT	'12/3/2007 7:27:44 AM', 39358, 6, 3, 4 UNION ALL
SELECT	'12/3/2007 7:33:22 AM', 39358, 7, 1, 9 UNION ALL
SELECT	'12/3/2007 7:33:22 AM', 39358, 7, 2, 9 UNION ALL
SELECT	'12/3/2007 7:33:23 AM', 39358, 7, 3, 9 UNION ALL
SELECT	'12/3/2007 7:32:10 AM', 39358, 8, 1, 6 UNION ALL
SELECT	'12/3/2007 7:32:11 AM', 39358, 8, 2, 6 UNION ALL
SELECT	'12/3/2007 7:32:12 AM', 39358, 8, 3, 6 UNION ALL
SELECT	'12/3/2007 7:34:18 AM', 39358, 9, 1, 11 UNION ALL
SELECT	'12/3/2007 7:34:19 AM', 39358, 9, 2, 11 UNION ALL
SELECT	'12/3/2007 7:34:22 AM', 39358, 9, 3, 11 UNION ALL
SELECT	'12/3/2007 7:32:50 AM', 39358, 10, 1, 8 UNION ALL
SELECT	'12/3/2007 7:32:51 AM', 39358, 10, 2, 8 UNION ALL
SELECT	'12/3/2007 7:32:52 AM', 39358, 10, 3, 8 UNION ALL
SELECT	'12/3/2007 7:35:34 AM', 39358, 11, 1, 13 UNION ALL
SELECT	'12/3/2007 7:35:35 AM', 39358, 11, 2, 13 UNION ALL
SELECT	'12/3/2007 7:35:36 AM', 39358, 11, 3, 13 UNION ALL
SELECT	'12/3/2007 7:33:45 AM', 39358, 12, 1, 10 UNION ALL
SELECT	'12/3/2007 7:33:46 AM', 39358, 12, 2, 10 UNION ALL
SELECT	'12/3/2007 7:33:47 AM', 39358, 12, 3, 10 UNION ALL
SELECT	'12/3/2007 7:35:02 AM', 39358, 13, 1, 12 UNION ALL
SELECT	'12/3/2007 7:35:03 AM', 39358, 13, 2, 12 UNION ALL
SELECT	'12/3/2007 7:35:04 AM', 39358, 13, 3, 12 UNION ALL
SELECT	'12/3/2007 7:38:17 AM', 39359, 1, 1, 3 UNION ALL
SELECT	'12/3/2007 7:38:18 AM', 39359, 1, 2, 3 UNION ALL
SELECT	'12/3/2007 7:38:19 AM', 39359, 1, 3, 3 UNION ALL
SELECT	'12/3/2007 7:37:05 AM', 39359, 2, 1, 1 UNION ALL
SELECT	'12/3/2007 7:37:06 AM', 39359, 2, 2, 1 UNION ALL
SELECT	'12/3/2007 7:37:07 AM', 39359, 2, 3, 1 UNION ALL
SELECT	'12/3/2007 7:39:21 AM', 39359, 3, 1, 5 UNION ALL
SELECT	'12/3/2007 7:39:22 AM', 39359, 3, 2, 5 UNION ALL
SELECT	'12/3/2007 7:39:25 AM', 39359, 3, 3, 5 UNION ALL
SELECT	'12/3/2007 7:37:47 AM', 39359, 4, 1, 2 UNION ALL
SELECT	'12/3/2007 7:37:48 AM', 39359, 4, 2, 2 UNION ALL
SELECT	'12/3/2007 7:37:49 AM', 39359, 4, 3, 2 UNION ALL
SELECT	'12/3/2007 7:40:31 AM', 39359, 5, 1, 7 UNION ALL
SELECT	'12/3/2007 7:40:33 AM', 39359, 5, 2, 7 UNION ALL
SELECT	'12/3/2007 7:40:34 AM', 39359, 5, 3, 7 UNION ALL
SELECT	'12/3/2007 7:38:50 AM', 39359, 6, 1, 4 UNION ALL
SELECT	'12/3/2007 7:38:51 AM', 39359, 6, 2, 4 UNION ALL
SELECT	'12/3/2007 7:38:53 AM', 39359, 6, 3, 4 UNION ALL
SELECT	'12/3/2007 7:41:39 AM', 39359, 7, 1, 9 UNION ALL
SELECT	'12/3/2007 7:41:40 AM', 39359, 7, 2, 9 UNION ALL
SELECT	'12/3/2007 7:41:42 AM', 39359, 7, 3, 9 UNION ALL
SELECT	'12/3/2007 7:39:53 AM', 39359, 8, 1, 6 UNION ALL
SELECT	'12/3/2007 7:39:54 AM', 39359, 8, 2, 6 UNION ALL
SELECT	'12/3/2007 7:39:55 AM', 39359, 8, 3, 6 UNION ALL
SELECT	'12/3/2007 7:42:44 AM', 39359, 9, 1, 11 UNION ALL
SELECT	'12/3/2007 7:42:45 AM', 39359, 9, 2, 11 UNION ALL
SELECT	'12/3/2007 7:42:49 AM', 39359, 9, 3, 11 UNION ALL
SELECT	'12/3/2007 7:41:06 AM', 39359, 10, 1, 8 UNION ALL
SELECT	'12/3/2007 7:41:07 AM', 39359, 10, 2, 8 UNION ALL
SELECT	'12/3/2007 7:41:08 AM', 39359, 10, 3, 8 UNION ALL
SELECT	'12/3/2007 7:43:54 AM', 39359, 11, 1, 13 UNION ALL
SELECT	'12/3/2007 7:43:55 AM', 39359, 11, 2, 13 UNION ALL
SELECT	'12/3/2007 7:43:56 AM', 39359, 11, 3, 13 UNION ALL
SELECT	'12/3/2007 7:42:02 AM', 39359, 12, 1, 10 UNION ALL
SELECT	'12/3/2007 7:42:13 AM', 39359, 12, 2, 10 UNION ALL
SELECT	'12/3/2007 7:42:14 AM', 39359, 12, 3, 10 UNION ALL
SELECT	'12/3/2007 7:43:10 AM', 39359, 13, 1, 12 UNION ALL
SELECT	'12/3/2007 7:43:11 AM', 39359, 13, 2, 12 UNION ALL
SELECT	'12/3/2007 7:43:13 AM', 39359, 13, 3, 12 UNION ALL
SELECT	'12/3/2007 7:46:25 AM', 39360, 1, 1, 3 UNION ALL
SELECT	'12/3/2007 7:46:26 AM', 39360, 1, 2, 3 UNION ALL
SELECT	'12/3/2007 7:46:28 AM', 39360, 1, 3, 3 UNION ALL
SELECT	'12/3/2007 7:45:33 AM', 39360, 2, 1, 1 UNION ALL
SELECT	'12/3/2007 7:45:34 AM', 39360, 2, 2, 1 UNION ALL
SELECT	'12/3/2007 7:45:36 AM', 39360, 2, 3, 1 UNION ALL
SELECT	'12/3/2007 7:47:15 AM', 39360, 3, 1, 5 UNION ALL
SELECT	'12/3/2007 7:47:16 AM', 39360, 3, 2, 5 UNION ALL
SELECT	'12/3/2007 7:47:18 AM', 39360, 3, 3, 5 UNION ALL
SELECT	'12/3/2007 7:46:01 AM', 39360, 4, 1, 2 UNION ALL
SELECT	'12/3/2007 7:46:02 AM', 39360, 4, 2, 2 UNION ALL
SELECT	'12/3/2007 7:46:04 AM', 39360, 4, 3, 2 UNION ALL
SELECT	'12/3/2007 7:48:15 AM', 39360, 5, 1, 7 UNION ALL
SELECT	'12/3/2007 7:48:16 AM', 39360, 5, 2, 7 UNION ALL
SELECT	'12/3/2007 7:48:18 AM', 39360, 5, 3, 7 UNION ALL
SELECT	'12/3/2007 7:46:49 AM', 39360, 6, 1, 4 UNION ALL
SELECT	'12/3/2007 7:46:50 AM', 39360, 6, 2, 4 UNION ALL
SELECT	'12/3/2007 7:46:51 AM', 39360, 6, 3, 4 UNION ALL
SELECT	'12/3/2007 7:50:01 AM', 39360, 7, 1, 9 UNION ALL
SELECT	'12/3/2007 7:50:02 AM', 39360, 7, 2, 9 UNION ALL
SELECT	'12/3/2007 7:50:04 AM', 39360, 7, 3, 9 UNION ALL
SELECT	'12/3/2007 7:47:46 AM', 39360, 8, 1, 6 UNION ALL
SELECT	'12/3/2007 7:47:48 AM', 39360, 8, 2, 6 UNION ALL
SELECT	'12/3/2007 7:47:49 AM', 39360, 8, 3, 6 UNION ALL
SELECT	'12/3/2007 7:50:54 AM', 39360, 9, 1, 11 UNION ALL
SELECT	'12/3/2007 7:50:55 AM', 39360, 9, 2, 11 UNION ALL
SELECT	'12/3/2007 7:50:58 AM', 39360, 9, 3, 11 UNION ALL
SELECT	'12/3/2007 7:49:42 AM', 39360, 10, 1, 8 UNION ALL
SELECT	'12/3/2007 7:49:43 AM', 39360, 10, 2, 8 UNION ALL
SELECT	'12/3/2007 7:49:45 AM', 39360, 10, 3, 8 UNION ALL
SELECT	'12/3/2007 7:51:34 AM', 39360, 11, 1, 13 UNION ALL
SELECT	'12/3/2007 7:51:35 AM', 39360, 11, 2, 13 UNION ALL
SELECT	'12/3/2007 7:51:36 AM', 39360, 11, 3, 13 UNION ALL
SELECT	'12/3/2007 7:50:30 AM', 39360, 12, 1, 10 UNION ALL
SELECT	'12/3/2007 7:50:31 AM', 39360, 12, 2, 10 UNION ALL
SELECT	'12/3/2007 7:50:32 AM', 39360, 12, 3, 10 UNION ALL
SELECT	'12/3/2007 7:51:16 AM', 39360, 13, 1, 12 UNION ALL
SELECT	'12/3/2007 7:51:17 AM', 39360, 13, 2, 12 UNION ALL
SELECT	'12/3/2007 7:51:18 AM', 39360, 13, 3, 12

SELECT	LoadID,
	DATEDIFF(MINUTE, mi, ma) AS DiffMinutes
FROM	(
		SELECT		LoadID,
				MIN(ProcessDate) AS mi,
				MAX(ProcessDate) AS ma
		FROM		@Sample
		WHERE		(BatchSequence = 2 AND ScanSequence = 1)
				OR (BatchSequence = 13 AND ScanSequence = 3)
		GROUP BY	LoadID
	) AS d


E 12°55'05.25"
N 56°04'39.16"
Go to Top of Page

swl681
Starting Member

15 Posts
Posted - 2007-12-07 : 11:03:12
You are correct I apologize for not being more clear, I am reposting the correct sample data below. As you can see the ScanSequence works out much better than the BatchSequence. I appreacite your time and patience with me and I will try and be more clear, thank you again.

ProcessDate LoadSequence ScanSequence LoadID
12/3/2007 6:07:17 AM 2 1 39353
12/3/2007 6:07:48 AM 2 2 39353
12/3/2007 6:07:49 AM 2 3 39353
12/3/2007 6:08:22 AM 4 1 39353
12/3/2007 6:08:23 AM 4 2 39353
12/3/2007 6:08:25 AM 4 3 39353
12/3/2007 6:09:16 AM 1 1 39353
12/3/2007 6:09:17 AM 1 2 39353
12/3/2007 6:09:19 AM 1 3 39353
12/3/2007 6:09:49 AM 6 1 39353
12/3/2007 6:09:50 AM 6 2 39353
12/3/2007 6:09:51 AM 6 3 39353
12/3/2007 6:10:17 AM 3 1 39353
12/3/2007 6:10:18 AM 3 2 39353
12/3/2007 6:10:19 AM 3 3 39353
12/3/2007 6:10:53 AM 8 1 39353
12/3/2007 6:10:54 AM 8 2 39353
12/3/2007 6:10:55 AM 8 3 39353
12/3/2007 6:11:21 AM 5 1 39353
12/3/2007 6:11:23 AM 5 2 39353
12/3/2007 6:11:23 AM 5 3 39353
12/3/2007 6:12:01 AM 10 1 39353
12/3/2007 6:12:02 AM 10 2 39353
12/3/2007 6:12:03 AM 10 3 39353
12/3/2007 6:12:41 AM 7 1 39353
12/3/2007 6:12:42 AM 7 2 39353
12/3/2007 6:12:43 AM 7 3 39353
12/3/2007 6:13:19 AM 12 1 39353
12/3/2007 6:13:20 AM 12 2 39353
12/3/2007 6:13:21 AM 12 3 39353
12/3/2007 6:13:47 AM 9 1 39353
12/3/2007 6:13:48 AM 9 2 39353
12/3/2007 6:13:51 AM 9 3 39353
12/3/2007 6:14:31 AM 13 1 39353
12/3/2007 6:14:33 AM 13 2 39353
12/3/2007 6:14:36 AM 13 3 39353
12/3/2007 6:15:07 AM 11 1 39353
12/3/2007 6:15:08 AM 11 2 39353
12/3/2007 6:15:09 AM 11 3 39353
12/3/2007 6:17:24 AM 2 1 39354
12/3/2007 6:17:25 AM 2 2 39354
12/3/2007 6:17:26 AM 2 3 39354
12/3/2007 6:17:53 AM 4 1 39354
12/3/2007 6:17:54 AM 4 2 39354
12/3/2007 6:17:55 AM 4 3 39354
12/3/2007 6:18:55 AM 1 1 39354
12/3/2007 6:18:56 AM 1 2 39354
12/3/2007 6:18:58 AM 1 3 39354
12/3/2007 6:19:37 AM 6 1 39354
12/3/2007 6:19:38 AM 6 2 39354
12/3/2007 6:19:39 AM 6 3 39354
12/3/2007 6:20:29 AM 3 1 39354
12/3/2007 6:20:30 AM 3 2 39354
12/3/2007 6:20:31 AM 3 3 39354
12/3/2007 6:21:07 AM 8 1 39354
12/3/2007 6:21:08 AM 8 2 39354
12/3/2007 6:21:09 AM 8 3 39354
12/3/2007 6:22:01 AM 5 1 39354
12/3/2007 6:22:02 AM 5 2 39354
12/3/2007 6:22:04 AM 5 3 39354
12/3/2007 6:22:42 AM 10 1 39354
12/3/2007 6:22:43 AM 10 2 39354
12/3/2007 6:22:44 AM 10 3 39354
12/3/2007 6:23:08 AM 7 1 39354
12/3/2007 6:23:09 AM 7 2 39354
12/3/2007 6:23:10 AM 7 3 39354
12/3/2007 6:24:34 AM 12 1 39354
12/3/2007 6:24:35 AM 12 2 39354
12/3/2007 6:24:36 AM 12 3 39354
12/3/2007 6:25:10 AM 9 1 39354
12/3/2007 6:25:10 AM 9 2 39354
12/3/2007 6:25:11 AM 9 3 39354
12/3/2007 6:25:41 AM 13 1 39354
12/3/2007 6:25:42 AM 13 2 39354
12/3/2007 6:25:43 AM 13 3 39354
12/3/2007 6:26:10 AM 11 1 39354
12/3/2007 6:26:11 AM 11 2 39354
12/3/2007 6:26:12 AM 11 3 39354
12/3/2007 6:33:00 AM 2 1 39355
12/3/2007 6:33:01 AM 2 2 39355
12/3/2007 6:33:02 AM 2 3 39355
12/3/2007 6:33:31 AM 4 1 39355
12/3/2007 6:33:32 AM 4 2 39355
12/3/2007 6:33:33 AM 4 3 39355
12/3/2007 6:33:54 AM 1 1 39355
12/3/2007 6:33:55 AM 1 2 39355
12/3/2007 6:33:57 AM 1 3 39355
12/3/2007 6:34:17 AM 6 1 39355
12/3/2007 6:34:18 AM 6 2 39355
12/3/2007 6:34:19 AM 6 3 39355
12/3/2007 6:35:08 AM 3 1 39355
12/3/2007 6:35:09 AM 3 2 39355
12/3/2007 6:35:11 AM 3 3 39355
12/3/2007 6:35:42 AM 8 1 39355
12/3/2007 6:35:43 AM 8 2 39355
12/3/2007 6:35:43 AM 8 3 39355
12/3/2007 6:36:11 AM 5 1 39355
12/3/2007 6:36:12 AM 5 2 39355
12/3/2007 6:36:14 AM 5 3 39355
12/3/2007 6:36:57 AM 10 1 39355
12/3/2007 6:36:58 AM 10 2 39355
12/3/2007 6:36:59 AM 10 3 39355
12/3/2007 6:37:26 AM 7 1 39355
12/3/2007 6:37:27 AM 7 2 39355
12/3/2007 6:37:28 AM 7 3 39355
12/3/2007 6:38:45 AM 12 1 39355
12/3/2007 6:38:47 AM 12 2 39355
12/3/2007 6:38:48 AM 12 3 39355
12/3/2007 6:39:16 AM 9 1 39355
12/3/2007 6:39:18 AM 9 2 39355
12/3/2007 6:39:22 AM 9 3 39355
12/3/2007 6:39:45 AM 13 1 39355
12/3/2007 6:39:46 AM 13 2 39355
12/3/2007 6:39:47 AM 13 3 39355
12/3/2007 6:40:19 AM 11 1 39355
12/3/2007 6:40:20 AM 11 2 39355
12/3/2007 6:40:20 AM 11 3 39355
12/3/2007 6:42:55 AM 2 1 39356
12/3/2007 6:42:56 AM 2 2 39356
12/3/2007 6:42:58 AM 2 3 39356
12/3/2007 6:43:29 AM 4 1 39356
12/3/2007 6:43:30 AM 4 2 39356
12/3/2007 6:43:31 AM 4 3 39356
12/3/2007 6:44:04 AM 1 1 39356
12/3/2007 6:44:05 AM 1 2 39356
12/3/2007 6:44:06 AM 1 3 39356
12/3/2007 6:44:38 AM 6 1 39356
12/3/2007 6:44:39 AM 6 2 39356
12/3/2007 6:44:40 AM 6 3 39356
12/3/2007 6:45:11 AM 3 1 39356
12/3/2007 6:45:12 AM 3 2 39356
12/3/2007 6:45:13 AM 3 3 39356
12/3/2007 6:47:35 AM 8 1 39356
12/3/2007 6:47:38 AM 8 2 39356
12/3/2007 6:47:40 AM 8 3 39356
12/3/2007 6:48:12 AM 5 1 39356
12/3/2007 6:48:13 AM 5 2 39356
12/3/2007 6:48:15 AM 5 3 39356
12/3/2007 6:48:44 AM 10 1 39356
12/3/2007 6:48:45 AM 10 2 39356
12/3/2007 6:48:46 AM 10 3 39356
12/3/2007 6:49:35 AM 7 1 39356
12/3/2007 6:49:37 AM 7 2 39356
12/3/2007 6:49:38 AM 7 3 39356
12/3/2007 6:50:16 AM 12 1 39356
12/3/2007 6:50:17 AM 12 2 39356
12/3/2007 6:50:18 AM 12 3 39356
12/3/2007 6:51:15 AM 9 1 39356
12/3/2007 6:51:16 AM 9 2 39356
12/3/2007 6:51:17 AM 9 3 39356
12/3/2007 6:51:36 AM 13 1 39356
12/3/2007 6:51:37 AM 13 2 39356
12/3/2007 6:51:39 AM 13 3 39356
12/3/2007 6:52:07 AM 11 1 39356
12/3/2007 6:52:08 AM 11 2 39356
12/3/2007 6:52:10 AM 11 3 39356
12/3/2007 7:12:49 AM 2 1 39357
12/3/2007 7:12:50 AM 2 2 39357
12/3/2007 7:12:51 AM 2 3 39357
12/3/2007 7:13:14 AM 4 1 39357
12/3/2007 7:13:15 AM 4 2 39357
12/3/2007 7:13:16 AM 4 3 39357
12/3/2007 7:13:38 AM 1 1 39357
12/3/2007 7:13:39 AM 1 2 39357
12/3/2007 7:13:43 AM 1 3 39357
12/3/2007 7:14:09 AM 6 1 39357
12/3/2007 7:14:09 AM 6 2 39357
12/3/2007 7:14:11 AM 6 3 39357
12/3/2007 7:14:40 AM 3 1 39357
12/3/2007 7:14:41 AM 3 2 39357
12/3/2007 7:14:42 AM 3 3 39357
12/3/2007 7:15:26 AM 8 1 39357
12/3/2007 7:15:27 AM 8 2 39357
12/3/2007 7:15:28 AM 8 3 39357
12/3/2007 7:16:09 AM 5 1 39357
12/3/2007 7:16:10 AM 5 2 39357
12/3/2007 7:16:11 AM 5 3 39357
12/3/2007 7:16:40 AM 10 1 39357
12/3/2007 7:16:41 AM 10 2 39357
12/3/2007 7:16:46 AM 10 3 39357
12/3/2007 7:17:36 AM 7 1 39357
12/3/2007 7:17:37 AM 7 2 39357
12/3/2007 7:17:38 AM 7 3 39357
12/3/2007 7:19:52 AM 12 1 39357
12/3/2007 7:19:53 AM 12 2 39357
12/3/2007 7:19:55 AM 12 3 39357
12/3/2007 7:23:01 AM 9 1 39357
12/3/2007 7:23:02 AM 9 2 39357
12/3/2007 7:23:04 AM 9 3 39357
12/3/2007 7:23:05 AM 13 1 39357
12/3/2007 7:23:07 AM 13 2 39357
12/3/2007 7:23:08 AM 13 3 39357
12/3/2007 7:23:11 AM 11 1 39357
12/3/2007 7:23:12 AM 11 2 39357
12/3/2007 7:23:13 AM 11 3 39357
12/3/2007 7:25:33 AM 2 1 39358
12/3/2007 7:25:34 AM 2 2 39358
12/3/2007 7:25:35 AM 2 3 39358
12/3/2007 7:26:19 AM 4 1 39358
12/3/2007 7:26:20 AM 4 2 39358
12/3/2007 7:26:21 AM 4 3 39358
12/3/2007 7:26:56 AM 1 1 39358
12/3/2007 7:26:57 AM 1 2 39358
12/3/2007 7:26:58 AM 1 3 39358
12/3/2007 7:27:42 AM 6 1 39358
12/3/2007 7:27:43 AM 6 2 39358
12/3/2007 7:27:44 AM 6 3 39358
12/3/2007 7:31:45 AM 3 1 39358
12/3/2007 7:31:46 AM 3 2 39358
12/3/2007 7:31:47 AM 3 3 39358
12/3/2007 7:32:10 AM 8 1 39358
12/3/2007 7:32:11 AM 8 2 39358
12/3/2007 7:32:12 AM 8 3 39358
12/3/2007 7:32:31 AM 5 1 39358
12/3/2007 7:32:32 AM 5 2 39358
12/3/2007 7:32:33 AM 5 3 39358
12/3/2007 7:32:50 AM 10 1 39358
12/3/2007 7:32:51 AM 10 2 39358
12/3/2007 7:32:52 AM 10 3 39358
12/3/2007 7:33:22 AM 7 1 39358
12/3/2007 7:33:22 AM 7 2 39358
12/3/2007 7:33:23 AM 7 3 39358
12/3/2007 7:33:45 AM 12 1 39358
12/3/2007 7:33:46 AM 12 2 39358
12/3/2007 7:33:47 AM 12 3 39358
12/3/2007 7:34:18 AM 9 1 39358
12/3/2007 7:34:19 AM 9 2 39358
12/3/2007 7:34:22 AM 9 3 39358
12/3/2007 7:35:02 AM 13 1 39358
12/3/2007 7:35:03 AM 13 2 39358
12/3/2007 7:35:04 AM 13 3 39358
12/3/2007 7:35:34 AM 11 1 39358
12/3/2007 7:35:35 AM 11 2 39358
12/3/2007 7:35:36 AM 11 3 39358
12/3/2007 7:37:05 AM 2 1 39359
12/3/2007 7:37:06 AM 2 2 39359
12/3/2007 7:37:07 AM 2 3 39359
12/3/2007 7:37:47 AM 4 1 39359
12/3/2007 7:37:48 AM 4 2 39359
12/3/2007 7:37:49 AM 4 3 39359
12/3/2007 7:38:17 AM 1 1 39359
12/3/2007 7:38:18 AM 1 2 39359
12/3/2007 7:38:19 AM 1 3 39359
12/3/2007 7:38:50 AM 6 1 39359
12/3/2007 7:38:51 AM 6 2 39359
12/3/2007 7:38:53 AM 6 3 39359
12/3/2007 7:39:21 AM 3 1 39359
12/3/2007 7:39:22 AM 3 2 39359
12/3/2007 7:39:25 AM 3 3 39359
12/3/2007 7:39:53 AM 8 1 39359
12/3/2007 7:39:54 AM 8 2 39359
12/3/2007 7:39:55 AM 8 3 39359
12/3/2007 7:40:31 AM 5 1 39359
12/3/2007 7:40:33 AM 5 2 39359
12/3/2007 7:40:34 AM 5 3 39359
12/3/2007 7:41:06 AM 10 1 39359
12/3/2007 7:41:07 AM 10 2 39359
12/3/2007 7:41:08 AM 10 3 39359
12/3/2007 7:41:39 AM 7 1 39359
12/3/2007 7:41:40 AM 7 2 39359
12/3/2007 7:41:42 AM 7 3 39359
12/3/2007 7:42:02 AM 12 1 39359
12/3/2007 7:42:13 AM 12 2 39359
12/3/2007 7:42:14 AM 12 3 39359
12/3/2007 7:42:44 AM 9 1 39359
12/3/2007 7:42:45 AM 9 2 39359
12/3/2007 7:42:49 AM 9 3 39359
12/3/2007 7:43:10 AM 13 1 39359
12/3/2007 7:43:11 AM 13 2 39359
12/3/2007 7:43:13 AM 13 3 39359
12/3/2007 7:43:54 AM 11 1 39359
12/3/2007 7:43:55 AM 11 2 39359
12/3/2007 7:43:56 AM 11 3 39359
12/3/2007 7:45:33 AM 2 1 39360
12/3/2007 7:45:34 AM 2 2 39360
12/3/2007 7:45:36 AM 2 3 39360
12/3/2007 7:46:01 AM 4 1 39360
12/3/2007 7:46:02 AM 4 2 39360
12/3/2007 7:46:04 AM 4 3 39360
12/3/2007 7:46:25 AM 1 1 39360
12/3/2007 7:46:26 AM 1 2 39360
12/3/2007 7:46:28 AM 1 3 39360
12/3/2007 7:46:49 AM 6 1 39360
12/3/2007 7:46:50 AM 6 2 39360
12/3/2007 7:46:51 AM 6 3 39360
12/3/2007 7:47:15 AM 3 1 39360
12/3/2007 7:47:16 AM 3 2 39360
12/3/2007 7:47:18 AM 3 3 39360
12/3/2007 7:47:46 AM 8 1 39360
12/3/2007 7:47:48 AM 8 2 39360
12/3/2007 7:47:49 AM 8 3 39360
12/3/2007 7:48:15 AM 5 1 39360
12/3/2007 7:48:16 AM 5 2 39360
12/3/2007 7:48:18 AM 5 3 39360
12/3/2007 7:49:42 AM 10 1 39360
12/3/2007 7:49:43 AM 10 2 39360
12/3/2007 7:49:45 AM 10 3 39360
12/3/2007 7:50:01 AM 7 1 39360
12/3/2007 7:50:02 AM 7 2 39360
12/3/2007 7:50:04 AM 7 3 39360
12/3/2007 7:50:30 AM 12 1 39360
12/3/2007 7:50:31 AM 12 2 39360
12/3/2007 7:50:32 AM 12 3 39360
12/3/2007 7:50:54 AM 9 1 39360
12/3/2007 7:50:55 AM 9 2 39360
12/3/2007 7:50:58 AM 9 3 39360
12/3/2007 7:51:16 AM 13 1 39360
12/3/2007 7:51:17 AM 13 2 39360
12/3/2007 7:51:18 AM 13 3 39360
12/3/2007 7:51:34 AM 11 1 39360
12/3/2007 7:51:35 AM 11 2 39360
12/3/2007 7:51:36 AM 11 3 39360
12/3/2007 7:52:16 AM 2 1 39361
12/3/2007 7:52:16 AM 2 2 39361
12/3/2007 7:52:17 AM 2 3 39361
12/3/2007 7:52:45 AM 4 1 39361
12/3/2007 7:52:46 AM 4 2 39361
12/3/2007 7:52:47 AM 4 3 39361
12/3/2007 7:53:04 AM 1 1 39361
12/3/2007 7:53:05 AM 1 2 39361
12/3/2007 7:53:06 AM 1 3 39361
12/3/2007 7:54:56 AM 6 1 39361
12/3/2007 7:54:57 AM 6 2 39361
12/3/2007 7:55:00 AM 6 3 39361
12/3/2007 7:55:30 AM 3 1 39361
12/3/2007 7:55:32 AM 3 2 39361
12/3/2007 7:55:35 AM 3 3 39361
12/3/2007 7:56:34 AM 8 1 39361
12/3/2007 7:56:36 AM 8 2 39361
12/3/2007 7:56:36 AM 8 3 39361
12/3/2007 7:57:17 AM 5 1 39361
12/3/2007 7:57:18 AM 5 2 39361
12/3/2007 7:57:19 AM 5 3 39361
12/3/2007 7:57:42 AM 10 1 39361
12/3/2007 7:57:43 AM 10 2 39361
12/3/2007 7:57:45 AM 10 3 39361
12/3/2007 7:58:14 AM 7 1 39361
12/3/2007 7:58:15 AM 7 2 39361
12/3/2007 7:58:18 AM 7 3 39361
12/3/2007 7:59:47 AM 12 1 39361
12/3/2007 7:59:49 AM 12 2 39361
12/3/2007 7:59:51 AM 12 3 39361
12/3/2007 8:00:09 AM 9 1 39361
12/3/2007 8:00:10 AM 9 2 39361
12/3/2007 8:00:12 AM 9 3 39361
12/3/2007 8:00:36 AM 13 1 39361
12/3/2007 8:00:38 AM 13 2 39361
12/3/2007 8:00:39 AM 13 3 39361
12/3/2007 8:01:01 AM 11 1 39361
12/3/2007 8:01:02 AM 11 2 39361
12/3/2007 8:01:03 AM 11 3 39361
12/3/2007 8:31:29 AM 2 1 39362
12/3/2007 8:31:30 AM 2 2 39362
12/3/2007 8:31:33 AM 2 3 39362
12/3/2007 8:32:37 AM 4 1 39362
12/3/2007 8:32:38 AM 4 2 39362
12/3/2007 8:32:39 AM 4 3 39362
12/3/2007 8:33:00 AM 1 1 39362
12/3/2007 8:33:00 AM 1 2 39362
12/3/2007 8:33:02 AM 1 3 39362
12/3/2007 8:33:28 AM 6 1 39362
12/3/2007 8:33:29 AM 6 2 39362
12/3/2007 8:33:30 AM 6 3 39362
12/3/2007 8:33:58 AM 3 1 39362
12/3/2007 8:34:00 AM 3 2 39362
12/3/2007 8:34:02 AM 3 3 39362
12/3/2007 8:35:57 AM 8 1 39362
12/3/2007 8:35:57 AM 8 2 39362
12/3/2007 8:35:59 AM 8 3 39362
12/3/2007 8:36:32 AM 5 1 39362
12/3/2007 8:36:33 AM 5 2 39362
12/3/2007 8:36:34 AM 5 3 39362
12/3/2007 8:36:51 AM 10 1 39362
12/3/2007 8:36:52 AM 10 2 39362
12/3/2007 8:36:54 AM 10 3 39362
12/3/2007 8:37:17 AM 7 1 39362
12/3/2007 8:37:18 AM 7 2 39362
12/3/2007 8:37:19 AM 7 3 39362
12/3/2007 8:37:39 AM 12 1 39362
12/3/2007 8:37:41 AM 12 2 39362
12/3/2007 8:37:41 AM 12 3 39362
12/3/2007 8:38:08 AM 9 1 39362
12/3/2007 8:38:09 AM 9 2 39362
12/3/2007 8:38:13 AM 9 3 39362
12/3/2007 8:38:38 AM 13 1 39362
12/3/2007 8:38:39 AM 13 2 39362
12/3/2007 8:38:41 AM 13 3 39362
12/3/2007 8:39:10 AM 11 1 39362
12/3/2007 8:39:12 AM 11 2 39362
12/3/2007 8:39:14 AM 11 3 39362
12/3/2007 8:40:27 AM 2 1 39363
12/3/2007 8:40:28 AM 2 2 39363
12/3/2007 8:40:29 AM 2 3 39363
12/3/2007 8:44:23 AM 4 1 39363
12/3/2007 8:44:24 AM 4 2 39363
12/3/2007 8:44:25 AM 4 3 39363
12/3/2007 8:46:49 AM 1 1 39363
12/3/2007 8:46:50 AM 1 2 39363
12/3/2007 8:46:51 AM 1 3 39363
12/3/2007 8:47:32 AM 6 1 39363
12/3/2007 8:47:34 AM 6 2 39363
12/3/2007 8:47:36 AM 6 3 39363
12/3/2007 8:48:06 AM 3 1 39363
12/3/2007 8:48:08 AM 3 2 39363
12/3/2007 8:48:09 AM 3 3 39363
12/3/2007 8:48:37 AM 8 1 39363
12/3/2007 8:48:39 AM 8 2 39363
12/3/2007 8:48:40 AM 8 3 39363
12/3/2007 8:49:11 AM 5 1 39363
12/3/2007 8:49:12 AM 5 2 39363
12/3/2007 8:49:13 AM 5 3 39363
12/3/2007 8:49:36 AM 10 1 39363
12/3/2007 8:49:37 AM 10 2 39363
12/3/2007 8:49:38 AM 10 3 39363
12/3/2007 8:50:24 AM 7 1 39363
12/3/2007 8:50:25 AM 7 2 39363
12/3/2007 8:50:26 AM 7 3 39363
12/3/2007 8:50:43 AM 12 1 39363
12/3/2007 8:50:44 AM 12 2 39363
12/3/2007 8:50:45 AM 12 3 39363
12/3/2007 8:51:00 AM 9 1 39363
12/3/2007 8:51:02 AM 9 2 39363
12/3/2007 8:51:04 AM 9 3 39363
12/3/2007 8:51:23 AM 13 1 39363
12/3/2007 8:51:24 AM 13 2 39363
12/3/2007 8:51:29 AM 13 3 39363
12/3/2007 8:51:48 AM 11 1 39363
12/3/2007 8:51:49 AM 11 2 39363
12/3/2007 8:51:51 AM 11 3 39363
12/3/2007 8:52:47 AM 2 1 39364
12/3/2007 8:52:48 AM 2 2 39364
12/3/2007 8:52:49 AM 2 3 39364
12/3/2007 8:53:22 AM 4 1 39364
12/3/2007 8:53:23 AM 4 2 39364
12/3/2007 8:53:24 AM 4 3 39364
12/3/2007 8:53:52 AM 1 1 39364
12/3/2007 8:53:55 AM 1 2 39364
12/3/2007 8:53:56 AM 1 3 39364
12/3/2007 8:54:14 AM 6 1 39364
12/3/2007 8:54:15 AM 6 2 39364
12/3/2007 8:54:17 AM 6 3 39364
12/3/2007 8:54:38 AM 3 1 39364
12/3/2007 8:54:40 AM 3 2 39364
12/3/2007 8:54:41 AM 3 3 39364
12/3/2007 8:55:03 AM 8 1 39364
12/3/2007 8:55:04 AM 8 2 39364
12/3/2007 8:55:05 AM 8 3 39364
12/3/2007 8:55:34 AM 5 1 39364
12/3/2007 8:55:35 AM 5 2 39364
12/3/2007 8:55:37 AM 5 3 39364
12/3/2007 8:55:59 AM 10 1 39364
12/3/2007 8:56:00 AM 10 2 39364
12/3/2007 8:56:02 AM 10 3 39364
12/3/2007 8:56:17 AM 7 1 39364
12/3/2007 8:56:18 AM 7 2 39364
12/3/2007 8:56:20 AM 7 3 39364
12/3/2007 8:56:45 AM 12 1 39364
12/3/2007 8:56:46 AM 12 2 39364
12/3/2007 8:56:47 AM 12 3 39364
12/3/2007 8:57:11 AM 9 1 39364
12/3/2007 8:57:12 AM 9 2 39364
12/3/2007 8:57:13 AM 9 3 39364
12/3/2007 8:57:49 AM 13 1 39364
12/3/2007 8:57:51 AM 13 2 39364
12/3/2007 8:57:52 AM 13 3 39364
12/3/2007 8:58:18 AM 11 1 39364
12/3/2007 8:58:19 AM 11 2 39364
12/3/2007 8:58:23 AM 11 3 39364
12/3/2007 9:00:53 AM 2 1 39365
12/3/2007 9:00:55 AM 2 2 39365
12/3/2007 9:00:56 AM 2 3 39365
12/3/2007 9:01:14 AM 4 1 39365
12/3/2007 9:01:15 AM 4 2 39365
12/3/2007 9:01:16 AM 4 3 39365
12/3/2007 9:01:40 AM 1 1 39365
12/3/2007 9:01:41 AM 1 2 39365
12/3/2007 9:01:42 AM 1 3 39365
12/3/2007 9:02:17 AM 6 1 39365
12/3/2007 9:02:18 AM 6 2 39365
12/3/2007 9:02:20 AM 6 3 39365
12/3/2007 9:02:52 AM 3 1 39365
12/3/2007 9:02:53 AM 3 2 39365
12/3/2007 9:02:54 AM 3 3 39365
12/3/2007 9:03:27 AM 8 1 39365
12/3/2007 9:03:28 AM 8 2 39365
12/3/2007 9:03:29 AM 8 3 39365
12/3/2007 9:03:51 AM 5 1 39365
12/3/2007 9:03:52 AM 5 2 39365
12/3/2007 9:03:56 AM 5 3 39365
12/3/2007 9:04:25 AM 10 1 39365
12/3/2007 9:04:25 AM 10 2 39365
12/3/2007 9:04:28 AM 10 3 39365
12/3/2007 9:04:50 AM 7 1 39365
12/3/2007 9:04:51 AM 7 2 39365
12/3/2007 9:04:52 AM 7 3 39365
12/3/2007 9:05:34 AM 12 1 39365
12/3/2007 9:05:36 AM 12 2 39365
12/3/2007 9:05:37 AM 12 3 39365
12/3/2007 9:07:06 AM 9 1 39365
12/3/2007 9:07:07 AM 9 2 39365
12/3/2007 9:07:10 AM 9 3 39365
12/3/2007 9:07:44 AM 13 1 39365
12/3/2007 9:07:45 AM 13 2 39365
12/3/2007 9:07:47 AM 13 3 39365
12/3/2007 9:08:12 AM 11 1 39365
12/3/2007 9:08:13 AM 11 2 39365
12/3/2007 9:08:14 AM 11 3 39365
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

30421 Posts
Posted - 2007-12-07 : 11:05:17
OMG!
What was wrong with my previous query?

The two only things you have to do are to copy the query to your query editor and change the names for table and columns...


E 12°55'05.25"
N 56°04'39.16"
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

30421 Posts
Posted - 2007-12-07 : 11:06:10
I will not help you further in this because you insist of posting meaningful data.
Haven't I shown you how to post meaningful data, with table declaration and inserts?


E 12°55'05.25"
N 56°04'39.16"
Go to Top of Page
    Next Page

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources

Articles

Forums

Blogs

Contact Us

About the Site