how to find the difference between two rows for a particular field 2

[Jeet2004]

here is the example of my problem I have a table as follows
Contract# Date DateDiff=>5days
1 12/1/2005
1 12/6/2005
2 12/21/2005
2 12/24/2005
2 12/24/2005

now i need to fill the last column with y/n depending on the difference in the dates for each contract. now hte number of contract and number of each occurance can vary . The last contract would have the field as N
How can i do this so that i get result similar to following table.

Contract# Date DateDiff=>5days
1 12/1/2005 y
1 12/6/2005 N
2 12/21/2005 N
2 12/24/2005 N
2 12/24/2005 N
Thanks in advance for your help.

 

[r937]

untested:

select t1.[Contract#]
     , t1.[Date]
     , case when dateadd(day,5,t1.[Date])
              <= t2.[Date]
            then 'Y' else 'N' 
         end     as [DateDiff=>5days]
  from daTable as t1
left outer
  join daTable as t2
    on t1.[Contract#] = t2.[Contract#]
   and t2.[Date] 
     = ( select min([Date])
           from daTable
          where [Date] > t1.[Date] )

r937.com | rudy.ca

 

[vongrunt]

Damnit rudy... you make it too readable

In sample data last two rows are dupes... I think this will cause some extra rows in result set.

Speaking about readability, what about:

set ansi_warnings off

select T1.Contract#, T1.Date, char(78+11*sign(count(T2.date)))
from blah T1
left outer join blah T2 on T2.Contract#=T1.Contract# and T2.Date >= T1.Date+5
group by T1.Contract#, T1.Date

(j/k)

------
"There's a man... He's bald and wears a short-sleeved shirt, and somehow he's very important to me. I think his name is Homer."
(Jack O'Neill, Stargate)

 

[Jeet2004]

Thanks guys for your help.
vongrunt your query works correctly there were some wrong results with r937 query but thanks r937 for pointing me to right direction

Guys I have one more question to ask what if i want that all the last records for each query should be checked against todays date and marked y/n if the todays & dates difference is less/greater than 5.
Thanks .
NOTE you guys deserve a star

 

[r937]

some wrong results" are due to "some wrong data"

and i challenge you to explain vongrunt's GROUP BY solution, or even to apply it to any other scenario



r937.com | rudy.ca

 

[Jeet2004]

here is an example of the data on which i ran the query
though the difference is more than 5 days still it marks it as N instead of Y for the first contract

000006000420 2005-09-19 10:37:47.390 N
000006000420 2005-09-29 11:02:23.860 N

i guess i wasnt clear that for each contract the dates should be compared for that contract only and not mixed with other contracts.

 

[r937]

yeah, but the query takes that into consideration here --

on t1.[Contract#] = t2.[Contract#]




r937.com | rudy.ca

 

[Jeet2004]

r937 for hte above i ran a detail query and got following results
000006001127 2005-09-19 12:52:45.673 NULL N
000006001127 2005-10-17 13:33:23.093 NULL N
where the third column is hte datetime for t2 dont know hwy its coming null as for the first row it shoudl be 2005-10-17 13:33:23.093
any thoughts on this one

 

[r937]

here's the test data:

create table daTable
( [Contract#] varchar(37) 
, [Date] datetime
)
insert into daTable values
   ('1','12/1/2005')
insert into daTable values
   ('1','12/6/2005')
insert into daTable values
   ('2','12/21/2005')
insert into daTable values
   ('2','12/24/2005')  /* note only 1 of these */
insert into daTable values
   ('000006001127','2005-09-19 12:52:45.673')
insert into daTable values
   ('000006001127','2005-10-17 13:33:23.093')

and here's the results from my query (above):

1             2005-12-01 00:00:00.000  Y
1             2005-12-06 00:00:00.000  N
2             2005-12-21 00:00:00.000  N
2             2005-12-24 00:00:00.000  N
000006001127  2005-09-19 12:52:45.673  Y
000006001127  2005-10-17 13:33:23.093  N

what was the question again?

r937.com | rudy.ca

 

[Jeet2004]

Dear r937,
following is my data on which i run the query

contract# Date Diff
000005998955 2005-06-30 08:07:50.720 NULL
000005998955 2005-07-01 08:07:50.720 NULL
000005998955 2005-07-30 08:07:50.720 NULL
000005998955 2005-08-25 08:07:50.720 NULL
000005998955 2005-09-19 08:07:50.720 NULL
000005999459 2005-09-19 10:35:26.157 NULL
000006000339 2005-09-19 10:08:54.847 NULL
000006000339 2005-09-26 08:16:14.703 NULL
000006000344 2005-09-19 09:28:21.500 NULL
000006000348 2005-09-19 09:54:55.047 NULL
000006000369 2005-09-19 10:06:10.877 NULL
000006000370 2005-09-19 09:54:00.580 NULL
000006000379 2005-09-19 10:05:13.893 NULL
000006000415 2005-09-19 10:33:50.470 NULL
000006000420 2005-09-19 10:37:47.390 NULL
000006000420 2005-09-29 11:02:23.860 NULL
000006000421 2005-09-19 10:49:31.360 NULL
000006000824 2005-09-19 11:15:05.970 NULL
000006001024 2005-09-19 11:41:13.643 NULL
000006001031 2005-09-19 11:31:46.313 NULL
000006001069 2005-09-19 12:00:55.220 NULL
000006001077 2005-09-19 12:09:05.487 NULL
000006001109 2005-09-19 12:31:06.050 NULL
000006001115 2005-09-19 12:42:52.030 NULL
000006001127 2005-09-19 12:52:45.673 NULL
000006001127 2005-10-17 13:33:23.093 NULL
000006001227 2005-09-19 13:10:21.550 NULL
000006001227 2005-09-20 12:23:56.657 NULL
000006001241 2005-09-19 13:15:15.110 NULL
000006001255 2005-09-19 13:34:52.423 NULL
000006001265 2005-09-19 13:43:03.343 NULL
000006001323 2005-09-19 14:18:28.330 NULL
000006001335 2005-09-19 18:38:06.563 NULL
000006001337 2005-09-19 14:29:09.220 NULL
000006001365 2005-09-19 14:53:34.093 NULL
000006002171 2005-09-19 15:09:35.563 NULL
000006002173 2005-09-19 15:06:06.563 NULL
000006004196 2005-09-19 15:30:25.580 NULL
000006004207 2005-09-19 15:41:15.767 NULL
000006005525 2005-09-19 15:54:17.640 NULL
000006007596 2005-09-19 16:16:39.517 NULL
000006007597 2005-09-19 16:43:36.563 NULL
000006008099 2005-09-19 16:22:00.110 NULL
000006008585 2005-09-19 16:27:13.923 NULL
000006012010 2005-09-19 17:27:21.470 NULL
000006012041 2005-09-19 18:13:24.110 NULL
000006014980 2005-09-19 20:48:37.800 NULL
000006014986 2005-09-20 18:10:54.250 NULL
000006014987 2005-09-19 20:07:32.220 NULL
000006032695 2005-09-20 08:49:55.877 NULL
000006033850 2005-09-20 10:25:16.640 NULL
000006037077 2005-09-20 11:34:26.407 NULL
000006037077 2005-09-29 10:39:04.440 NULL
000006037097 2005-09-20 12:08:21.703 NULL
000006037097 2005-09-20 18:43:15.423 NULL
000006037097 2005-09-21 08:19:38.347 NULL
000006037125 2005-09-20 12:29:15.923 NULL
000006037144 2005-09-20 12:57:48.923 NULL
000006042776 2005-09-20 13:55:35.953 NULL
000006042776 2005-09-22 12:20:13.780 NULL
000006043898 2005-09-21 12:06:36.360 NULL
000006043915 2005-09-20 14:36:23.237 NULL
000006044009 2005-09-20 16:37:13.407 NULL
000006044016 2005-09-20 16:47:33.347 NULL
000006044017 2005-09-20 16:55:48.250 NULL
000006044082 2005-09-20 18:31:05.360 NULL
000006044091 2005-09-20 19:23:51.110 NULL
000006044102 2005-09-20 19:03:16.000 NULL
000006044776 2005-09-21 07:53:23.970 NULL
000006044826 2005-09-21 09:10:05.720 NULL
000006044943 2005-09-21 10:01:12.703 NULL
000006045242 2005-09-21 10:34:14.673 NULL
000006045273 2005-09-21 11:07:29.500 NULL
000006045457 2005-09-21 11:58:37.580 NULL
000006045457 2005-09-23 11:41:19.453 NULL
000006045489 2005-09-21 12:05:42.500 NULL
000006045508 2005-09-21 12:17:56.080 NULL
000006045537 2005-09-21 12:39:51.220 NULL
000006045566 2005-09-27 16:23:19.797 NULL
000006045576 2005-09-21 13:05:18.267 NULL
000006045604 2005-09-21 13:21:14.783 NULL
000006045630 2005-09-21 13:38:09.750 NULL
000006045662 2005-09-21 14:06:40.377 NULL
000006045673 2005-09-21 14:25:43.250 NULL
000006045693 2005-09-21 14:47:10.377 NULL
000006045693 2005-09-27 08:54:42.343 NULL
000006045693 2005-09-27 20:56:09.407 NULL
000006045763 2005-09-21 15:34:48.300 NULL
000006045763 2005-09-22 11:24:42.343 NULL
000006045824 2005-09-21 16:09:47.407 NULL
000006045882 2005-09-21 17:25:14.893 NULL
000006045885 2005-09-21 17:24:50.877 NULL
000006046491 2005-09-21 19:31:07.390 NULL
000006046493 2005-09-21 19:41:12.610 NULL
000006046501 2005-09-21 20:11:51.017 NULL
000006046513 2005-09-21 21:37:13.203 NULL
000006046760 2005-09-22 08:40:34.547 NULL
000006048440 2005-09-27 17:34:12.533 NULL
000006048720 2005-09-22 11:00:43.203 NULL
000006048836 2005-09-22 11:45:43.453 NULL
000006048875 2005-09-22 12:01:05.407 NULL
000006048875 2005-10-05 11:55:59.940 NULL
000006048963 2005-09-22 13:10:23.860 NULL
000006048963 2005-09-26 11:37:51.470 NULL
000006049983 2005-09-23 12:59:20.877 NULL
000006051165 2005-09-22 14:25:53.423 NULL
000006051165 2005-09-22 14:27:32.313 NULL
000006051801 2005-09-22 14:42:28.983 NULL
000006051886 2005-09-22 15:33:15.767 NULL
000006051890 2005-09-22 15:37:39.877 NULL
000006052614 2005-09-22 17:38:01.750 NULL
000006052626 2005-09-22 17:43:30.267 NULL
000006052627 2005-09-22 17:45:44.547 NULL
000006053334 2005-09-23 09:14:36.233 NULL
000006054267 2005-09-23 09:26:32.923 NULL
000006060858 2005-09-23 10:20:58.987 NULL
000006061943 2005-09-23 11:17:41.737 NULL
000006064108 2005-09-23 11:04:38.640 NULL
000006064125 2005-09-23 11:31:39.690 NULL
000006064125 2005-09-27 12:36:02.173 NULL
000006069119 2005-09-23 12:12:55.377 NULL
000006069143 2005-09-23 12:28:06.813 NULL
000006069160 2005-09-23 12:36:04.580 NULL
000006069835 2005-09-23 13:24:22.033 NULL
000006069911 2005-09-23 14:08:43.890 NULL
000006069913 2005-09-23 14:10:54.780 NULL
000006069913 2005-09-27 18:26:21.593 NULL
000006069964 2005-09-23 15:36:41.673 NULL
000006069985 2005-09-23 15:17:00.250 NULL
000006069985 2005-09-25 11:32:00.097 NULL
000006070026 2005-09-23 16:32:39.610 NULL
000006070029 2005-09-23 16:50:40.657 NULL
000006070128 2005-09-23 18:38:15.203 NULL
000006070155 2005-09-23 19:32:46.690 NULL
000006070176 2005-09-23 22:00:41.097 NULL
000006070234 2005-09-24 09:51:07.830 NULL
000006070234 2005-09-30 16:57:12.470 NULL
000006070349 2005-10-03 13:00:31.250 NULL
000006070355 2005-09-24 12:31:28.517 NULL
000006070428 2005-09-24 14:05:28.487 NULL
000006070428 2005-10-13 18:18:05.780 NULL
000006070444 2005-09-24 14:29:12.750 NULL
000006070460 2005-09-24 15:02:36.157 NULL
000006070464 2005-09-24 15:10:23.597 NULL
000006070481 2005-09-24 15:24:03.267 NULL
000006070481 2005-09-30 09:48:27.533 NULL
000006070487 2005-09-24 15:35:48.143 NULL
000006070500 2005-09-24 15:48:50.267 NULL
000006070603 2005-09-25 09:20:41.110 NULL
000006070645 2005-09-25 14:03:03.000 NULL
000006070652 2005-09-25 14:13:04.190 NULL
000006071262 2005-09-26 09:23:20.360 NULL
000006071283 2005-09-26 09:48:36.440 NULL
000006072202 2005-09-26 10:44:57.890 NULL
000006072214 2005-09-26 10:54:39.220 NULL
000006072290 2005-09-26 11:37:55.330 NULL
000006072379 2005-09-26 12:34:30.860 NULL
000006072474 2005-09-26 12:58:22.267 NULL
000006072684 2005-10-04 12:15:29.483 NULL
000006072698 2005-09-26 13:22:16.563 NULL
000006073117 2005-09-26 14:08:32.533 NULL
000006073173 2005-09-26 14:47:13.733 NULL
000006073201 2005-09-26 15:17:35.923 NULL
000006073238 2005-09-26 15:36:35.033 NULL
000006073256 2005-09-26 15:49:34.453 NULL
000006073295 2005-09-26 16:37:40.800 NULL
000006073302 2005-09-26 16:23:38.237 NULL
000006073508 2005-09-26 17:08:23.300 NULL
000006073511 2005-09-26 17:04:53.580 NULL
000006073564 2005-09-26 17:57:32.157 NULL
000006073736 2005-09-26 22:39:09.093 NULL
000006075015 2005-09-27 09:15:23.533 NULL
000006075071 2005-09-27 09:32:11.517 NULL
000006075148 2005-09-27 10:09:46.220 NULL
000006075150 2005-09-27 10:07:15.533 NULL
000006075173 2005-09-27 10:31:46.830 NULL
000006075214 2005-09-27 10:51:18.533 NULL
000006075238 2005-09-27 11:05:09.640 NULL
000006075238 2005-09-27 20:22:14.360 NULL
000006075239 2005-09-27 11:06:41.563 NULL
000006075262 2005-10-10 15:26:30.060 NULL
000006075497 2005-09-27 11:48:12.907 NULL
000006075555 2005-09-27 12:59:12.390 NULL
000006075729 2005-09-27 13:46:30.127 NULL
000006075781 2005-09-27 14:13:16.080 NULL
000006075807 2005-09-27 14:24:33.907 NULL
000006075865 2005-09-27 15:20:35.940 NULL
000006075913 2005-09-27 15:30:01.627 NULL
000006076128 2005-09-27 17:10:59.313 NULL
000006076215 2005-09-27 18:06:48.750 NULL
000006076307 2005-09-27 19:32:48.860 NULL
000006076312 2005-09-27 19:33:25.233 NULL
000006076322 2005-09-27 19:43:48.550 NULL
000006076366 2005-09-27 21:25:18.063 NULL
000006076793 2005-09-28 09:18:51.843 NULL
000006076795 2005-09-28 09:21:34.800 NULL
000006076795 2005-09-29 15:03:46.657 NULL
000006076817 2005-09-28 09:51:35.610 NULL
000006077133 2005-09-28 10:59:00.860 NULL
000006077138 2005-09-28 11:01:53.830 NULL
000006077153 2005-09-28 11:15:47.610 NULL
000006077153 2005-10-07 12:21:09.627 NULL
000006077225 2005-09-28 12:52:43.360 NULL
000006077456 2005-09-28 13:35:53.597 NULL
000006077524 2005-09-28 14:12:54.690 NULL
000006077524 2005-10-10 13:04:37.967 NULL
000006077629 2005-09-28 15:12:34.673 NULL
000006077663 2005-09-28 15:27:27.547 NULL
000006077936 2005-09-28 18:19:35.470 NULL
000006077936 2005-09-28 18:22:55.390 NULL
000006078050 2005-09-28 19:40:28.500 NULL
000006078090 2005-09-28 20:38:04.470 NULL
000006078405 2005-09-29 07:59:29.297 NULL
000006078406 2005-09-29 07:57:07.143 NULL
000006079141 2005-09-29 10:10:50.190 NULL
000006079598 2005-09-29 10:39:19.470 NULL
000006079643 2005-09-29 11:26:34.313 NULL
000006079648 2005-09-29 11:29:36.940 NULL
000006079680 2005-09-29 11:56:44.080 NULL
000006079872 2005-09-29 14:17:44.953 NULL
000006079922 2005-09-29 14:35:22.550 NULL
000006079958 2005-09-29 14:53:50.343 NULL
000006080073 2005-09-29 15:58:19.547 NULL
000006080176 2005-09-29 17:05:27.720 NULL
000006080260 2005-09-29 18:12:55.970 NULL
000006080265 2005-09-29 18:18:20.877 NULL
000006080276 2005-09-29 18:37:25.000 NULL
000006080324 2005-09-29 19:23:08.737 NULL
000006082319 2005-09-29 21:42:06.017 NULL
000006082638 2005-09-30 07:45:42.890 NULL
000006083220 2005-09-30 09:40:26.597 NULL
000006083232 2005-09-30 10:09:29.580 NULL
000006083320 2005-09-30 11:42:51.813 NULL
000006083617 2005-09-30 12:01:52.610 NULL
000006083720 2005-09-30 13:07:59.483 NULL
000006083853 2005-09-30 13:55:20.953 NULL
000006083874 2005-10-06 10:34:32.080 NULL
000006083890 2005-09-30 14:24:28.703 NULL
000006083940 2005-09-30 15:03:47.487 NULL
000006084034 2005-09-30 15:39:27.390 NULL
000006084090 2005-09-30 16:03:32.940 NULL
000006084120 2005-09-30 16:21:03.923 NULL
000006084215 2005-09-30 17:28:56.127 NULL
000006084215 2005-10-12 12:47:10.920 NULL
000006084304 2005-09-30 19:06:22.093 NULL
000006084408 2005-09-30 23:04:48.470 NULL
000006084418 2005-10-01 08:23:02.110 NULL
000006084426 2005-10-01 09:05:12.563 NULL
000006084429 2005-10-01 09:34:19.000 NULL
000006084439 2005-10-01 11:08:58.940 NULL
000006084452 2005-10-01 10:54:10.157 NULL
000006084453 2005-10-01 11:00:28.970 NULL
000006084499 2005-10-01 13:01:51.487 NULL
000006084504 2005-10-01 13:13:34.233 NULL
000006084536 2005-10-01 15:23:39.453 NULL
000006084575 2005-10-03 00:16:21.500 NULL
000006084582 2005-10-02 07:49:33.203 NULL
000006084662 2005-10-02 09:58:04.017 NULL
000006084663 2005-10-02 10:10:51.970 NULL
000006084776 2005-10-02 11:39:02.173 NULL
000006084799 2005-10-02 12:46:46.393 NULL
000006084805 2005-10-02 14:52:40.597 NULL
000006084816 2005-10-02 19:29:16.313 NULL
000006084824 2005-10-02 21:19:38.860 NULL
000006084837 2005-10-03 00:10:24.640 NULL
000006085121 2005-10-03 07:30:26.377 NULL
000006086154 2005-10-03 10:18:25.533 NULL
000006086166 2005-10-03 10:37:42.093 NULL
000006086166 2005-10-19 13:10:32.093 NULL
000006086215 2005-10-03 11:20:52.157 NULL
000006086230 2005-10-03 11:31:44.453 NULL
000006086232 2005-10-03 11:33:27.440 NULL
000006086290 2005-10-03 12:19:25.143 NULL
000006086296 2005-10-03 12:19:19.470 NULL
000006086384 2005-10-03 13:56:10.500 NULL
000006086411 2005-10-03 14:27:42.203 NULL
000006086445 2005-10-03 15:03:28.050 NULL
000006086641 2005-10-03 17:08:00.063 NULL
000006086660 2005-10-03 17:13:29.640 NULL
000006086697 2005-10-03 17:42:18.033 NULL
000006086745 2005-10-03 19:14:17.733 NULL
000006087077 2005-10-04 08:03:18.300 NULL
000006088431 2005-10-04 11:07:38.550 NULL
000006089747 2005-10-04 11:28:48.673 NULL
000006089750 2005-10-04 11:26:13.813 NULL
000006089789 2005-10-04 11:58:21.250 NULL
000006089841 2005-10-04 13:15:53.673 NULL
000006089852 2005-10-06 10:58:03.673 NULL
000006089857 2005-10-04 13:29:24.300 NULL
000006090923 2005-10-04 15:22:08.593 NULL
000006093027 2005-10-04 17:18:11.970 NULL
000006096450 2005-10-04 18:16:41.063 NULL
000006097759 2005-10-04 19:20:41.657 NULL
000006117339 2005-10-05 09:48:37.360 NULL
000006117342 2005-10-05 09:53:25.470 NULL
000006119813 2005-10-05 10:30:00.487 NULL
000006119818 2005-10-05 10:31:12.627 NULL
000006120763 2005-10-05 10:44:00.143 NULL
000006122577 2005-10-05 11:04:43.127 NULL
000006123798 2005-10-05 11:26:34.190 NULL
000006124321 2005-10-05 11:33:36.893 NULL
000006127285 2005-10-05 15:47:48.237 NULL
000006127291 2005-10-06 11:52:33.360 NULL
000006127304 2005-10-05 12:43:05.860 NULL
000006129560 2005-10-05 13:28:15.157 NULL
000006129566 2005-10-05 13:39:24.813 NULL
000006134237 2005-10-05 17:58:26.783 NULL
000006134258 2005-10-05 18:37:01.250 NULL
000006134260 2005-10-05 18:44:01.033 NULL
000006134287 2005-10-05 19:17:44.940 NULL
000006134316 2005-10-05 19:43:39.923 NULL
000006134322 2005-10-05 19:52:49.563 NULL
000006134326 2005-10-05 19:58:44.673 NULL
000006137344 2005-10-06 09:03:11.220 NULL
000006137344 2005-10-14 16:50:36.890 NULL
000006139676 2005-10-06 10:18:42.533 NULL
000006139707 2005-10-06 10:51:16.563 NULL
000006139742 2005-10-06 11:22:58.190 NULL
000006139821 2005-10-06 12:01:06.283 NULL
000006139827 2005-10-06 12:00:48.157 NULL
000006139838 2005-10-06 12:11:23.767 NULL
000006139876 2005-10-06 13:11:18.533 NULL
000006142099 2005-10-06 13:39:48.550 NULL
000006146231 2005-10-06 16:16:47.830 NULL
000006147229 2005-10-06 16:34:27.000 NULL
000006147401 2005-10-06 18:10:57.953 NULL
000006151523 2005-10-07 09:30:42.203 NULL
000006152875 2005-10-14 13:57:00.140 NULL
000006152878 2005-10-07 12:44:17.673 NULL
000006152882 2005-10-07 10:06:39.343 NULL
000006155846 2005-10-07 11:03:26.767 NULL
000006156846 2005-10-07 11:02:56.487 NULL
000006157226 2005-10-07 11:07:12.280 NULL
000006157232 2005-10-07 11:58:08.360 NULL
000006157232 2005-10-17 09:00:45.687 NULL
000006157234 2005-10-07 11:40:46.127 NULL
000006157238 2005-10-07 12:02:00.643 NULL
000006157274 2005-10-12 14:28:35.170 NULL
000006157535 2005-10-07 12:56:48.063 NULL
000006157560 2005-10-07 13:20:42.750 NULL
000006158147 2005-10-07 14:26:41.190 NULL
000006159050 2005-10-07 14:40:09.157 NULL
000006160487 2005-10-07 14:49:51.080 NULL
000006160487 2005-10-07 14:57:54.953 NULL
000006160488 2005-10-07 14:49:31.783 NULL
000006161657 2005-10-07 17:08:59.673 NULL
000006161673 2005-10-07 16:54:02.673 NULL
000006161685 2005-10-07 17:11:17.017 NULL
000006161727 2005-10-07 17:24:08.173 NULL
000006161824 2005-10-07 19:09:28.300 NULL
000006161830 2005-10-07 19:20:04.690 NULL
000006161848 2005-10-07 19:51:12.690 NULL
000006161848 2005-10-13 20:33:38.903 NULL
000006161948 2005-10-08 11:25:06.750 NULL
000006161958 2005-10-08 11:59:27.203 NULL
000006161970 2005-10-08 12:41:03.797 NULL
000006162050 2005-10-08 15:35:13.283 NULL
000006162054 2005-10-08 15:48:31.110 NULL
000006162099 2005-10-09 11:14:21.390 NULL
000006162100 2005-10-09 11:42:13.340 NULL
000006162104 2005-10-18 14:04:16.187 NULL
000006162132 2005-10-09 14:15:40.483 NULL
000006162138 2005-10-09 15:16:33.250 NULL
000006162139 2005-10-09 15:32:33.797 NULL
000006162142 2005-10-09 15:41:41.387 NULL
000006162145 2005-10-09 17:26:13.043 NULL
000006163281 2005-10-10 09:36:11.653 NULL
000006163294 2005-10-10 10:01:08.560 NULL
000006163298 2005-10-10 10:08:01.607 NULL
000006163329 2005-10-10 10:46:38.030 NULL
000006163338 2005-10-10 10:53:37.577 NULL
000006163354 2005-10-10 11:01:48.200 NULL
000006164534 2005-10-10 11:43:34.467 NULL
000006164616 2005-10-10 11:53:57.717 NULL
000006164632 2005-10-10 12:12:13.357 NULL
000006164745 2005-10-10 12:50:20.560 NULL
000006164762 2005-10-11 20:19:38.357 NULL
000006164772 2005-10-10 13:21:18.827 NULL
000006166363 2005-10-10 13:30:37.013 NULL
000006166380 2005-10-10 13:58:41.107 NULL
000006166387 2005-10-10 14:05:39.827 NULL
000006166390 2005-10-10 14:10:13.390 NULL
000006166662 2005-10-10 16:12:39.437 NULL
000006166676 2005-10-10 16:18:16.373 NULL
000006166725 2005-10-10 16:51:00.920 NULL
000006166742 2005-10-10 16:58:56.513 NULL
000006166785 2005-10-10 17:42:20.077 NULL
000006166797 2005-10-10 17:51:48.343 NULL
000006166799 2005-10-10 17:52:45.857 NULL
000006166806 2005-10-10 17:54:18.217 NULL
000006166810 2005-10-10 18:10:17.500 NULL
000006166812 2005-10-10 18:08:57.700 NULL
000006166813 2005-10-10 18:05:56.513 NULL
000006166822 2005-10-10 18:17:10.513 NULL
000006166843 2005-10-10 19:03:46.780 NULL
000006166851 2005-10-10 19:19:55.653 NULL
000006166882 2005-10-10 20:24:02.530 NULL
000006167379 2005-10-11 09:41:00.623 NULL
000006167899 2005-10-11 10:01:27.373 NULL
000006167906 2005-10-12 16:46:12.967 NULL
000006167908 2005-10-11 10:16:20.247 NULL
000006168111 2005-10-11 10:53:19.797 NULL
000006168226 2005-10-11 12:28:26.093 NULL
000006168303 2005-10-11 13:12:07.750 NULL
000006168317 2005-10-11 13:29:20.373 NULL
000006168317 2005-10-15 12:19:09.403 NULL
000006168438 2005-10-11 14:06:23.077 NULL
000006168491 2005-10-11 14:28:28.530 NULL
000006168507 2005-10-11 14:39:09.873 NULL
000006168531 2005-10-11 14:49:18.637 NULL
000006168534 2005-10-11 14:50:05.293 NULL
000006168549 2005-10-11 14:55:23.437 NULL
000006168564 2005-10-11 15:02:10.000 NULL
000006168785 2005-10-11 17:17:03.437 NULL
000006168808 2005-10-11 17:36:53.700 NULL
000006168817 2005-10-11 17:44:45.280 NULL
000006168822 2005-10-11 17:50:08.530 NULL
000006168875 2005-10-11 19:06:03.997 NULL
000006168879 2005-10-11 19:16:24.153 NULL
000006168881 2005-10-11 19:20:22.653 NULL
000006170157 2005-10-18 09:37:15.140 NULL
000006170348 2005-10-12 11:23:57.577 NULL
000006170542 2005-10-12 11:56:24.827 NULL
000006170553 2005-10-14 14:18:15.420 NULL
000006170589 2005-10-12 12:35:31.873 NULL
000006170606 2005-10-12 12:53:15.310 NULL
000006170644 2005-10-12 13:25:56.403 NULL
000006170646 2005-10-12 15:16:13.077 NULL
000006170668 2005-10-12 13:55:45.373 NULL
000006170752 2005-10-12 14:47:47.577 NULL
000006170784 2005-10-20 14:35:21.560 NULL
000006170889 2005-10-12 16:20:44.217 NULL
000006170890 2005-10-12 16:20:56.437 NULL
000006170925 2005-10-12 16:49:35.827 NULL
000006170961 2005-10-12 17:15:06.717 NULL
000006170965 2005-10-12 17:15:58.937 NULL
000006170989 2005-10-12 17:34:10.420 NULL
000006171003 2005-10-12 17:45:21.263 NULL
000006171019 2005-10-12 18:04:58.217 NULL
000006171032 2005-10-12 19:06:25.607 NULL
000006171037 2005-10-12 19:30:41.233 NULL
000006171269 2005-10-13 08:37:32.060 NULL
000006171307 2005-10-13 09:51:29.547 NULL
000006171602 2005-10-14 12:38:01.763 NULL
000006171871 2005-10-13 12:36:53.967 NULL
000006171875 2005-10-14 09:27:03.123 NULL
000006171937 2005-10-13 12:57:29.297 NULL
000006171941 2005-10-13 13:02:04.280 NULL
000006171948 2005-10-13 13:08:33.013 NULL
000006171964 2005-10-13 13:52:31.310 NULL
000006171971 2005-10-13 13:29:28.077 NULL
000006171974 2005-10-13 13:32:55.890 NULL
000006171999 2005-10-13 13:43:49.297 NULL
000006172062 2005-10-13 14:07:12.217 NULL
000006172140 2005-10-13 15:03:43.153 NULL
000006172147 2005-10-13 15:04:59.810 NULL
000006172200 2005-10-13 15:40:26.390 NULL
000006172423 2005-10-13 19:25:01.950 NULL
000006172429 2005-10-13 19:36:11.700 NULL
000006172429 2005-10-13 19:36:48.357 NULL
000006172435 2005-10-13 20:15:04.497 NULL
000006172441 2005-10-13 20:22:39.233 NULL
000006172618 2005-10-14 08:29:16.077 NULL
000006172953 2005-10-14 10:03:39.060 NULL
000006172957 2005-10-14 09:44:33.890 NULL
000006172958 2005-10-14 09:49:29.530 NULL
000006172998 2005-10-14 10:44:36.810 NULL
000006173016 2005-10-14 10:57:04.390 NULL
000006173241 2005-10-14 16:32:47.077 NULL
000006173253 2005-10-18 14:14:39.263 NULL
000006173272 2005-10-14 11:36:17.683 NULL
000006173318 2005-10-14 11:59:37.640 NULL
000006173329 2005-10-14 12:08:48.217 NULL
000006173334 2005-10-14 12:17:55.700 NULL
000006173606 2005-10-14 13:35:41.140 NULL
000006173692 2005-10-14 14:18:15.513 NULL
000006173767 2005-10-14 15:16:19.733 NULL
000006173850 2005-10-14 15:59:42.700 NULL
000006173938 2005-10-14 16:51:25.717 NULL
000006174083 2005-10-15 09:06:52.843 NULL
000006174084 2005-10-15 09:38:00.263 NULL
000006174109 2005-10-15 10:47:12.500 NULL
000006174138 2005-10-15 11:48:44.467 NULL
000006174150 2005-10-15 12:03:26.357 NULL
000006174152 2005-10-15 12:14:18.920 NULL
000006174159 2005-10-15 12:30:06.593 NULL
000006174171 2005-10-15 13:56:14.047 NULL
000006174172 2005-10-15 13:26:03.077 NULL
000006174189 2005-10-15 15:21:34.153 NULL
000006174202 2005-10-15 16:22:40.547 NULL
000006174206 2005-10-15 16:43:29.263 NULL
000006174243 2005-10-16 12:28:05.560 NULL
000006174248 2005-10-16 09:44:18.780 NULL
000006174249 2005-10-16 10:04:18.560 NULL
000006174250 2005-10-16 10:57:48.217 NULL
000006174254 2005-10-16 14:03:23.390 NULL
000006174255 2005-10-16 14:22:38.327 NULL
000006174264 2005-10-16 15:47:25.107 NULL
000006174303 2005-10-16 18:59:17.390 NULL
000006174682 2005-10-17 07:59:10.043 NULL
000006175328 2005-10-19 15:02:28.077 NULL
000006175352 2005-10-17 09:03:33.373 NULL
000006175382 2005-10-17 09:57:21.903 NULL
000006175731 2005-10-17 11:11:08.717 NULL
000006175769 2005-10-17 11:35:07.187 NULL
000006175808 2005-10-17 13:37:40.793 NULL
000006175889 2005-10-17 16:13:27.060 NULL
000006175934 2005-10-17 13:59:43.763 NULL
000006175982 2005-10-17 14:34:14.983 NULL
000006176012 2005-10-17 14:59:46.247 NULL
000006176205 2005-10-17 17:33:52.280 NULL
000006176222 2005-10-17 18:06:03.950 NULL
000006176291 2005-10-17 20:08:29.170 NULL
000006176639 2005-10-18 08:08:42.093 NULL
000006176866 2005-10-18 08:50:33.873 NULL
000006176927 2005-10-18 09:55:51.450 NULL
000006176945 2005-10-18 10:10:32.593 NULL
000006176960 2005-10-18 10:35:58.937 NULL
000006176961 2005-10-18 10:30:09.200 NULL
000006177071 2005-10-19 07:41:02.343 NULL
000006177150 2005-10-18 12:59:52.340 NULL
000006177157 2005-10-18 13:11:12.717 NULL
000006178479 2005-10-18 14:02:31.233 NULL
000006178702 2005-10-18 16:37:18.030 NULL
000006178758 2005-10-18 17:37:52.467 NULL
000006178850 2005-10-18 18:41:40.060 NULL
000006178924 2005-10-18 20:33:06.013 NULL
000006179784 2005-10-19 09:20:13.733 NULL
000006179785 2005-10-19 09:23:08.093 NULL
000006179810 2005-10-19 10:27:46.873 NULL
000006179823 2005-10-19 10:38:21.750 NULL
000006179825 2005-10-19 12:38:26.933 NULL
000006179830 2005-10-19 10:45:45.170 NULL
000006179867 2005-10-19 11:20:11.810 NULL
000006179872 2005-10-19 11:25:07.170 NULL
000006179883 2005-10-19 11:46:47.810 NULL
000006180133 2005-10-19 12:56:54.170 NULL
000006180152 2005-10-19 13:12:27.653 NULL
000006180183 2005-10-19 13:27:39.390 NULL
000006180216 2005-10-19 14:01:55.547 NULL
000006180250 2005-10-19 14:35:43.763 NULL
000006180278 2005-10-19 15:04:57.420 NULL
000006180353 2005-10-19 15:37:02.843 NULL
000006181374 2005-10-19 17:06:00.593 NULL
000006182683 2005-10-19 18:27:36.000 NULL
000006182719 2005-10-19 19:26:16.653 NULL
000006182721 2005-10-19 19:38:30.107 NULL
000006183447 2005-10-20 08:57:27.687 NULL
000006183574 2005-10-20 09:33:04.077 NULL
000006183576 2005-10-20 09:25:33.030 NULL
000006183586 2005-10-20 09:43:26.560 NULL
000006183772 2005-10-20 10:23:26.810 NULL
000006184851 2005-10-20 10:37:02.310 NULL
000006185374 2005-10-20 11:07:43.950 NULL
000006185448 2005-10-20 11:40:41.060 NULL
000006186091 2005-10-20 11:48:00.140 NULL
000006186122 2005-10-20 12:16:48.857 NULL
000006186873 2005-10-20 13:12:27.750 NULL
000006187684 2005-10-20 14:27:12.827 NULL
000006187694 2005-10-20 14:35:56.000 NULL
000006187771 2005-10-20 15:47:17.890 NULL
000006187820 2005-10-20 16:13:28.013 NULL
000006187852 2005-10-20 16:38:53.200 NULL
000006187864 2005-10-20 16:59:24.717 NULL
5987017 2005-09-20 20:14:59.597 NULL
5987299 2005-09-25 16:57:28.500 NULL
5987364 2005-10-03 10:33:36.483 NULL
5987588 2005-09-30 12:24:57.690 NULL
5987595 2005-10-20 09:50:22.607 NULL
5987843 2005-10-13 13:51:14.183 NULL
5988787 2005-09-21 11:59:47.097 NULL
5988979 2005-10-06 19:09:25.000 NULL
5989204 2005-09-29 16:42:44.593 NULL
5990814 2005-09-26 17:14:43.893 NULL
5991236 2005-10-17 09:33:24.060 NULL
5992802 2005-10-19 13:14:16.107 NULL
5993034 2005-10-01 09:34:08.657 NULL
5996079 2005-10-04 13:55:31.953 NULL
5996321 2005-10-17 15:31:20.530 NULL
5996653 2005-10-20 08:22:00.967 NULL
5997513 2005-09-22 10:25:50.440 NULL
5997730 2005-10-03 17:44:33.780 NULL
5997999 2005-09-23 18:28:43.267 NULL
6001501 2005-10-03 11:24:53.190 NULL
6003112 2005-09-19 20:17:49.237 NULL
6003672 2005-09-25 17:21:45.940 NULL
6004069 2005-09-23 10:46:43.250 NULL
6004287 2005-10-11 13:51:06.700 NULL
6007760 2005-10-16 06:22:09.327 NULL
6008232 2005-10-01 13:47:03.750 NULL
6008545 2005-09-19 16:55:55.877 NULL
6008645 2005-09-20 15:36:27.233 NULL
6008901 2005-10-19 12:25:41.297 NULL
6008924 2005-10-01 13:42:03.627 NULL
6009382 2005-09-23 12:35:15.673 NULL
6009475 2005-09-27 11:54:15.097 NULL
6009755 2005-10-17 15:17:30.890 NULL
6009788 2005-10-08 12:12:06.720 NULL
6009816 2005-09-22 15:27:29.250 NULL
6009889 2005-09-26 16:48:23.157 NULL
6010033 2005-10-19 13:48:10.153 NULL
6010239 2005-09-29 11:34:10.783 NULL
6010279 2005-10-14 10:14:36.293 NULL
6010817 2005-09-27 09:58:26.157 NULL
6011098 2005-09-29 14:38:41.267 NULL
6011232 2005-10-07 18:13:38.097 NULL
6012074 2005-10-16 18:34:24.077 NULL
6012132 2005-10-16 18:15:56.390 NULL
6013260 2005-10-19 10:58:29.390 NULL
6014101 2005-10-10 12:02:22.780 NULL
6014335 2005-10-03 12:35:35.533 NULL
6015029 2005-09-21 12:38:05.440 NULL
6015029 2005-09-22 10:50:17.063 NULL
6016517 2005-10-05 14:27:07.440 NULL
6017632 2005-09-27 13:03:06.643 NULL
6018317 2005-10-15 19:00:39.513 NULL
6020390 2005-09-20 18:59:33.657 NULL
6020512 2005-09-23 17:25:25.377 NULL
6020512 2005-09-27 11:33:56.050 NULL
6020826 2005-10-12 22:52:26.560 NULL
6021239 2005-09-22 11:08:42.267 NULL
6021749 2005-09-22 11:08:06.657 NULL
6021873 2005-09-29 11:26:58.563 NULL
6021874 2005-09-29 11:32:03.000 NULL
6021970 2005-09-20 17:05:41.220 NULL
6021978 2005-10-07 12:12:46.347 NULL
6022537 2005-10-02 01:24:04.550 NULL
6022630 2005-10-12 18:17:47.153 NULL
6022765 2005-09-26 16:49:43.877 NULL
6022808 2005-10-04 13:37:44.440 NULL
6023070 2005-10-07 12:34:59.923 NULL
6023787 2005-10-04 13:54:06.203 NULL
6023949 2005-10-13 13:08:06.810 NULL
6024200 2005-09-23 19:52:43.470 NULL
6024805 2005-10-18 13:20:30.890 NULL
6025439 2005-10-20 15:33:49.297 NULL
6026383 2005-10-10 12:40:11.903 NULL
6026811 2005-10-10 10:05:42.000 NULL
6027207 2005-10-10 14:13:39.403 NULL
6027400 2005-10-12 20:51:05.967 NULL
6027610 2005-10-17 14:33:25.403 NULL
6027973 2005-10-05 11:53:22.000 NULL
6028560 2005-10-10 15:18:39.310 NULL
6028948 2005-10-12 17:34:40.997 NULL
6029021 2005-10-06 10:11:34.783 NULL
6029687 2005-09-30 02:31:39.907 NULL
6029687 2005-09-30 14:57:27.547 NULL
6029794 2005-09-30 07:27:28.233 NULL
6029920 2005-10-05 15:00:43.190 NULL
6029947 2005-10-17 16:50:51.137 NULL
6029951 2005-10-11 11:40:14.107 NULL
6030506 2005-10-10 09:09:19.733 NULL
6030613 2005-10-20 11:10:35.327 NULL
6030641 2005-10-02 14:09:51.360 NULL
6031016 2005-10-14 13:23:36.653 NULL
6031028 2005-10-20 12:00:45.763 NULL
6031271 2005-09-29 16:51:52.487 NULL
6032999 2005-09-23 08:43:01.923 NULL
6034208 2005-09-26 16:27:40.783 NULL
6034224 2005-10-16 09:14:10.327 NULL
6034331 2005-10-07 11:17:31.470 NULL
6034380 2005-10-06 16:05:13.297 NULL
6034781 2005-10-19 11:49:55.747 NULL
6035357 2005-10-04 15:09:54.330 NULL
6035642 2005-10-10 16:56:56.780 NULL
6035644 2005-10-04 10:46:13.953 NULL
6035654 2005-10-07 11:57:13.487 NULL
6035986 2005-09-22 10:41:19.173 NULL
6036579 2005-09-26 11:33:03.627 NULL
6036627 2005-10-10 14:02:31.750 NULL
6038182 2005-10-13 13:30:01.013 NULL
6038899 2005-10-20 17:57:43.403 NULL
6040526 2005-10-04 13:29:32.783 NULL
6040768 2005-09-22 10:13:20.423 NULL
6040856 2005-09-28 11:17:23.907 NULL
6040886 2005-09-27 11:53:55.140 NULL
6041025 2005-10-19 12:51:33.340 NULL
6041387 2005-09-27 17:38:49.563 NULL
6041994 2005-10-17 17:07:26.403 NULL
6042920 2005-10-06 15:25:42.860 NULL
6042970 2005-09-27 14:51:03.580 NULL
6046977 2005-09-30 11:30:19.830 NULL
6047278 2005-10-06 13:52:38.220 NULL
6047390 2005-09-26 16:12:07.640 NULL
6047562 2005-10-01 20:49:14.970 NULL
6047584 2005-10-20 08:21:56.093 NULL
6048107 2005-10-18 16:04:03.390 NULL
6048159 2005-09-26 13:00:46.283 NULL
6048213 2005-09-25 12:24:54.017 NULL
6048229 2005-10-06 12:08:07.750 NULL
6048388 2005-10-03 13:00:33.830 NULL
6052226 2005-09-26 17:01:16.517 NULL
6053544 2005-10-17 10:29:29.763 NULL
6057932 2005-09-26 16:22:25.627 NULL
6064376 2005-10-19 14:42:35.857 NULL
6064481 2005-10-01 11:59:34.233 NULL
6068425 2005-09-30 15:11:36.080 NULL
6068877 2005-10-17 10:35:23.750 NULL

and following is the resultset i get as you can see initially it works fine but later on it puts no even for data which has more than 5 days difference. I am not able to figure out why??
Contract# date diff
000005998955 2005-06-30 08:07:50.720 N
000005998955 2005-07-01 08:07:50.720 Y
000005998955 2005-07-30 08:07:50.720 Y
000005998955 2005-08-25 08:07:50.720 Y
000005998955 2005-09-19 08:07:50.720 N
000005999459 2005-09-19 10:35:26.157 N
000006000339 2005-09-19 10:08:54.847 N
000006000339 2005-09-26 08:16:14.703 N
000006000344 2005-09-19 09:28:21.500 N
000006000348 2005-09-19 09:54:55.047 N
000006000369 2005-09-19 10:06:10.877 N
000006000370 2005-09-19 09:54:00.580 N
000006000379 2005-09-19 10:05:13.893 N
000006000415 2005-09-19 10:33:50.470 N
000006000420 2005-09-19 10:37:47.390 N
000006000420 2005-09-29 11:02:23.860 N
000006000421 2005-09-19 10:49:31.360 N
000006000824 2005-09-19 11:15:05.970 N
000006001024 2005-09-19 11:41:13.643 N
000006001031 2005-09-19 11:31:46.313 N
000006001069 2005-09-19 12:00:55.220 N
000006001077 2005-09-19 12:09:05.487 N
000006001109 2005-09-19 12:31:06.050 N
000006001115 2005-09-19 12:42:52.030 N
000006001127 2005-09-19 12:52:45.673 N
000006001127 2005-10-17 13:33:23.093 N
000006001227 2005-09-19 13:10:21.550 N
000006001227 2005-09-20 12:23:56.657 N
000006001241 2005-09-19 13:15:15.110 N
000006001255 2005-09-19 13:34:52.423 N
000006001265 2005-09-19 13:43:03.343 N
000006001323 2005-09-19 14:18:28.330 N
000006001335 2005-09-19 18:38:06.563 N
000006001337 2005-09-19 14:29:09.220 N
000006001365 2005-09-19 14:53:34.093 N
000006002171 2005-09-19 15:09:35.563 N
000006002173 2005-09-19 15:06:06.563 N
000006004196 2005-09-19 15:30:25.580 N
000006004207 2005-09-19 15:41:15.767 N
000006005525 2005-09-19 15:54:17.640 N
000006007596 2005-09-19 16:16:39.517 N
000006007597 2005-09-19 16:43:36.563 N
000006008099 2005-09-19 16:22:00.110 N
000006008585 2005-09-19 16:27:13.923 N
000006012010 2005-09-19 17:27:21.470 N
000006012041 2005-09-19 18:13:24.110 N
000006014980 2005-09-19 20:48:37.800 N
000006014986 2005-09-20 18:10:54.250 N
000006014987 2005-09-19 20:07:32.220 N
000006032695 2005-09-20 08:49:55.877 N
000006033850 2005-09-20 10:25:16.640 N
000006037077 2005-09-20 11:34:26.407 N
000006037077 2005-09-29 10:39:04.440 N
000006037097 2005-09-20 12:08:21.703 N
000006037097 2005-09-20 18:43:15.423 N
000006037097 2005-09-21 08:19:38.347 N
000006037125 2005-09-20 12:29:15.923 N
000006037144 2005-09-20 12:57:48.923 N
000006042776 2005-09-20 13:55:35.953 N
000006042776 2005-09-22 12:20:13.780 N
000006043898 2005-09-21 12:06:36.360 N
000006043915 2005-09-20 14:36:23.237 N
000006044009 2005-09-20 16:37:13.407 N
000006044016 2005-09-20 16:47:33.347 N
000006044017 2005-09-20 16:55:48.250 N
000006044082 2005-09-20 18:31:05.360 N
000006044091 2005-09-20 19:23:51.110 N
000006044102 2005-09-20 19:03:16.000 N
000006044776 2005-09-21 07:53:23.970 N
000006044826 2005-09-21 09:10:05.720 N
000006044943 2005-09-21 10:01:12.703 N
000006045242 2005-09-21 10:34:14.673 N
000006045273 2005-09-21 11:07:29.500 N
000006045457 2005-09-21 11:58:37.580 N
000006045457 2005-09-23 11:41:19.453 N
000006045489 2005-09-21 12:05:42.500 N
000006045508 2005-09-21 12:17:56.080 N
000006045537 2005-09-21 12:39:51.220 N
000006045566 2005-09-27 16:23:19.797 N
000006045576 2005-09-21 13:05:18.267 N
000006045604 2005-09-21 13:21:14.783 N
000006045630 2005-09-21 13:38:09.750 N
000006045662 2005-09-21 14:06:40.377 N
000006045673 2005-09-21 14:25:43.250 N
000006045693 2005-09-21 14:47:10.377 N
000006045693 2005-09-27 08:54:42.343 N
000006045693 2005-09-27 20:56:09.407 N
000006045763 2005-09-21 15:34:48.300 N
000006045763 2005-09-22 11:24:42.343 N
000006045824 2005-09-21 16:09:47.407 N
000006045882 2005-09-21 17:25:14.893 N
000006045885 2005-09-21 17:24:50.877 N
000006046491 2005-09-21 19:31:07.390 N
000006046493 2005-09-21 19:41:12.610 N
000006046501 2005-09-21 20:11:51.017 N
000006046513 2005-09-21 21:37:13.203 N
000006046760 2005-09-22 08:40:34.547 N
000006048440 2005-09-27 17:34:12.533 N
000006048720 2005-09-22 11:00:43.203 N
000006048836 2005-09-22 11:45:43.453 N
000006048875 2005-09-22 12:01:05.407 N
000006048875 2005-10-05 11:55:59.940 N
000006048963 2005-09-22 13:10:23.860 N
000006048963 2005-09-26 11:37:51.470 N
000006049983 2005-09-23 12:59:20.877 N
000006051165 2005-09-22 14:25:53.423 N
000006051165 2005-09-22 14:27:32.313 N
000006051801 2005-09-22 14:42:28.983 N
000006051886 2005-09-22 15:33:15.767 N
000006051890 2005-09-22 15:37:39.877 N
000006052614 2005-09-22 17:38:01.750 N
000006052626 2005-09-22 17:43:30.267 N
000006052627 2005-09-22 17:45:44.547 N
000006053334 2005-09-23 09:14:36.233 N
000006054267 2005-09-23 09:26:32.923 N
000006060858 2005-09-23 10:20:58.987 N
000006061943 2005-09-23 11:17:41.737 N
000006064108 2005-09-23 11:04:38.640 N
000006064125 2005-09-23 11:31:39.690 N
000006064125 2005-09-27 12:36:02.173 N
000006069119 2005-09-23 12:12:55.377 N
000006069143 2005-09-23 12:28:06.813 N
000006069160 2005-09-23 12:36:04.580 N
000006069835 2005-09-23 13:24:22.033 N
000006069911 2005-09-23 14:08:43.890 N
000006069913 2005-09-23 14:10:54.780 N
000006069913 2005-09-27 18:26:21.593 N
000006069964 2005-09-23 15:36:41.673 N
000006069985 2005-09-23 15:17:00.250 N
000006069985 2005-09-25 11:32:00.097 N
000006070026 2005-09-23 16:32:39.610 N
000006070029 2005-09-23 16:50:40.657 N
000006070128 2005-09-23 18:38:15.203 N
000006070155 2005-09-23 19:32:46.690 N
000006070176 2005-09-23 22:00:41.097 N
000006070234 2005-09-24 09:51:07.830 N
000006070234 2005-09-30 16:57:12.470 N
000006070349 2005-10-03 13:00:31.250 N
000006070355 2005-09-24 12:31:28.517 N
000006070428 2005-09-24 14:05:28.487 N
000006070428 2005-10-13 18:18:05.780 N
000006070444 2005-09-24 14:29:12.750 N
000006070460 2005-09-24 15:02:36.157 N
000006070464 2005-09-24 15:10:23.597 N
000006070481 2005-09-24 15:24:03.267 N
000006070481 2005-09-30 09:48:27.533 N
000006070487 2005-09-24 15:35:48.143 N
000006070500 2005-09-24 15:48:50.267 N
000006070603 2005-09-25 09:20:41.110 N
000006070645 2005-09-25 14:03:03.000 N
000006070652 2005-09-25 14:13:04.190 N
000006071262 2005-09-26 09:23:20.360 N
000006071283 2005-09-26 09:48:36.440 N
000006072202 2005-09-26 10:44:57.890 N
000006072214 2005-09-26 10:54:39.220 N
000006072290 2005-09-26 11:37:55.330 N
000006072379 2005-09-26 12:34:30.860 N
000006072474 2005-09-26 12:58:22.267 N
000006072684 2005-10-04 12:15:29.483 N
000006072698 2005-09-26 13:22:16.563 N
000006073117 2005-09-26 14:08:32.533 N
000006073173 2005-09-26 14:47:13.733 N
000006073201 2005-09-26 15:17:35.923 N
000006073238 2005-09-26 15:36:35.033 N
000006073256 2005-09-26 15:49:34.453 N
000006073295 2005-09-26 16:37:40.800 N
000006073302 2005-09-26 16:23:38.237 N
000006073508 2005-09-26 17:08:23.300 N
000006073511 2005-09-26 17:04:53.580 N
000006073564 2005-09-26 17:57:32.157 N
000006073736 2005-09-26 22:39:09.093 N
000006075015 2005-09-27 09:15:23.533 N
000006075071 2005-09-27 09:32:11.517 N
000006075148 2005-09-27 10:09:46.220 N
000006075150 2005-09-27 10:07:15.533 N
000006075173 2005-09-27 10:31:46.830 N
000006075214 2005-09-27 10:51:18.533 N
000006075238 2005-09-27 11:05:09.640 N
000006075238 2005-09-27 20:22:14.360 N
000006075239 2005-09-27 11:06:41.563 N
000006075262 2005-10-10 15:26:30.060 N
000006075497 2005-09-27 11:48:12.907 N
000006075555 2005-09-27 12:59:12.390 N
000006075729 2005-09-27 13:46:30.127 N
000006075781 2005-09-27 14:13:16.080 N
000006075807 2005-09-27 14:24:33.907 N
000006075865 2005-09-27 15:20:35.940 N
000006075913 2005-09-27 15:30:01.627 N
000006076128 2005-09-27 17:10:59.313 N
000006076215 2005-09-27 18:06:48.750 N
000006076307 2005-09-27 19:32:48.860 N
000006076312 2005-09-27 19:33:25.233 N
000006076322 2005-09-27 19:43:48.550 N
000006076366 2005-09-27 21:25:18.063 N
000006076793 2005-09-28 09:18:51.843 N
000006076795 2005-09-28 09:21:34.800 N
000006076795 2005-09-29 15:03:46.657 N
000006076817 2005-09-28 09:51:35.610 N
000006077133 2005-09-28 10:59:00.860 N
000006077138 2005-09-28 11:01:53.830 N
000006077153 2005-09-28 11:15:47.610 N
000006077153 2005-10-07 12:21:09.627 N
000006077225 2005-09-28 12:52:43.360 N
000006077456 2005-09-28 13:35:53.597 N
000006077524 2005-09-28 14:12:54.690 N
000006077524 2005-10-10 13:04:37.967 N
000006077629 2005-09-28 15:12:34.673 N
000006077663 2005-09-28 15:27:27.547 N
000006077936 2005-09-28 18:19:35.470 N
000006077936 2005-09-28 18:22:55.390 N
000006078050 2005-09-28 19:40:28.500 N
000006078090 2005-09-28 20:38:04.470 N
000006078405 2005-09-29 07:59:29.297 N
000006078406 2005-09-29 07:57:07.143 N
000006079141 2005-09-29 10:10:50.190 N
000006079598 2005-09-29 10:39:19.470 N
000006079643 2005-09-29 11:26:34.313 N
000006079648 2005-09-29 11:29:36.940 N
000006079680 2005-09-29 11:56:44.080 N
000006079872 2005-09-29 14:17:44.953 N
000006079922 2005-09-29 14:35:22.550 N
000006079958 2005-09-29 14:53:50.343 N
000006080073 2005-09-29 15:58:19.547 N
000006080176 2005-09-29 17:05:27.720 N
000006080260 2005-09-29 18:12:55.970 N
000006080265 2005-09-29 18:18:20.877 N
000006080276 2005-09-29 18:37:25.000 N
000006080324 2005-09-29 19:23:08.737 N
000006082319 2005-09-29 21:42:06.017 N
000006082638 2005-09-30 07:45:42.890 N
000006083220 2005-09-30 09:40:26.597 N
000006083232 2005-09-30 10:09:29.580 N
000006083320 2005-09-30 11:42:51.813 N
000006083617 2005-09-30 12:01:52.610 N
000006083720 2005-09-30 13:07:59.483 N
000006083853 2005-09-30 13:55:20.953 N
000006083874 2005-10-06 10:34:32.080 N
000006083890 2005-09-30 14:24:28.703 N
000006083940 2005-09-30 15:03:47.487 N
000006084034 2005-09-30 15:39:27.390 N
000006084090 2005-09-30 16:03:32.940 N
000006084120 2005-09-30 16:21:03.923 N
000006084215 2005-09-30 17:28:56.127 N
000006084215 2005-10-12 12:47:10.920 N
000006084304 2005-09-30 19:06:22.093 N
000006084408 2005-09-30 23:04:48.470 N
000006084418 2005-10-01 08:23:02.110 N
000006084426 2005-10-01 09:05:12.563 N
000006084429 2005-10-01 09:34:19.000 N
000006084439 2005-10-01 11:08:58.940 N
000006084452 2005-10-01 10:54:10.157 N
000006084453 2005-10-01 11:00:28.970 N
000006084499 2005-10-01 13:01:51.487 N
000006084504 2005-10-01 13:13:34.233 N
000006084536 2005-10-01 15:23:39.453 N
000006084575 2005-10-03 00:16:21.500 N
000006084582 2005-10-02 07:49:33.203 N
000006084662 2005-10-02 09:58:04.017 N
000006084663 2005-10-02 10:10:51.970 N
000006084776 2005-10-02 11:39:02.173 N
000006084799 2005-10-02 12:46:46.393 N
000006084805 2005-10-02 14:52:40.597 N
000006084816 2005-10-02 19:29:16.313 N
000006084824 2005-10-02 21:19:38.860 N
000006084837 2005-10-03 00:10:24.640 N
000006085121 2005-10-03 07:30:26.377 N
000006086154 2005-10-03 10:18:25.533 N
000006086166 2005-10-03 10:37:42.093 N
000006086166 2005-10-19 13:10:32.093 N
000006086215 2005-10-03 11:20:52.157 N
000006086230 2005-10-03 11:31:44.453 N
000006086232 2005-10-03 11:33:27.440 N
000006086290 2005-10-03 12:19:25.143 N
000006086296 2005-10-03 12:19:19.470 N
000006086384 2005-10-03 13:56:10.500 N
000006086411 2005-10-03 14:27:42.203 N
000006086445 2005-10-03 15:03:28.050 N
000006086641 2005-10-03 17:08:00.063 N
000006086660 2005-10-03 17:13:29.640 N
000006086697 2005-10-03 17:42:18.033 N
000006086745 2005-10-03 19:14:17.733 N
000006087077 2005-10-04 08:03:18.300 N
000006088431 2005-10-04 11:07:38.550 N
000006089747 2005-10-04 11:28:48.673 N
000006089750 2005-10-04 11:26:13.813 N
000006089789 2005-10-04 11:58:21.250 N
000006089841 2005-10-04 13:15:53.673 N
000006089852 2005-10-06 10:58:03.673 N
000006089857 2005-10-04 13:29:24.300 N
000006090923 2005-10-04 15:22:08.593 N
000006093027 2005-10-04 17:18:11.970 N
000006096450 2005-10-04 18:16:41.063 N
000006097759 2005-10-04 19:20:41.657 N
000006117339 2005-10-05 09:48:37.360 N
000006117342 2005-10-05 09:53:25.470 N
000006119813 2005-10-05 10:30:00.487 N
000006119818 2005-10-05 10:31:12.627 N
000006120763 2005-10-05 10:44:00.143 N
000006122577 2005-10-05 11:04:43.127 N
000006123798 2005-10-05 11:26:34.190 N
000006124321 2005-10-05 11:33:36.893 N
000006127285 2005-10-05 15:47:48.237 N
000006127291 2005-10-06 11:52:33.360 N
000006127304 2005-10-05 12:43:05.860 N
000006129560 2005-10-05 13:28:15.157 N
000006129566 2005-10-05 13:39:24.813 N
000006134237 2005-10-05 17:58:26.783 N
000006134258 2005-10-05 18:37:01.250 N
000006134260 2005-10-05 18:44:01.033 N
000006134287 2005-10-05 19:17:44.940 N
000006134316 2005-10-05 19:43:39.923 N
000006134322 2005-10-05 19:52:49.563 N
000006134326 2005-10-05 19:58:44.673 N
000006137344 2005-10-06 09:03:11.220 N
000006137344 2005-10-14 16:50:36.890 N
000006139676 2005-10-06 10:18:42.533 N
000006139707 2005-10-06 10:51:16.563 N
000006139742 2005-10-06 11:22:58.190 N
000006139821 2005-10-06 12:01:06.283 N
000006139827 2005-10-06 12:00:48.157 N
000006139838 2005-10-06 12:11:23.767 N
000006139876 2005-10-06 13:11:18.533 N
000006142099 2005-10-06 13:39:48.550 N
000006146231 2005-10-06 16:16:47.830 N
000006147229 2005-10-06 16:34:27.000 N
000006147401 2005-10-06 18:10:57.953 N
000006151523 2005-10-07 09:30:42.203 N
000006152875 2005-10-14 13:57:00.140 N
000006152878 2005-10-07 12:44:17.673 N
000006152882 2005-10-07 10:06:39.343 N
000006155846 2005-10-07 11:03:26.767 N
000006156846 2005-10-07 11:02:56.487 N
000006157226 2005-10-07 11:07:12.280 N
000006157232 2005-10-07 11:58:08.360 N
000006157232 2005-10-17 09:00:45.687 N
000006157234 2005-10-07 11:40:46.127 N
000006157238 2005-10-07 12:02:00.643 N
000006157274 2005-10-12 14:28:35.170 N
000006157535 2005-10-07 12:56:48.063 N
000006157560 2005-10-07 13:20:42.750 N
000006158147 2005-10-07 14:26:41.190 N
000006159050 2005-10-07 14:40:09.157 N
000006160487 2005-10-07 14:49:51.080 N
000006160487 2005-10-07 14:57:54.953 N
000006160488 2005-10-07 14:49:31.783 N
000006161657 2005-10-07 17:08:59.673 N
000006161673 2005-10-07 16:54:02.673 N
000006161685 2005-10-07 17:11:17.017 N
000006161727 2005-10-07 17:24:08.173 N
000006161824 2005-10-07 19:09:28.300 N
000006161830 2005-10-07 19:20:04.690 N
000006161848 2005-10-07 19:51:12.690 N
000006161848 2005-10-13 20:33:38.903 N
000006161948 2005-10-08 11:25:06.750 N
000006161958 2005-10-08 11:59:27.203 N
000006161970 2005-10-08 12:41:03.797 N
000006162050 2005-10-08 15:35:13.283 N
000006162054 2005-10-08 15:48:31.110 N
000006162099 2005-10-09 11:14:21.390 N
000006162100 2005-10-09 11:42:13.340 N
000006162104 2005-10-18 14:04:16.187 N
000006162132 2005-10-09 14:15:40.483 N
000006162138 2005-10-09 15:16:33.250 N
000006162139 2005-10-09 15:32:33.797 N
000006162142 2005-10-09 15:41:41.387 N
000006162145 2005-10-09 17:26:13.043 N
000006163281 2005-10-10 09:36:11.653 N
000006163294 2005-10-10 10:01:08.560 N
000006163298 2005-10-10 10:08:01.607 N
000006163329 2005-10-10 10:46:38.030 N
000006163338 2005-10-10 10:53:37.577 N
000006163354 2005-10-10 11:01:48.200 N
000006164534 2005-10-10 11:43:34.467 N
000006164616 2005-10-10 11:53:57.717 N
000006164632 2005-10-10 12:12:13.357 N
000006164745 2005-10-10 12:50:20.560 N
000006164762 2005-10-11 20:19:38.357 N
000006164772 2005-10-10 13:21:18.827 N
000006166363 2005-10-10 13:30:37.013 N
000006166380 2005-10-10 13:58:41.107 N
000006166387 2005-10-10 14:05:39.827 N
000006166390 2005-10-10 14:10:13.390 N
000006166662 2005-10-10 16:12:39.437 N
000006166676 2005-10-10 16:18:16.373 N
000006166725 2005-10-10 16:51:00.920 N
000006166742 2005-10-10 16:58:56.513 N
000006166785 2005-10-10 17:42:20.077 N
000006166797 2005-10-10 17:51:48.343 N
000006166799 2005-10-10 17:52:45.857 N
000006166806 2005-10-10 17:54:18.217 N
000006166810 2005-10-10 18:10:17.500 N
000006166812 2005-10-10 18:08:57.700 N
000006166813 2005-10-10 18:05:56.513 N
000006166822 2005-10-10 18:17:10.513 N
000006166843 2005-10-10 19:03:46.780 N
000006166851 2005-10-10 19:19:55.653 N
000006166882 2005-10-10 20:24:02.530 N
000006167379 2005-10-11 09:41:00.623 N
000006167899 2005-10-11 10:01:27.373 N
000006167906 2005-10-12 16:46:12.967 N
000006167908 2005-10-11 10:16:20.247 N
000006168111 2005-10-11 10:53:19.797 N
000006168226 2005-10-11 12:28:26.093 N
000006168303 2005-10-11 13:12:07.750 N
000006168317 2005-10-11 13:29:20.373 N
000006168317 2005-10-15 12:19:09.403 N
000006168438 2005-10-11 14:06:23.077 N
000006168491 2005-10-11 14:28:28.530 N
000006168507 2005-10-11 14:39:09.873 N
000006168531 2005-10-11 14:49:18.637 N
000006168534 2005-10-11 14:50:05.293 N
000006168549 2005-10-11 14:55:23.437 N
000006168564 2005-10-11 15:02:10.000 N
000006168785 2005-10-11 17:17:03.437 N
000006168808 2005-10-11 17:36:53.700 N
000006168817 2005-10-11 17:44:45.280 N
000006168822 2005-10-11 17:50:08.530 N
000006168875 2005-10-11 19:06:03.997 N
000006168879 2005-10-11 19:16:24.153 N
000006168881 2005-10-11 19:20:22.653 N
000006170157 2005-10-18 09:37:15.140 N
000006170348 2005-10-12 11:23:57.577 N
000006170542 2005-10-12 11:56:24.827 N
000006170553 2005-10-14 14:18:15.420 N
000006170589 2005-10-12 12:35:31.873 N
000006170606 2005-10-12 12:53:15.310 N
000006170644 2005-10-12 13:25:56.403 N
000006170646 2005-10-12 15:16:13.077 N
000006170668 2005-10-12 13:55:45.373 N
000006170752 2005-10-12 14:47:47.577 N
000006170784 2005-10-20 14:35:21.560 N
000006170889 2005-10-12 16:20:44.217 N
000006170890 2005-10-12 16:20:56.437 N
000006170925 2005-10-12 16:49:35.827 N
000006170961 2005-10-12 17:15:06.717 N
000006170965 2005-10-12 17:15:58.937 N
000006170989 2005-10-12 17:34:10.420 N
000006171003 2005-10-12 17:45:21.263 N
000006171019 2005-10-12 18:04:58.217 N
000006171032 2005-10-12 19:06:25.607 N
000006171037 2005-10-12 19:30:41.233 N
000006171269 2005-10-13 08:37:32.060 N
000006171307 2005-10-13 09:51:29.547 N
000006171602 2005-10-14 12:38:01.763 N
000006171871 2005-10-13 12:36:53.967 N
000006171875 2005-10-14 09:27:03.123 N
000006171937 2005-10-13 12:57:29.297 N
000006171941 2005-10-13 13:02:04.280 N
000006171948 2005-10-13 13:08:33.013 N
000006171964 2005-10-13 13:52:31.310 N
000006171971 2005-10-13 13:29:28.077 N
000006171974 2005-10-13 13:32:55.890 N
000006171999 2005-10-13 13:43:49.297 N
000006172062 2005-10-13 14:07:12.217 N
000006172140 2005-10-13 15:03:43.153 N
000006172147 2005-10-13 15:04:59.810 N
000006172200 2005-10-13 15:40:26.390 N
000006172423 2005-10-13 19:25:01.950 N
000006172429 2005-10-13 19:36:11.700 N
000006172429 2005-10-13 19:36:48.357 N
000006172435 2005-10-13 20:15:04.497 N
000006172441 2005-10-13 20:22:39.233 N
000006172618 2005-10-14 08:29:16.077 N
000006172953 2005-10-14 10:03:39.060 N
000006172957 2005-10-14 09:44:33.890 N
000006172958 2005-10-14 09:49:29.530 N
000006172998 2005-10-14 10:44:36.810 N
000006173016 2005-10-14 10:57:04.390 N
000006173241 2005-10-14 16:32:47.077 N
000006173253 2005-10-18 14:14:39.263 N
000006173272 2005-10-14 11:36:17.683 N
000006173318 2005-10-14 11:59:37.640 N
000006173329 2005-10-14 12:08:48.217 N
000006173334 2005-10-14 12:17:55.700 N
000006173606 2005-10-14 13:35:41.140 N
000006173692 2005-10-14 14:18:15.513 N
000006173767 2005-10-14 15:16:19.733 N
000006173850 2005-10-14 15:59:42.700 N
000006173938 2005-10-14 16:51:25.717 N
000006174083 2005-10-15 09:06:52.843 N
000006174084 2005-10-15 09:38:00.263 N
000006174109 2005-10-15 10:47:12.500 N
000006174138 2005-10-15 11:48:44.467 N
000006174150 2005-10-15 12:03:26.357 N
000006174152 2005-10-15 12:14:18.920 N
000006174159 2005-10-15 12:30:06.593 N
000006174171 2005-10-15 13:56:14.047 N
000006174172 2005-10-15 13:26:03.077 N
000006174189 2005-10-15 15:21:34.153 N
000006174202 2005-10-15 16:22:40.547 N
000006174206 2005-10-15 16:43:29.263 N
000006174243 2005-10-16 12:28:05.560 N
000006174248 2005-10-16 09:44:18.780 N
000006174249 2005-10-16 10:04:18.560 N
000006174250 2005-10-16 10:57:48.217 N
000006174254 2005-10-16 14:03:23.390 N
000006174255 2005-10-16 14:22:38.327 N
000006174264 2005-10-16 15:47:25.107 N
000006174303 2005-10-16 18:59:17.390 N
000006174682 2005-10-17 07:59:10.043 N
000006175328 2005-10-19 15:02:28.077 N
000006175352 2005-10-17 09:03:33.373 N
000006175382 2005-10-17 09:57:21.903 N
000006175731 2005-10-17 11:11:08.717 N
000006175769 2005-10-17 11:35:07.187 N
000006175808 2005-10-17 13:37:40.793 N
000006175889 2005-10-17 16:13:27.060 N
000006175934 2005-10-17 13:59:43.763 N
000006175982 2005-10-17 14:34:14.983 N
000006176012 2005-10-17 14:59:46.247 N
000006176205 2005-10-17 17:33:52.280 N
000006176222 2005-10-17 18:06:03.950 N
000006176291 2005-10-17 20:08:29.170 N
000006176639 2005-10-18 08:08:42.093 N
000006176866 2005-10-18 08:50:33.873 N
000006176927 2005-10-18 09:55:51.450 N
000006176945 2005-10-18 10:10:32.593 N
000006176960 2005-10-18 10:35:58.937 N
000006176961 2005-10-18 10:30:09.200 N
000006177071 2005-10-19 07:41:02.343 N
000006177150 2005-10-18 12:59:52.340 N
000006177157 2005-10-18 13:11:12.717 N
000006178479 2005-10-18 14:02:31.233 N
000006178702 2005-10-18 16:37:18.030 N
000006178758 2005-10-18 17:37:52.467 N
000006178850 2005-10-18 18:41:40.060 N
000006178924 2005-10-18 20:33:06.013 N
000006179784 2005-10-19 09:20:13.733 N
000006179785 2005-10-19 09:23:08.093 N
000006179810 2005-10-19 10:27:46.873 N
000006179823 2005-10-19 10:38:21.750 N
000006179825 2005-10-19 12:38:26.933 N
000006179830 2005-10-19 10:45:45.170 N
000006179867 2005-10-19 11:20:11.810 N
000006179872 2005-10-19 11:25:07.170 N
000006179883 2005-10-19 11:46:47.810 N
000006180133 2005-10-19 12:56:54.170 N
000006180152 2005-10-19 13:12:27.653 N
000006180183 2005-10-19 13:27:39.390 N
000006180216 2005-10-19 14:01:55.547 N
000006180250 2005-10-19 14:35:43.763 N
000006180278 2005-10-19 15:04:57.420 N
000006180353 2005-10-19 15:37:02.843 N
000006181374 2005-10-19 17:06:00.593 N
000006182683 2005-10-19 18:27:36.000 N
000006182719 2005-10-19 19:26:16.653 N
000006182721 2005-10-19 19:38:30.107 N
000006183447 2005-10-20 08:57:27.687 N
000006183574 2005-10-20 09:33:04.077 N
000006183576 2005-10-20 09:25:33.030 N
000006183586 2005-10-20 09:43:26.560 N
000006183772 2005-10-20 10:23:26.810 N
000006184851 2005-10-20 10:37:02.310 N
000006185374 2005-10-20 11:07:43.950 N
000006185448 2005-10-20 11:40:41.060 N
000006186091 2005-10-20 11:48:00.140 N
000006186122 2005-10-20 12:16:48.857 N
000006186873 2005-10-20 13:12:27.750 N
000006187684 2005-10-20 14:27:12.827 N
000006187694 2005-10-20 14:35:56.000 N
000006187771 2005-10-20 15:47:17.890 N
000006187820 2005-10-20 16:13:28.013 N
000006187852 2005-10-20 16:38:53.200 N
000006187864 2005-10-20 16:59:24.717 N
5987017 2005-09-20 20:14:59.597 N
5987299 2005-09-25 16:57:28.500 N
5987364 2005-10-03 10:33:36.483 N
5987588 2005-09-30 12:24:57.690 N
5987595 2005-10-20 09:50:22.607 N
5987843 2005-10-13 13:51:14.183 N
5988787 2005-09-21 11:59:47.097 N
5988979 2005-10-06 19:09:25.000 N
5989204 2005-09-29 16:42:44.593 N
5990814 2005-09-26 17:14:43.893 N
5991236 2005-10-17 09:33:24.060 N
5992802 2005-10-19 13:14:16.107 N
5993034 2005-10-01 09:34:08.657 N
5996079 2005-10-04 13:55:31.953 N
5996321 2005-10-17 15:31:20.530 N
5996653 2005-10-20 08:22:00.967 N
5997513 2005-09-22 10:25:50.440 N
5997730 2005-10-03 17:44:33.780 N
5997999 2005-09-23 18:28:43.267 N
6001501 2005-10-03 11:24:53.190 N
6003112 2005-09-19 20:17:49.237 N
6003672 2005-09-25 17:21:45.940 N
6004069 2005-09-23 10:46:43.250 N
6004287 2005-10-11 13:51:06.700 N
6007760 2005-10-16 06:22:09.327 N
6008232 2005-10-01 13:47:03.750 N
6008545 2005-09-19 16:55:55.877 N
6008645 2005-09-20 15:36:27.233 N
6008901 2005-10-19 12:25:41.297 N
6008924 2005-10-01 13:42:03.627 N
6009382 2005-09-23 12:35:15.673 N
6009475 2005-09-27 11:54:15.097 N
6009755 2005-10-17 15:17:30.890 N
6009788 2005-10-08 12:12:06.720 N
6009816 2005-09-22 15:27:29.250 N
6009889 2005-09-26 16:48:23.157 N
6010033 2005-10-19 13:48:10.153 N
6010239 2005-09-29 11:34:10.783 N
6010279 2005-10-14 10:14:36.293 N
6010817 2005-09-27 09:58:26.157 N
6011098 2005-09-29 14:38:41.267 N
6011232 2005-10-07 18:13:38.097 N
6012074 2005-10-16 18:34:24.077 N
6012132 2005-10-16 18:15:56.390 N
6013260 2005-10-19 10:58:29.390 N
6014101 2005-10-10 12:02:22.780 N
6014335 2005-10-03 12:35:35.533 N
6015029 2005-09-21 12:38:05.440 N
6015029 2005-09-22 10:50:17.063 N
6016517 2005-10-05 14:27:07.440 N
6017632 2005-09-27 13:03:06.643 N
6018317 2005-10-15 19:00:39.513 N
6020390 2005-09-20 18:59:33.657 N
6020512 2005-09-23 17:25:25.377 N
6020512 2005-09-27 11:33:56.050 N
6020826 2005-10-12 22:52:26.560 N
6021239 2005-09-22 11:08:42.267 N
6021749 2005-09-22 11:08:06.657 N
6021873 2005-09-29 11:26:58.563 N
6021874 2005-09-29 11:32:03.000 N
6021970 2005-09-20 17:05:41.220 N
6021978 2005-10-07 12:12:46.347 N
6022537 2005-10-02 01:24:04.550 N
6022630 2005-10-12 18:17:47.153 N
6022765 2005-09-26 16:49:43.877 N
6022808 2005-10-04 13:37:44.440 N
6023070 2005-10-07 12:34:59.923 N
6023787 2005-10-04 13:54:06.203 N
6023949 2005-10-13 13:08:06.810 N
6024200 2005-09-23 19:52:43.470 N
6024805 2005-10-18 13:20:30.890 N
6025439 2005-10-20 15:33:49.297 N
6026383 2005-10-10 12:40:11.903 N
6026811 2005-10-10 10:05:42.000 N
6027207 2005-10-10 14:13:39.403 N
6027400 2005-10-12 20:51:05.967 N
6027610 2005-10-17 14:33:25.403 N
6027973 2005-10-05 11:53:22.000 N
6028560 2005-10-10 15:18:39.310 N
6028948 2005-10-12 17:34:40.997 N
6029021 2005-10-06 10:11:34.783 N
6029687 2005-09-30 02:31:39.907 N
6029687 2005-09-30 14:57:27.547 N
6029794 2005-09-30 07:27:28.233 N
6029920 2005-10-05 15:00:43.190 N
6029947 2005-10-17 16:50:51.137 N
6029951 2005-10-11 11:40:14.107 N
6030506 2005-10-10 09:09:19.733 N
6030613 2005-10-20 11:10:35.327 N
6030641 2005-10-02 14:09:51.360 N
6031016 2005-10-14 13:23:36.653 N
6031028 2005-10-20 12:00:45.763 N
6031271 2005-09-29 16:51:52.487 N
6032999 2005-09-23 08:43:01.923 N
6034208 2005-09-26 16:27:40.783 N
6034224 2005-10-16 09:14:10.327 N
6034331 2005-10-07 11:17:31.470 N
6034380 2005-10-06 16:05:13.297 N
6034781 2005-10-19 11:49:55.747 N
6035357 2005-10-04 15:09:54.330 N
6035642 2005-10-10 16:56:56.780 N
6035644 2005-10-04 10:46:13.953 N
6035654 2005-10-07 11:57:13.487 N
6035986 2005-09-22 10:41:19.173 N
6036579 2005-09-26 11:33:03.627 N
6036627 2005-10-10 14:02:31.750 N
6038182 2005-10-13 13:30:01.013 N
6038899 2005-10-20 17:57:43.403 N
6040526 2005-10-04 13:29:32.783 N
6040768 2005-09-22 10:13:20.423 N
6040856 2005-09-28 11:17:23.907 N
6040886 2005-09-27 11:53:55.140 N
6041025 2005-10-19 12:51:33.340 N
6041387 2005-09-27 17:38:49.563 N
6041994 2005-10-17 17:07:26.403 N
6042920 2005-10-06 15:25:42.860 N
6042970 2005-09-27 14:51:03.580 N
6046977 2005-09-30 11:30:19.830 N
6047278 2005-10-06 13:52:38.220 N
6047390 2005-09-26 16:12:07.640 N
6047562 2005-10-01 20:49:14.970 N
6047584 2005-10-20 08:21:56.093 N
6048107 2005-10-18 16:04:03.390 N
6048159 2005-09-26 13:00:46.283 N
6048213 2005-09-25 12:24:54.017 N
6048229 2005-10-06 12:08:07.750 N
6048388 2005-10-03 13:00:33.830 N
6052226 2005-09-26 17:01:16.517 N
6053544 2005-10-17 10:29:29.763 N
6057932 2005-09-26 16:22:25.627 N
6064376 2005-10-19 14:42:35.857 N
6064481 2005-10-01 11:59:34.233 N
6068425 2005-09-30 15:11:36.080 N
6068877 2005-10-17 10:35:23.750 N

 

[Jeet2004]

Contract# date diff
000005998955 2005-06-30 08:07:50.720 N
000005998955 2005-07-01 08:07:50.720 Y
000005998955 2005-07-30 08:07:50.720 Y
000005998955 2005-08-25 08:07:50.720 Y
000005998955 2005-09-19 08:07:50.720 N
000005999459 2005-09-19 10:35:26.157 N
000006000339 2005-09-19 10:08:54.847 N
000006000339 2005-09-26 08:16:14.703 N
000006000344 2005-09-19 09:28:21.500 N
000006000348 2005-09-19 09:54:55.047 N
000006000369 2005-09-19 10:06:10.877 N
000006000370 2005-09-19 09:54:00.580 N
000006000379 2005-09-19 10:05:13.893 N
000006000415 2005-09-19 10:33:50.470 N
000006000420 2005-09-19 10:37:47.390 N
000006000420 2005-09-29 11:02:23.860 N
000006000421 2005-09-19 10:49:31.360 N
000006000824 2005-09-19 11:15:05.970 N
000006001024 2005-09-19 11:41:13.643 N
000006001031 2005-09-19 11:31:46.313 N
000006001069 2005-09-19 12:00:55.220 N
000006001077 2005-09-19 12:09:05.487 N
000006001109 2005-09-19 12:31:06.050 N
000006001115 2005-09-19 12:42:52.030 N
000006001127 2005-09-19 12:52:45.673 N
000006001127 2005-10-17 13:33:23.093 N
000006001227 2005-09-19 13:10:21.550 N
000006001227 2005-09-20 12:23:56.657 N
000006001241 2005-09-19 13:15:15.110 N
000006001255 2005-09-19 13:34:52.423 N
000006001265 2005-09-19 13:43:03.343 N
000006001323 2005-09-19 14:18:28.330 N
000006001335 2005-09-19 18:38:06.563 N
000006001337 2005-09-19 14:29:09.220 N
000006001365 2005-09-19 14:53:34.093 N
000006002171 2005-09-19 15:09:35.563 N
000006002173 2005-09-19 15:06:06.563 N
000006004196 2005-09-19 15:30:25.580 N
000006004207 2005-09-19 15:41:15.767 N
000006005525 2005-09-19 15:54:17.640 N
000006007596 2005-09-19 16:16:39.517 N
000006007597 2005-09-19 16:43:36.563 N
000006008099 2005-09-19 16:22:00.110 N
000006008585 2005-09-19 16:27:13.923 N
000006012010 2005-09-19 17:27:21.470 N
000006012041 2005-09-19 18:13:24.110 N
000006014980 2005-09-19 20:48:37.800 N
000006014986 2005-09-20 18:10:54.250 N
000006014987 2005-09-19 20:07:32.220 N
000006032695 2005-09-20 08:49:55.877 N
000006033850 2005-09-20 10:25:16.640 N
000006037077 2005-09-20 11:34:26.407 N
000006037077 2005-09-29 10:39:04.440 N
000006037097 2005-09-20 12:08:21.703 N
000006037097 2005-09-20 18:43:15.423 N
000006037097 2005-09-21 08:19:38.347 N
000006037125 2005-09-20 12:29:15.923 N
000006037144 2005-09-20 12:57:48.923 N
000006042776 2005-09-20 13:55:35.953 N
000006042776 2005-09-22 12:20:13.780 N
000006043898 2005-09-21 12:06:36.360 N
000006043915 2005-09-20 14:36:23.237 N
000006044009 2005-09-20 16:37:13.407 N
000006044016 2005-09-20 16:47:33.347 N
000006044017 2005-09-20 16:55:48.250 N
000006044082 2005-09-20 18:31:05.360 N
000006044091 2005-09-20 19:23:51.110 N
000006044102 2005-09-20 19:03:16.000 N
000006044776 2005-09-21 07:53:23.970 N
000006044826 2005-09-21 09:10:05.720 N
000006044943 2005-09-21 10:01:12.703 N
000006045242 2005-09-21 10:34:14.673 N
000006045273 2005-09-21 11:07:29.500 N
000006045457 2005-09-21 11:58:37.580 N
000006045457 2005-09-23 11:41:19.453 N
000006045489 2005-09-21 12:05:42.500 N
000006045508 2005-09-21 12:17:56.080 N
000006045537 2005-09-21 12:39:51.220 N
000006045566 2005-09-27 16:23:19.797 N
000006045576 2005-09-21 13:05:18.267 N
000006045604 2005-09-21 13:21:14.783 N
000006045630 2005-09-21 13:38:09.750 N
000006045662 2005-09-21 14:06:40.377 N
000006045673 2005-09-21 14:25:43.250 N
000006045693 2005-09-21 14:47:10.377 N
000006045693 2005-09-27 08:54:42.343 N
000006045693 2005-09-27 20:56:09.407 N
000006045763 2005-09-21 15:34:48.300 N
000006045763 2005-09-22 11:24:42.343 N
000006045824 2005-09-21 16:09:47.407 N
000006045882 2005-09-21 17:25:14.893 N
000006045885 2005-09-21 17:24:50.877 N
000006046491 2005-09-21 19:31:07.390 N
000006046493 2005-09-21 19:41:12.610 N
000006046501 2005-09-21 20:11:51.017 N
000006046513 2005-09-21 21:37:13.203 N
000006046760 2005-09-22 08:40:34.547 N
000006048440 2005-09-27 17:34:12.533 N
000006048720 2005-09-22 11:00:43.203 N
000006048836 2005-09-22 11:45:43.453 N
000006048875 2005-09-22 12:01:05.407 N
000006048875 2005-10-05 11:55:59.940 N
000006048963 2005-09-22 13:10:23.860 N
000006048963 2005-09-26 11:37:51.470 N
000006049983 2005-09-23 12:59:20.877 N
000006051165 2005-09-22 14:25:53.423 N
000006051165 2005-09-22 14:27:32.313 N
000006051801 2005-09-22 14:42:28.983 N
000006051886 2005-09-22 15:33:15.767 N
000006051890 2005-09-22 15:37:39.877 N
000006052614 2005-09-22 17:38:01.750 N
000006052626 2005-09-22 17:43:30.267 N
000006052627 2005-09-22 17:45:44.547 N
000006053334 2005-09-23 09:14:36.233 N
000006054267 2005-09-23 09:26:32.923 N
000006060858 2005-09-23 10:20:58.987 N
000006061943 2005-09-23 11:17:41.737 N
000006064108 2005-09-23 11:04:38.640 N
000006064125 2005-09-23 11:31:39.690 N
000006064125 2005-09-27 12:36:02.173 N
000006069119 2005-09-23 12:12:55.377 N
000006069143 2005-09-23 12:28:06.813 N
000006069160 2005-09-23 12:36:04.580 N
000006069835 2005-09-23 13:24:22.033 N
000006069911 2005-09-23 14:08:43.890 N
000006069913 2005-09-23 14:10:54.780 N
000006069913 2005-09-27 18:26:21.593 N
000006069964 2005-09-23 15:36:41.673 N
000006069985 2005-09-23 15:17:00.250 N
000006069985 2005-09-25 11:32:00.097 N
000006070026 2005-09-23 16:32:39.610 N
000006070029 2005-09-23 16:50:40.657 N
000006070128 2005-09-23 18:38:15.203 N
000006070155 2005-09-23 19:32:46.690 N
000006070176 2005-09-23 22:00:41.097 N
000006070234 2005-09-24 09:51:07.830 N
000006070234 2005-09-30 16:57:12.470 N
000006070349 2005-10-03 13:00:31.250 N
000006070355 2005-09-24 12:31:28.517 N
000006070428 2005-09-24 14:05:28.487 N
000006070428 2005-10-13 18:18:05.780 N
000006070444 2005-09-24 14:29:12.750 N
000006070460 2005-09-24 15:02:36.157 N
000006070464 2005-09-24 15:10:23.597 N
000006070481 2005-09-24 15:24:03.267 N
000006070481 2005-09-30 09:48:27.533 N
000006070487 2005-09-24 15:35:48.143 N
000006070500 2005-09-24 15:48:50.267 N
000006070603 2005-09-25 09:20:41.110 N
000006070645 2005-09-25 14:03:03.000 N
000006070652 2005-09-25 14:13:04.190 N
000006071262 2005-09-26 09:23:20.360 N
000006071283 2005-09-26 09:48:36.440 N
000006072202 2005-09-26 10:44:57.890 N
000006072214 2005-09-26 10:54:39.220 N
000006072290 2005-09-26 11:37:55.330 N
000006072379 2005-09-26 12:34:30.860 N
000006072474 2005-09-26 12:58:22.267 N
000006072684 2005-10-04 12:15:29.483 N
000006072698 2005-09-26 13:22:16.563 N
000006073117 2005-09-26 14:08:32.533 N
000006073173 2005-09-26 14:47:13.733 N
000006073201 2005-09-26 15:17:35.923 N
000006073238 2005-09-26 15:36:35.033 N
000006073256 2005-09-26 15:49:34.453 N
000006073295 2005-09-26 16:37:40.800 N
000006073302 2005-09-26 16:23:38.237 N
000006073508 2005-09-26 17:08:23.300 N
000006073511 2005-09-26 17:04:53.580 N
000006073564 2005-09-26 17:57:32.157 N
000006073736 2005-09-26 22:39:09.093 N
000006075015 2005-09-27 09:15:23.533 N
000006075071 2005-09-27 09:32:11.517 N
000006075148 2005-09-27 10:09:46.220 N
000006075150 2005-09-27 10:07:15.533 N
000006075173 2005-09-27 10:31:46.830 N
000006075214 2005-09-27 10:51:18.533 N
000006075238 2005-09-27 11:05:09.640 N
000006075238 2005-09-27 20:22:14.360 N
000006075239 2005-09-27 11:06:41.563 N
000006075262 2005-10-10 15:26:30.060 N
000006075497 2005-09-27 11:48:12.907 N
000006075555 2005-09-27 12:59:12.390 N
000006075729 2005-09-27 13:46:30.127 N
000006075781 2005-09-27 14:13:16.080 N
000006075807 2005-09-27 14:24:33.907 N
000006075865 2005-09-27 15:20:35.940 N
000006075913 2005-09-27 15:30:01.627 N
000006076128 2005-09-27 17:10:59.313 N
000006076215 2005-09-27 18:06:48.750 N
000006076307 2005-09-27 19:32:48.860 N
000006076312 2005-09-27 19:33:25.233 N
000006076322 2005-09-27 19:43:48.550 N
000006076366 2005-09-27 21:25:18.063 N
000006076793 2005-09-28 09:18:51.843 N
000006076795 2005-09-28 09:21:34.800 N
000006076795 2005-09-29 15:03:46.657 N
000006076817 2005-09-28 09:51:35.610 N
000006077133 2005-09-28 10:59:00.860 N
000006077138 2005-09-28 11:01:53.830 N
000006077153 2005-09-28 11:15:47.610 N
000006077153 2005-10-07 12:21:09.627 N
000006077225 2005-09-28 12:52:43.360 N
000006077456 2005-09-28 13:35:53.597 N
000006077524 2005-09-28 14:12:54.690 N
000006077524 2005-10-10 13:04:37.967 N
000006077629 2005-09-28 15:12:34.673 N
000006077663 2005-09-28 15:27:27.547 N
000006077936 2005-09-28 18:19:35.470 N
000006077936 2005-09-28 18:22:55.390 N
000006078050 2005-09-28 19:40:28.500 N
000006078090 2005-09-28 20:38:04.470 N
000006078405 2005-09-29 07:59:29.297 N
000006078406 2005-09-29 07:57:07.143 N
000006079141 2005-09-29 10:10:50.190 N
000006079598 2005-09-29 10:39:19.470 N
000006079643 2005-09-29 11:26:34.313 N
000006079648 2005-09-29 11:29:36.940 N
000006079680 2005-09-29 11:56:44.080 N
000006079872 2005-09-29 14:17:44.953 N
000006079922 2005-09-29 14:35:22.550 N
000006079958 2005-09-29 14:53:50.343 N
000006080073 2005-09-29 15:58:19.547 N
000006080176 2005-09-29 17:05:27.720 N
000006080260 2005-09-29 18:12:55.970 N
000006080265 2005-09-29 18:18:20.877 N
000006080276 2005-09-29 18:37:25.000 N
000006080324 2005-09-29 19:23:08.737 N
000006082319 2005-09-29 21:42:06.017 N
000006082638 2005-09-30 07:45:42.890 N
000006083220 2005-09-30 09:40:26.597 N
000006083232 2005-09-30 10:09:29.580 N
000006083320 2005-09-30 11:42:51.813 N
000006083617 2005-09-30 12:01:52.610 N
000006083720 2005-09-30 13:07:59.483 N
000006083853 2005-09-30 13:55:20.953 N
000006083874 2005-10-06 10:34:32.080 N
000006083890 2005-09-30 14:24:28.703 N
000006083940 2005-09-30 15:03:47.487 N
000006084034 2005-09-30 15:39:27.390 N
000006084090 2005-09-30 16:03:32.940 N
000006084120 2005-09-30 16:21:03.923 N
000006084215 2005-09-30 17:28:56.127 N
000006084215 2005-10-12 12:47:10.920 N
000006084304 2005-09-30 19:06:22.093 N
000006084408 2005-09-30 23:04:48.470 N
000006084418 2005-10-01 08:23:02.110 N
000006084426 2005-10-01 09:05:12.563 N
000006084429 2005-10-01 09:34:19.000 N
000006084439 2005-10-01 11:08:58.940 N
000006084452 2005-10-01 10:54:10.157 N
000006084453 2005-10-01 11:00:28.970 N
000006084499 2005-10-01 13:01:51.487 N
000006084504 2005-10-01 13:13:34.233 N
000006084536 2005-10-01 15:23:39.453 N
000006084575 2005-10-03 00:16:21.500 N
000006084582 2005-10-02 07:49:33.203 N
000006084662 2005-10-02 09:58:04.017 N
000006084663 2005-10-02 10:10:51.970 N
000006084776 2005-10-02 11:39:02.173 N
000006084799 2005-10-02 12:46:46.393 N
000006084805 2005-10-02 14:52:40.597 N
000006084816 2005-10-02 19:29:16.313 N
000006084824 2005-10-02 21:19:38.860 N
000006084837 2005-10-03 00:10:24.640 N
000006085121 2005-10-03 07:30:26.377 N
000006086154 2005-10-03 10:18:25.533 N
000006086166 2005-10-03 10:37:42.093 N
000006086166 2005-10-19 13:10:32.093 N
000006086215 2005-10-03 11:20:52.157 N
000006086230 2005-10-03 11:31:44.453 N
000006086232 2005-10-03 11:33:27.440 N
000006086290 2005-10-03 12:19:25.143 N
000006086296 2005-10-03 12:19:19.470 N
000006086384 2005-10-03 13:56:10.500 N
000006086411 2005-10-03 14:27:42.203 N
000006086445 2005-10-03 15:03:28.050 N
000006086641 2005-10-03 17:08:00.063 N
000006086660 2005-10-03 17:13:29.640 N
000006086697 2005-10-03 17:42:18.033 N
000006086745 2005-10-03 19:14:17.733 N
000006087077 2005-10-04 08:03:18.300 N
000006088431 2005-10-04 11:07:38.550 N
000006089747 2005-10-04 11:28:48.673 N
000006089750 2005-10-04 11:26:13.813 N
000006089789 2005-10-04 11:58:21.250 N
000006089841 2005-10-04 13:15:53.673 N
000006089852 2005-10-06 10:58:03.673 N
000006089857 2005-10-04 13:29:24.300 N
000006090923 2005-10-04 15:22:08.593 N
000006093027 2005-10-04 17:18:11.970 N
000006096450 2005-10-04 18:16:41.063 N
000006097759 2005-10-04 19:20:41.657 N
000006117339 2005-10-05 09:48:37.360 N
000006117342 2005-10-05 09:53:25.470 N
000006119813 2005-10-05 10:30:00.487 N
000006119818 2005-10-05 10:31:12.627 N
000006120763 2005-10-05 10:44:00.143 N
000006122577 2005-10-05 11:04:43.127 N
000006123798 2005-10-05 11:26:34.190 N
000006124321 2005-10-05 11:33:36.893 N
000006127285 2005-10-05 15:47:48.237 N
000006127291 2005-10-06 11:52:33.360 N
000006127304 2005-10-05 12:43:05.860 N
000006129560 2005-10-05 13:28:15.157 N
000006129566 2005-10-05 13:39:24.813 N
000006134237 2005-10-05 17:58:26.783 N
000006134258 2005-10-05 18:37:01.250 N
000006134260 2005-10-05 18:44:01.033 N
000006134287 2005-10-05 19:17:44.940 N
000006134316 2005-10-05 19:43:39.923 N
000006134322 2005-10-05 19:52:49.563 N
000006134326 2005-10-05 19:58:44.673 N
000006137344 2005-10-06 09:03:11.220 N
000006137344 2005-10-14 16:50:36.890 N
000006139676 2005-10-06 10:18:42.533 N
000006139707 2005-10-06 10:51:16.563 N
000006139742 2005-10-06 11:22:58.190 N
000006139821 2005-10-06 12:01:06.283 N
000006139827 2005-10-06 12:00:48.157 N
000006139838 2005-10-06 12:11:23.767 N
000006139876 2005-10-06 13:11:18.533 N
000006142099 2005-10-06 13:39:48.550 N
000006146231 2005-10-06 16:16:47.830 N
000006147229 2005-10-06 16:34:27.000 N
000006147401 2005-10-06 18:10:57.953 N
000006151523 2005-10-07 09:30:42.203 N
000006152875 2005-10-14 13:57:00.140 N
000006152878 2005-10-07 12:44:17.673 N
000006152882 2005-10-07 10:06:39.343 N
000006155846 2005-10-07 11:03:26.767 N
000006156846 2005-10-07 11:02:56.487 N
000006157226 2005-10-07 11:07:12.280 N
000006157232 2005-10-07 11:58:08.360 N
000006157232 2005-10-17 09:00:45.687 N
000006157234 2005-10-07 11:40:46.127 N
000006157238 2005-10-07 12:02:00.643 N
000006157274 2005-10-12 14:28:35.170 N
000006157535 2005-10-07 12:56:48.063 N
000006157560 2005-10-07 13:20:42.750 N
000006158147 2005-10-07 14:26:41.190 N
000006159050 2005-10-07 14:40:09.157 N
000006160487 2005-10-07 14:49:51.080 N
000006160487 2005-10-07 14:57:54.953 N
000006160488 2005-10-07 14:49:31.783 N
000006161657 2005-10-07 17:08:59.673 N
000006161673 2005-10-07 16:54:02.673 N
000006161685 2005-10-07 17:11:17.017 N
000006161727 2005-10-07 17:24:08.173 N
000006161824 2005-10-07 19:09:28.300 N
000006161830 2005-10-07 19:20:04.690 N
000006161848 2005-10-07 19:51:12.690 N
000006161848 2005-10-13 20:33:38.903 N
000006161948 2005-10-08 11:25:06.750 N
000006161958 2005-10-08 11:59:27.203 N
000006161970 2005-10-08 12:41:03.797 N
000006162050 2005-10-08 15:35:13.283 N
000006162054 2005-10-08 15:48:31.110 N
000006162099 2005-10-09 11:14:21.390 N
000006162100 2005-10-09 11:42:13.340 N
000006162104 2005-10-18 14:04:16.187 N
000006162132 2005-10-09 14:15:40.483 N
000006162138 2005-10-09 15:16:33.250 N
000006162139 2005-10-09 15:32:33.797 N
000006162142 2005-10-09 15:41:41.387 N
000006162145 2005-10-09 17:26:13.043 N
000006163281 2005-10-10 09:36:11.653 N
000006163294 2005-10-10 10:01:08.560 N
000006163298 2005-10-10 10:08:01.607 N
000006163329 2005-10-10 10:46:38.030 N
000006163338 2005-10-10 10:53:37.577 N
000006163354 2005-10-10 11:01:48.200 N
000006164534 2005-10-10 11:43:34.467 N
000006164616 2005-10-10 11:53:57.717 N
000006164632 2005-10-10 12:12:13.357 N
000006164745 2005-10-10 12:50:20.560 N
000006164762 2005-10-11 20:19:38.357 N
000006164772 2005-10-10 13:21:18.827 N
000006166363 2005-10-10 13:30:37.013 N
000006166380 2005-10-10 13:58:41.107 N
000006166387 2005-10-10 14:05:39.827 N
000006166390 2005-10-10 14:10:13.390 N
000006166662 2005-10-10 16:12:39.437 N
000006166676 2005-10-10 16:18:16.373 N
000006166725 2005-10-10 16:51:00.920 N
000006166742 2005-10-10 16:58:56.513 N
000006166785 2005-10-10 17:42:20.077 N
000006166797 2005-10-10 17:51:48.343 N
000006166799 2005-10-10 17:52:45.857 N
000006166806 2005-10-10 17:54:18.217 N
000006166810 2005-10-10 18:10:17.500 N
000006166812 2005-10-10 18:08:57.700 N
000006166813 2005-10-10 18:05:56.513 N
000006166822 2005-10-10 18:17:10.513 N
000006166843 2005-10-10 19:03:46.780 N
000006166851 2005-10-10 19:19:55.653 N
000006166882 2005-10-10 20:24:02.530 N
000006167379 2005-10-11 09:41:00.623 N
000006167899 2005-10-11 10:01:27.373 N
000006167906 2005-10-12 16:46:12.967 N
000006167908 2005-10-11 10:16:20.247 N
000006168111 2005-10-11 10:53:19.797 N
000006168226 2005-10-11 12:28:26.093 N
000006168303 2005-10-11 13:12:07.750 N
000006168317 2005-10-11 13:29:20.373 N
000006168317 2005-10-15 12:19:09.403 N
000006168438 2005-10-11 14:06:23.077 N
000006168491 2005-10-11 14:28:28.530 N
000006168507 2005-10-11 14:39:09.873 N
000006168531 2005-10-11 14:49:18.637 N
000006168534 2005-10-11 14:50:05.293 N
000006168549 2005-10-11 14:55:23.437 N
000006168564 2005-10-11 15:02:10.000 N
000006168785 2005-10-11 17:17:03.437 N
000006168808 2005-10-11 17:36:53.700 N
000006168817 2005-10-11 17:44:45.280 N
000006168822 2005-10-11 17:50:08.530 N
000006168875 2005-10-11 19:06:03.997 N
000006168879 2005-10-11 19:16:24.153 N
000006168881 2005-10-11 19:20:22.653 N
000006170157 2005-10-18 09:37:15.140 N
000006170348 2005-10-12 11:23:57.577 N
000006170542 2005-10-12 11:56:24.827 N
000006170553 2005-10-14 14:18:15.420 N
000006170589 2005-10-12 12:35:31.873 N
000006170606 2005-10-12 12:53:15.310 N
000006170644 2005-10-12 13:25:56.403 N
000006170646 2005-10-12 15:16:13.077 N
000006170668 2005-10-12 13:55:45.373 N
000006170752 2005-10-12 14:47:47.577 N
000006170784 2005-10-20 14:35:21.560 N
000006170889 2005-10-12 16:20:44.217 N
000006170890 2005-10-12 16:20:56.437 N
000006170925 2005-10-12 16:49:35.827 N
000006170961 2005-10-12 17:15:06.717 N
000006170965 2005-10-12 17:15:58.937 N
000006170989 2005-10-12 17:34:10.420 N
000006171003 2005-10-12 17:45:21.263 N
000006171019 2005-10-12 18:04:58.217 N
000006171032 2005-10-12 19:06:25.607 N
000006171037 2005-10-12 19:30:41.233 N
000006171269 2005-10-13 08:37:32.060 N
000006171307 2005-10-13 09:51:29.547 N
000006171602 2005-10-14 12:38:01.763 N
000006171871 2005-10-13 12:36:53.967 N
000006171875 2005-10-14 09:27:03.123 N
000006171937 2005-10-13 12:57:29.297 N
000006171941 2005-10-13 13:02:04.280 N
000006171948 2005-10-13 13:08:33.013 N
000006171964 2005-10-13 13:52:31.310 N
000006171971 2005-10-13 13:29:28.077 N
000006171974 2005-10-13 13:32:55.890 N
000006171999 2005-10-13 13:43:49.297 N
000006172062 2005-10-13 14:07:12.217 N
000006172140 2005-10-13 15:03:43.153 N
000006172147 2005-10-13 15:04:59.810 N
000006172200 2005-10-13 15:40:26.390 N
000006172423 2005-10-13 19:25:01.950 N
000006172429 2005-10-13 19:36:11.700 N
000006172429 2005-10-13 19:36:48.357 N
000006172435 2005-10-13 20:15:04.497 N
000006172441 2005-10-13 20:22:39.233 N
000006172618 2005-10-14 08:29:16.077 N
000006172953 2005-10-14 10:03:39.060 N
000006172957 2005-10-14 09:44:33.890 N
000006172958 2005-10-14 09:49:29.530 N
000006172998 2005-10-14 10:44:36.810 N
000006173016 2005-10-14 10:57:04.390 N
000006173241 2005-10-14 16:32:47.077 N
000006173253 2005-10-18 14:14:39.263 N
000006173272 2005-10-14 11:36:17.683 N
000006173318 2005-10-14 11:59:37.640 N
000006173329 2005-10-14 12:08:48.217 N
000006173334 2005-10-14 12:17:55.700 N
000006173606 2005-10-14 13:35:41.140 N
000006173692 2005-10-14 14:18:15.513 N
000006173767 2005-10-14 15:16:19.733 N
000006173850 2005-10-14 15:59:42.700 N
000006173938 2005-10-14 16:51:25.717 N
000006174083 2005-10-15 09:06:52.843 N
000006174084 2005-10-15 09:38:00.263 N
000006174109 2005-10-15 10:47:12.500 N
000006174138 2005-10-15 11:48:44.467 N
000006174150 2005-10-15 12:03:26.357 N
000006174152 2005-10-15 12:14:18.920 N
000006174159 2005-10-15 12:30:06.593 N
000006174171 2005-10-15 13:56:14.047 N
000006174172 2005-10-15 13:26:03.077 N
000006174189 2005-10-15 15:21:34.153 N
000006174202 2005-10-15 16:22:40.547 N
000006174206 2005-10-15 16:43:29.263 N
000006174243 2005-10-16 12:28:05.560 N
000006174248 2005-10-16 09:44:18.780 N
000006174249 2005-10-16 10:04:18.560 N
000006174250 2005-10-16 10:57:48.217 N
000006174254 2005-10-16 14:03:23.390 N
000006174255 2005-10-16 14:22:38.327 N
000006174264 2005-10-16 15:47:25.107 N
000006174303 2005-10-16 18:59:17.390 N
000006174682 2005-10-17 07:59:10.043 N
000006175328 2005-10-19 15:02:28.077 N
000006175352 2005-10-17 09:03:33.373 N
000006175382 2005-10-17 09:57:21.903 N
000006175731 2005-10-17 11:11:08.717 N
000006175769 2005-10-17 11:35:07.187 N
000006175808 2005-10-17 13:37:40.793 N
000006175889 2005-10-17 16:13:27.060 N
000006175934 2005-10-17 13:59:43.763 N
000006175982 2005-10-17 14:34:14.983 N
000006176012 2005-10-17 14:59:46.247 N
000006176205 2005-10-17 17:33:52.280 N
000006176222 2005-10-17 18:06:03.950 N
000006176291 2005-10-17 20:08:29.170 N
000006176639 2005-10-18 08:08:42.093 N
000006176866 2005-10-18 08:50:33.873 N
000006176927 2005-10-18 09:55:51.450 N
000006176945 2005-10-18 10:10:32.593 N
000006176960 2005-10-18 10:35:58.937 N
000006176961 2005-10-18 10:30:09.200 N
000006177071 2005-10-19 07:41:02.343 N
000006177150 2005-10-18 12:59:52.340 N
000006177157 2005-10-18 13:11:12.717 N
000006178479 2005-10-18 14:02:31.233 N
000006178702 2005-10-18 16:37:18.030 N
000006178758 2005-10-18 17:37:52.467 N
000006178850 2005-10-18 18:41:40.060 N
000006178924 2005-10-18 20:33:06.013 N
000006179784 2005-10-19 09:20:13.733 N
000006179785 2005-10-19 09:23:08.093 N
000006179810 2005-10-19 10:27:46.873 N
000006179823 2005-10-19 10:38:21.750 N
000006179825 2005-10-19 12:38:26.933 N
000006179830 2005-10-19 10:45:45.170 N
000006179867 2005-10-19 11:20:11.810 N
000006179872 2005-10-19 11:25:07.170 N
000006179883 2005-10-19 11:46:47.810 N
000006180133 2005-10-19 12:56:54.170 N
000006180152 2005-10-19 13:12:27.653 N
000006180183 2005-10-19 13:27:39.390 N
000006180216 2005-10-19 14:01:55.547 N
000006180250 2005-10-19 14:35:43.763 N
000006180278 2005-10-19 15:04:57.420 N
000006180353 2005-10-19 15:37:02.843 N
000006181374 2005-10-19 17:06:00.593 N
000006182683 2005-10-19 18:27:36.000 N
000006182719 2005-10-19 19:26:16.653 N
000006182721 2005-10-19 19:38:30.107 N
000006183447 2005-10-20 08:57:27.687 N
000006183574 2005-10-20 09:33:04.077 N
000006183576 2005-10-20 09:25:33.030 N
000006183586 2005-10-20 09:43:26.560 N
000006183772 2005-10-20 10:23:26.810 N
000006184851 2005-10-20 10:37:02.310 N
000006185374 2005-10-20 11:07:43.950 N
000006185448 2005-10-20 11:40:41.060 N
000006186091 2005-10-20 11:48:00.140 N
000006186122 2005-10-20 12:16:48.857 N
000006186873 2005-10-20 13:12:27.750 N
000006187684 2005-10-20 14:27:12.827 N
000006187694 2005-10-20 14:35:56.000 N
000006187771 2005-10-20 15:47:17.890 N
000006187820 2005-10-20 16:13:28.013 N
000006187852 2005-10-20 16:38:53.200 N
000006187864 2005-10-20 16:59:24.717 N
5987017 2005-09-20 20:14:59.597 N
5987299 2005-09-25 16:57:28.500 N
5987364 2005-10-03 10:33:36.483 N
5987588 2005-09-30 12:24:57.690 N
5987595 2005-10-20 09:50:22.607 N
5987843 2005-10-13 13:51:14.183 N
5988787 2005-09-21 11:59:47.097 N
5988979 2005-10-06 19:09:25.000 N
5989204 2005-09-29 16:42:44.593 N
5990814 2005-09-26 17:14:43.893 N
5991236 2005-10-17 09:33:24.060 N
5992802 2005-10-19 13:14:16.107 N
5993034 2005-10-01 09:34:08.657 N
5996079 2005-10-04 13:55:31.953 N
5996321 2005-10-17 15:31:20.530 N
5996653 2005-10-20 08:22:00.967 N
5997513 2005-09-22 10:25:50.440 N
5997730 2005-10-03 17:44:33.780 N
5997999 2005-09-23 18:28:43.267 N
6001501 2005-10-03 11:24:53.190 N
6003112 2005-09-19 20:17:49.237 N
6003672 2005-09-25 17:21:45.940 N
6004069 2005-09-23 10:46:43.250 N
6004287 2005-10-11 13:51:06.700 N
6007760 2005-10-16 06:22:09.327 N
6008232 2005-10-01 13:47:03.750 N
6008545 2005-09-19 16:55:55.877 N
6008645 2005-09-20 15:36:27.233 N
6008901 2005-10-19 12:25:41.297 N
6008924 2005-10-01 13:42:03.627 N
6009382 2005-09-23 12:35:15.673 N
6009475 2005-09-27 11:54:15.097 N
6009755 2005-10-17 15:17:30.890 N
6009788 2005-10-08 12:12:06.720 N
6009816 2005-09-22 15:27:29.250 N
6009889 2005-09-26 16:48:23.157 N
6010033 2005-10-19 13:48:10.153 N
6010239 2005-09-29 11:34:10.783 N
6010279 2005-10-14 10:14:36.293 N
6010817 2005-09-27 09:58:26.157 N
6011098 2005-09-29 14:38:41.267 N
6011232 2005-10-07 18:13:38.097 N
6012074 2005-10-16 18:34:24.077 N
6012132 2005-10-16 18:15:56.390 N
6013260 2005-10-19 10:58:29.390 N
6014101 2005-10-10 12:02:22.780 N
6014335 2005-10-03 12:35:35.533 N
6015029 2005-09-21 12:38:05.440 N
6015029 2005-09-22 10:50:17.063 N
6016517 2005-10-05 14:27:07.440 N
6017632 2005-09-27 13:03:06.643 N
6018317 2005-10-15 19:00:39.513 N
6020390 2005-09-20 18:59:33.657 N
6020512 2005-09-23 17:25:25.377 N
6020512 2005-09-27 11:33:56.050 N
6020826 2005-10-12 22:52:26.560 N
6021239 2005-09-22 11:08:42.267 N
6021749 2005-09-22 11:08:06.657 N
6021873 2005-09-29 11:26:58.563 N
6021874 2005-09-29 11:32:03.000 N
6021970 2005-09-20 17:05:41.220 N
6021978 2005-10-07 12:12:46.347 N
6022537 2005-10-02 01:24:04.550 N
6022630 2005-10-12 18:17:47.153 N
6022765 2005-09-26 16:49:43.877 N
6022808 2005-10-04 13:37:44.440 N
6023070 2005-10-07 12:34:59.923 N
6023787 2005-10-04 13:54:06.203 N
6023949 2005-10-13 13:08:06.810 N
6024200 2005-09-23 19:52:43.470 N
6024805 2005-10-18 13:20:30.890 N
6025439 2005-10-20 15:33:49.297 N
6026383 2005-10-10 12:40:11.903 N
6026811 2005-10-10 10:05:42.000 N
6027207 2005-10-10 14:13:39.403 N
6027400 2005-10-12 20:51:05.967 N
6027610 2005-10-17 14:33:25.403 N
6027973 2005-10-05 11:53:22.000 N
6028560 2005-10-10 15:18:39.310 N
6028948 2005-10-12 17:34:40.997 N
6029021 2005-10-06 10:11:34.783 N
6029687 2005-09-30 02:31:39.907 N
6029687 2005-09-30 14:57:27.547 N
6029794 2005-09-30 07:27:28.233 N
6029920 2005-10-05 15:00:43.190 N
6029947 2005-10-17 16:50:51.137 N
6029951 2005-10-11 11:40:14.107 N
6030506 2005-10-10 09:09:19.733 N
6030613 2005-10-20 11:10:35.327 N
6030641 2005-10-02 14:09:51.360 N
6031016 2005-10-14 13:23:36.653 N
6031028 2005-10-20 12:00:45.763 N
6031271 2005-09-29 16:51:52.487 N
6032999 2005-09-23 08:43:01.923 N
6034208 2005-09-26 16:27:40.783 N
6034224 2005-10-16 09:14:10.327 N
6034331 2005-10-07 11:17:31.470 N
6034380 2005-10-06 16:05:13.297 N
6034781 2005-10-19 11:49:55.747 N
6035357 2005-10-04 15:09:54.330 N
6035642 2005-10-10 16:56:56.780 N
6035644 2005-10-04 10:46:13.953 N
6035654 2005-10-07 11:57:13.487 N
6035986 2005-09-22 10:41:19.173 N
6036579 2005-09-26 11:33:03.627 N
6036627 2005-10-10 14:02:31.750 N
6038182 2005-10-13 13:30:01.013 N
6038899 2005-10-20 17:57:43.403 N
6040526 2005-10-04 13:29:32.783 N
6040768 2005-09-22 10:13:20.423 N
6040856 2005-09-28 11:17:23.907 N
6040886 2005-09-27 11:53:55.140 N
6041025 2005-10-19 12:51:33.340 N
6041387 2005-09-27 17:38:49.563 N
6041994 2005-10-17 17:07:26.403 N
6042920 2005-10-06 15:25:42.860 N
6042970 2005-09-27 14:51:03.580 N
6046977 2005-09-30 11:30:19.830 N
6047278 2005-10-06 13:52:38.220 N
6047390 2005-09-26 16:12:07.640 N
6047562 2005-10-01 20:49:14.970 N
6047584 2005-10-20 08:21:56.093 N
6048107 2005-10-18 16:04:03.390 N
6048159 2005-09-26 13:00:46.283 N
6048213 2005-09-25 12:24:54.017 N
6048229 2005-10-06 12:08:07.750 N
6048388 2005-10-03 13:00:33.830 N
6052226 2005-09-26 17:01:16.517 N
6053544 2005-10-17 10:29:29.763 N
6057932 2005-09-26 16:22:25.627 N
6064376 2005-10-19 14:42:35.857 N
6064481 2005-10-01 11:59:34.233 N
6068425 2005-09-30 15:11:36.080 N
6068877 2005-10-17 10:35:23.750 N

 

[vongrunt]

Hey! Please be gentle - 2x700 lines of data dump is really not necessary.

> ... but later on it puts no even for data which has more than 5 days difference. I am not able to figure out why

Perhaps because Contract# values are different?

------
"There's a man... He's bald and wears a short-sleeved shirt, and somehow he's very important to me. I think his name is Homer."
(Jack O'Neill, Stargate)

 

[Jeet2004]

also FYI this is what i get when i printout t2.date
contract# t1.dat diff t2.date
000005998955 2005-06-30 08:07:50.720 N 2005-07-01 08:07:50.720
000005998955 2005-07-01 08:07:50.720 Y 2005-07-30 08:07:50.720
000005998955 2005-07-30 08:07:50.720 Y 2005-08-25 08:07:50.720
000005998955 2005-08-25 08:07:50.720 Y 2005-09-19 08:07:50.720
000005998955 2005-09-19 08:07:50.720 N NULL
000005999459 2005-09-19 10:35:26.157 N NULL
000006000339 2005-09-19 10:08:54.847 N NULL
000006000339 2005-09-26 08:16:14.703 N NULL
000006000344 2005-09-19 09:28:21.500 N NULL
000006000348 2005-09-19 09:54:55.047 N NULL
000006000369 2005-09-19 10:06:10.877 N NULL
000006000370 2005-09-19 09:54:00.580 N NULL
000006000379 2005-09-19 10:05:13.893 N NULL
000006000415 2005-09-19 10:33:50.470 N NULL
000006000420 2005-09-19 10:37:47.390 N NULL
000006000420 2005-09-29 11:02:23.860 N NULL
000006000421 2005-09-19 10:49:31.360 N NULL
000006000824 2005-09-19 11:15:05.970 N NULL
000006001024 2005-09-19 11:41:13.643 N NULL
000006001031 2005-09-19 11:31:46.313 N NULL
000006001069 2005-09-19 12:00:55.220 N NULL
000006001077 2005-09-19 12:09:05.487 N NULL
000006001109 2005-09-19 12:31:06.050 N NULL
000006001115 2005-09-19 12:42:52.030 N NULL
000006001127 2005-09-19 12:52:45.673 N NULL
000006001127 2005-10-17 13:33:23.093 N NULL
000006001227 2005-09-19 13:10:21.550 N NULL
000006001227 2005-09-20 12:23:56.657 N NULL
000006001241 2005-09-19 13:15:15.110 N NULL
000006001255 2005-09-19 13:34:52.423 N NULL
000006001265 2005-09-19 13:43:03.343 N NULL
000006001323 2005-09-19 14:18:28.330 N NULL
000006001335 2005-09-19 18:38:06.563 N NULL
000006001337 2005-09-19 14:29:09.220 N NULL
000006001365 2005-09-19 14:53:34.093 N NULL
000006002171 2005-09-19 15:09:35.563 N NULL
000006002173 2005-09-19 15:06:06.563 N NULL
000006004196 2005-09-19 15:30:25.580 N NULL
000006004207 2005-09-19 15:41:15.767 N NULL
000006005525 2005-09-19 15:54:17.640 N NULL
000006007596 2005-09-19 16:16:39.517 N NULL
000006007597 2005-09-19 16:43:36.563 N NULL
000006008099 2005-09-19 16:22:00.110 N NULL
000006008585 2005-09-19 16:27:13.923 N NULL
000006012010 2005-09-19 17:27:21.470 N NULL
000006012041 2005-09-19 18:13:24.110 N NULL
000006014980 2005-09-19 20:48:37.800 N NULL
000006014986 2005-09-20 18:10:54.250 N NULL
000006014987 2005-09-19 20:07:32.220 N NULL
000006032695 2005-09-20 08:49:55.877 N NULL
000006033850 2005-09-20 10:25:16.640 N NULL
000006037077 2005-09-20 11:34:26.407 N NULL
000006037077 2005-09-29 10:39:04.440 N NULL
000006037097 2005-09-20 12:08:21.703 N NULL
000006037097 2005-09-20 18:43:15.423 N NULL
000006037097 2005-09-21 08:19:38.347 N NULL
000006037125 2005-09-20 12:29:15.923 N NULL
000006037144 2005-09-20 12:57:48.923 N NULL
000006042776 2005-09-20 13:55:35.953 N NULL
000006042776 2005-09-22 12:20:13.780 N NULL
000006043898 2005-09-21 12:06:36.360 N NULL
000006043915 2005-09-20 14:36:23.237 N NULL
000006044009 2005-09-20 16:37:13.407 N NULL
000006044016 2005-09-20 16:47:33.347 N NULL
000006044017 2005-09-20 16:55:48.250 N NULL
000006044082 2005-09-20 18:31:05.360 N NULL
000006044091 2005-09-20 19:23:51.110 N NULL
000006044102 2005-09-20 19:03:16.000 N NULL
000006044776 2005-09-21 07:53:23.970 N NULL
000006044826 2005-09-21 09:10:05.720 N NULL
000006044943 2005-09-21 10:01:12.703 N NULL
000006045242 2005-09-21 10:34:14.673 N NULL
000006045273 2005-09-21 11:07:29.500 N NULL
000006045457 2005-09-21 11:58:37.580 N NULL
000006045457 2005-09-23 11:41:19.453 N NULL
000006045489 2005-09-21 12:05:42.500 N NULL
000006045508 2005-09-21 12:17:56.080 N NULL
000006045537 2005-09-21 12:39:51.220 N NULL
000006045566 2005-09-27 16:23:19.797 N NULL
000006045576 2005-09-21 13:05:18.267 N NULL
000006045604 2005-09-21 13:21:14.783 N NULL
000006045630 2005-09-21 13:38:09.750 N NULL
000006045662 2005-09-21 14:06:40.377 N NULL
000006045673 2005-09-21 14:25:43.250 N NULL
000006045693 2005-09-21 14:47:10.377 N NULL
000006045693 2005-09-27 08:54:42.343 N NULL
000006045693 2005-09-27 20:56:09.407 N NULL
000006045763 2005-09-21 15:34:48.300 N NULL
000006045763 2005-09-22 11:24:42.343 N NULL
000006045824 2005-09-21 16:09:47.407 N NULL
000006045882 2005-09-21 17:25:14.893 N NULL
000006045885 2005-09-21 17:24:50.877 N NULL
000006046491 2005-09-21 19:31:07.390 N NULL
000006046493 2005-09-21 19:41:12.610 N NULL
000006046501 2005-09-21 20:11:51.017 N NULL
000006046513 2005-09-21 21:37:13.203 N NULL
000006046760 2005-09-22 08:40:34.547 N NULL
000006048440 2005-09-27 17:34:12.533 N NULL
000006048720 2005-09-22 11:00:43.203 N NULL
000006048836 2005-09-22 11:45:43.453 N NULL
000006048875 2005-09-22 12:01:05.407 N NULL
000006048875 2005-10-05 11:55:59.940 N NULL
000006048963 2005-09-22 13:10:23.860 N NULL
000006048963 2005-09-26 11:37:51.470 N NULL
000006049983 2005-09-23 12:59:20.877 N NULL
000006051165 2005-09-22 14:25:53.423 N 2005-09-22 14:27:32.313
000006051165 2005-09-22 14:27:32.313 N NULL
000006051801 2005-09-22 14:42:28.983 N NULL
000006051886 2005-09-22 15:33:15.767 N NULL
000006051890 2005-09-22 15:37:39.877 N NULL
000006052614 2005-09-22 17:38:01.750 N NULL
000006052626 2005-09-22 17:43:30.267 N NULL
000006052627 2005-09-22 17:45:44.547 N NULL
000006053334 2005-09-23 09:14:36.233 N NULL
000006054267 2005-09-23 09:26:32.923 N NULL
000006060858 2005-09-23 10:20:58.987 N NULL
000006061943 2005-09-23 11:17:41.737 N NULL
000006064108 2005-09-23 11:04:38.640 N NULL
000006064125 2005-09-23 11:31:39.690 N NULL
000006064125 2005-09-27 12:36:02.173 N NULL
000006069119 2005-09-23 12:12:55.377 N NULL
000006069143 2005-09-23 12:28:06.813 N NULL
000006069160 2005-09-23 12:36:04.580 N NULL
000006069835 2005-09-23 13:24:22.033 N NULL
000006069911 2005-09-23 14:08:43.890 N NULL
000006069913 2005-09-23 14:10:54.780 N NULL
000006069913 2005-09-27 18:26:21.593 N NULL
000006069964 2005-09-23 15:36:41.673 N NULL
000006069985 2005-09-23 15:17:00.250 N NULL
000006069985 2005-09-25 11:32:00.097 N NULL
000006070026 2005-09-23 16:32:39.610 N NULL
000006070029 2005-09-23 16:50:40.657 N NULL
000006070128 2005-09-23 18:38:15.203 N NULL
000006070155 2005-09-23 19:32:46.690 N NULL
000006070176 2005-09-23 22:00:41.097 N NULL
000006070234 2005-09-24 09:51:07.830 N NULL
000006070234 2005-09-30 16:57:12.470 N NULL
000006070349 2005-10-03 13:00:31.250 N NULL
000006070355 2005-09-24 12:31:28.517 N NULL
000006070428 2005-09-24 14:05:28.487 N NULL
000006070428 2005-10-13 18:18:05.780 N NULL
000006070444 2005-09-24 14:29:12.750 N NULL
000006070460 2005-09-24 15:02:36.157 N NULL
000006070464 2005-09-24 15:10:23.597 N NULL
000006070481 2005-09-24 15:24:03.267 N NULL
000006070481 2005-09-30 09:48:27.533 N NULL
000006070487 2005-09-24 15:35:48.143 N NULL
000006070500 2005-09-24 15:48:50.267 N NULL
000006070603 2005-09-25 09:20:41.110 N NULL
000006070645 2005-09-25 14:03:03.000 N NULL
000006070652 2005-09-25 14:13:04.190 N NULL
000006071262 2005-09-26 09:23:20.360 N NULL
000006071283 2005-09-26 09:48:36.440 N NULL
000006072202 2005-09-26 10:44:57.890 N NULL
000006072214 2005-09-26 10:54:39.220 N NULL
000006072290 2005-09-26 11:37:55.330 N NULL
000006072379 2005-09-26 12:34:30.860 N NULL
000006072474 2005-09-26 12:58:22.267 N NULL
000006072684 2005-10-04 12:15:29.483 N NULL
000006072698 2005-09-26 13:22:16.563 N NULL
000006073117 2005-09-26 14:08:32.533 N NULL
000006073173 2005-09-26 14:47:13.733 N NULL
000006073201 2005-09-26 15:17:35.923 N NULL
000006073238 2005-09-26 15:36:35.033 N NULL
000006073256 2005-09-26 15:49:34.453 N NULL
000006073295 2005-09-26 16:37:40.800 N NULL
000006073302 2005-09-26 16:23:38.237 N NULL
000006073508 2005-09-26 17:08:23.300 N NULL
000006073511 2005-09-26 17:04:53.580 N NULL
000006073564 2005-09-26 17:57:32.157 N NULL
000006073736 2005-09-26 22:39:09.093 N NULL
000006075015 2005-09-27 09:15:23.533 N NULL
000006075071 2005-09-27 09:32:11.517 N NULL
000006075148 2005-09-27 10:09:46.220 N NULL
000006075150 2005-09-27 10:07:15.533 N NULL
000006075173 2005-09-27 10:31:46.830 N NULL
000006075214 2005-09-27 10:51:18.533 N NULL
000006075238 2005-09-27 11:05:09.640 N NULL
000006075238 2005-09-27 20:22:14.360 N NULL
000006075239 2005-09-27 11:06:41.563 N NULL
000006075262 2005-10-10 15:26:30.060 N NULL
000006075497 2005-09-27 11:48:12.907 N NULL
000006075555 2005-09-27 12:59:12.390 N NULL
000006075729 2005-09-27 13:46:30.127 N NULL
000006075781 2005-09-27 14:13:16.080 N NULL
000006075807 2005-09-27 14:24:33.907 N NULL
000006075865 2005-09-27 15:20:35.940 N NULL
000006075913 2005-09-27 15:30:01.627 N NULL
000006076128 2005-09-27 17:10:59.313 N NULL
000006076215 2005-09-27 18:06:48.750 N NULL
000006076307 2005-09-27 19:32:48.860 N NULL
000006076312 2005-09-27 19:33:25.233 N NULL
000006076322 2005-09-27 19:43:48.550 N NULL
000006076366 2005-09-27 21:25:18.063 N NULL
000006076793 2005-09-28 09:18:51.843 N NULL
000006076795 2005-09-28 09:21:34.800 N NULL
000006076795 2005-09-29 15:03:46.657 N NULL
000006076817 2005-09-28 09:51:35.610 N NULL
000006077133 2005-09-28 10:59:00.860 N NULL
000006077138 2005-09-28 11:01:53.830 N NULL
000006077153 2005-09-28 11:15:47.610 N NULL
000006077153 2005-10-07 12:21:09.627 N NULL
000006077225 2005-09-28 12:52:43.360 N NULL
000006077456 2005-09-28 13:35:53.597 N NULL
000006077524 2005-09-28 14:12:54.690 N NULL
000006077524 2005-10-10 13:04:37.967 N NULL
000006077629 2005-09-28 15:12:34.673 N NULL
000006077663 2005-09-28 15:27:27.547 N NULL
000006077936 2005-09-28 18:19:35.470 N 2005-09-28 18:22:55.390
000006077936 2005-09-28 18:22:55.390 N NULL
000006078050 2005-09-28 19:40:28.500 N NULL
000006078090 2005-09-28 20:38:04.470 N NULL
000006078405 2005-09-29 07:59:29.297 N NULL
000006078406 2005-09-29 07:57:07.143 N NULL
000006079141 2005-09-29 10:10:50.190 N NULL
000006079598 2005-09-29 10:39:19.470 N NULL
000006079643 2005-09-29 11:26:34.313 N NULL
000006079648 2005-09-29 11:29:36.940 N NULL
000006079680 2005-09-29 11:56:44.080 N NULL
000006079872 2005-09-29 14:17:44.953 N NULL
000006079922 2005-09-29 14:35:22.550 N NULL
000006079958 2005-09-29 14:53:50.343 N NULL
000006080073 2005-09-29 15:58:19.547 N NULL
000006080176 2005-09-29 17:05:27.720 N NULL
000006080260 2005-09-29 18:12:55.970 N NULL
000006080265 2005-09-29 18:18:20.877 N NULL
000006080276 2005-09-29 18:37:25.000 N NULL
000006080324 2005-09-29 19:23:08.737 N NULL
000006082319 2005-09-29 21:42:06.017 N NULL
000006082638 2005-09-30 07:45:42.890 N NULL
000006083220 2005-09-30 09:40:26.597 N NULL
000006083232 2005-09-30 10:09:29.580 N NULL
000006083320 2005-09-30 11:42:51.813 N NULL
000006083617 2005-09-30 12:01:52.610 N NULL
000006083720 2005-09-30 13:07:59.483 N NULL
000006083853 2005-09-30 13:55:20.953 N NULL
000006083874 2005-10-06 10:34:32.080 N NULL
000006083890 2005-09-30 14:24:28.703 N NULL
000006083940 2005-09-30 15:03:47.487 N NULL
000006084034 2005-09-30 15:39:27.390 N NULL
000006084090 2005-09-30 16:03:32.940 N NULL
000006084120 2005-09-30 16:21:03.923 N NULL
000006084215 2005-09-30 17:28:56.127 N NULL
000006084215 2005-10-12 12:47:10.920 N NULL
000006084304 2005-09-30 19:06:22.093 N NULL
000006084408 2005-09-30 23:04:48.470 N NULL
000006084418 2005-10-01 08:23:02.110 N NULL
000006084426 2005-10-01 09:05:12.563 N NULL
000006084429 2005-10-01 09:34:19.000 N NULL
000006084439 2005-10-01 11:08:58.940 N NULL
000006084452 2005-10-01 10:54:10.157 N NULL
000006084453 2005-10-01 11:00:28.970 N NULL
000006084499 2005-10-01 13:01:51.487 N NULL
000006084504 2005-10-01 13:13:34.233 N NULL
000006084536 2005-10-01 15:23:39.453 N NULL
000006084575 2005-10-03 00:16:21.500 N NULL
000006084582 2005-10-02 07:49:33.203 N NULL
000006084662 2005-10-02 09:58:04.017 N NULL
000006084663 2005-10-02 10:10:51.970 N NULL
000006084776 2005-10-02 11:39:02.173 N NULL
000006084799 2005-10-02 12:46:46.393 N NULL
000006084805 2005-10-02 14:52:40.597 N NULL
000006084816 2005-10-02 19:29:16.313 N NULL
000006084824 2005-10-02 21:19:38.860 N NULL
000006084837 2005-10-03 00:10:24.640 N NULL
000006085121 2005-10-03 07:30:26.377 N NULL
000006086154 2005-10-03 10:18:25.533 N NULL
000006086166 2005-10-03 10:37:42.093 N NULL
000006086166 2005-10-19 13:10:32.093 N NULL
000006086215 2005-10-03 11:20:52.157 N NULL
000006086230 2005-10-03 11:31:44.453 N NULL
000006086232 2005-10-03 11:33:27.440 N NULL
000006086290 2005-10-03 12:19:25.143 N NULL
000006086296 2005-10-03 12:19:19.470 N NULL
000006086384 2005-10-03 13:56:10.500 N NULL
000006086411 2005-10-03 14:27:42.203 N NULL
000006086445 2005-10-03 15:03:28.050 N NULL
000006086641 2005-10-03 17:08:00.063 N NULL
000006086660 2005-10-03 17:13:29.640 N NULL
000006086697 2005-10-03 17:42:18.033 N NULL
000006086745 2005-10-03 19:14:17.733 N NULL
000006087077 2005-10-04 08:03:18.300 N NULL
000006088431 2005-10-04 11:07:38.550 N NULL
000006089747 2005-10-04 11:28:48.673 N NULL
000006089750 2005-10-04 11:26:13.813 N NULL
000006089789 2005-10-04 11:58:21.250 N NULL
000006089841 2005-10-04 13:15:53.673 N NULL
000006089852 2005-10-06 10:58:03.673 N NULL
000006089857 2005-10-04 13:29:24.300 N NULL
000006090923 2005-10-04 15:22:08.593 N NULL
000006093027 2005-10-04 17:18:11.970 N NULL
000006096450 2005-10-04 18:16:41.063 N NULL
000006097759 2005-10-04 19:20:41.657 N NULL
000006117339 2005-10-05 09:48:37.360 N NULL
000006117342 2005-10-05 09:53:25.470 N NULL
000006119813 2005-10-05 10:30:00.487 N NULL
000006119818 2005-10-05 10:31:12.627 N NULL
000006120763 2005-10-05 10:44:00.143 N NULL
000006122577 2005-10-05 11:04:43.127 N NULL
000006123798 2005-10-05 11:26:34.190 N NULL
000006124321 2005-10-05 11:33:36.893 N NULL
000006127285 2005-10-05 15:47:48.237 N NULL
000006127291 2005-10-06 11:52:33.360 N NULL
000006127304 2005-10-05 12:43:05.860 N NULL
000006129560 2005-10-05 13:28:15.157 N NULL
000006129566 2005-10-05 13:39:24.813 N NULL
000006134237 2005-10-05 17:58:26.783 N NULL
000006134258 2005-10-05 18:37:01.250 N NULL
000006134260 2005-10-05 18:44:01.033 N NULL
000006134287 2005-10-05 19:17:44.940 N NULL
000006134316 2005-10-05 19:43:39.923 N NULL
000006134322 2005-10-05 19:52:49.563 N NULL
000006134326 2005-10-05 19:58:44.673 N NULL
000006137344 2005-10-06 09:03:11.220 N NULL
000006137344 2005-10-14 16:50:36.890 N NULL
000006139676 2005-10-06 10:18:42.533 N NULL
000006139707 2005-10-06 10:51:16.563 N NULL
000006139742 2005-10-06 11:22:58.190 N NULL
000006139821 2005-10-06 12:01:06.283 N NULL
000006139827 2005-10-06 12:00:48.157 N NULL
000006139838 2005-10-06 12:11:23.767 N NULL
000006139876 2005-10-06 13:11:18.533 N NULL
000006142099 2005-10-06 13:39:48.550 N NULL
000006146231 2005-10-06 16:16:47.830 N NULL
000006147229 2005-10-06 16:34:27.000 N NULL
000006147401 2005-10-06 18:10:57.953 N NULL
000006151523 2005-10-07 09:30:42.203 N NULL
000006152875 2005-10-14 13:57:00.140 N NULL
000006152878 2005-10-07 12:44:17.673 N NULL
000006152882 2005-10-07 10:06:39.343 N NULL
000006155846 2005-10-07 11:03:26.767 N NULL
000006156846 2005-10-07 11:02:56.487 N NULL
000006157226 2005-10-07 11:07:12.280 N NULL
000006157232 2005-10-07 11:58:08.360 N NULL
000006157232 2005-10-17 09:00:45.687 N NULL
000006157234 2005-10-07 11:40:46.127 N NULL
000006157238 2005-10-07 12:02:00.643 N NULL
000006157274 2005-10-12 14:28:35.170 N NULL
000006157535 2005-10-07 12:56:48.063 N NULL
000006157560 2005-10-07 13:20:42.750 N NULL
000006158147 2005-10-07 14:26:41.190 N NULL
000006159050 2005-10-07 14:40:09.157 N NULL
000006160487 2005-10-07 14:49:51.080 N 2005-10-07 14:57:54.953
000006160487 2005-10-07 14:57:54.953 N NULL
000006160488 2005-10-07 14:49:31.783 N NULL
000006161657 2005-10-07 17:08:59.673 N NULL
000006161673 2005-10-07 16:54:02.673 N NULL
000006161685 2005-10-07 17:11:17.017 N NULL
000006161727 2005-10-07 17:24:08.173 N NULL
000006161824 2005-10-07 19:09:28.300 N NULL
000006161830 2005-10-07 19:20:04.690 N NULL
000006161848 2005-10-07 19:51:12.690 N NULL
000006161848 2005-10-13 20:33:38.903 N NULL
000006161948 2005-10-08 11:25:06.750 N NULL
000006161958 2005-10-08 11:59:27.203 N NULL
000006161970 2005-10-08 12:41:03.797 N NULL
000006162050 2005-10-08 15:35:13.283 N NULL
000006162054 2005-10-08 15:48:31.110 N NULL
000006162099 2005-10-09 11:14:21.390 N NULL
000006162100 2005-10-09 11:42:13.340 N NULL
000006162104 2005-10-18 14:04:16.187 N NULL
000006162132 2005-10-09 14:15:40.483 N NULL
000006162138 2005-10-09 15:16:33.250 N NULL
000006162139 2005-10-09 15:32:33.797 N NULL
000006162142 2005-10-09 15:41:41.387 N NULL
000006162145 2005-10-09 17:26:13.043 N NULL
000006163281 2005-10-10 09:36:11.653 N NULL
000006163294 2005-10-10 10:01:08.560 N NULL
000006163298 2005-10-10 10:08:01.607 N NULL
000006163329 2005-10-10 10:46:38.030 N NULL
000006163338 2005-10-10 10:53:37.577 N NULL
000006163354 2005-10-10 11:01:48.200 N NULL
000006164534 2005-10-10 11:43:34.467 N NULL
000006164616 2005-10-10 11:53:57.717 N NULL
000006164632 2005-10-10 12:12:13.357 N NULL
000006164745 2005-10-10 12:50:20.560 N NULL
000006164762 2005-10-11 20:19:38.357 N NULL
000006164772 2005-10-10 13:21:18.827 N NULL
000006166363 2005-10-10 13:30:37.013 N NULL
000006166380 2005-10-10 13:58:41.107 N NULL
000006166387 2005-10-10 14:05:39.827 N NULL
000006166390 2005-10-10 14:10:13.390 N NULL
000006166662 2005-10-10 16:12:39.437 N NULL
000006166676 2005-10-10 16:18:16.373 N NULL
000006166725 2005-10-10 16:51:00.920 N NULL
000006166742 2005-10-10 16:58:56.513 N NULL
000006166785 2005-10-10 17:42:20.077 N NULL
000006166797 2005-10-10 17:51:48.343 N NULL
000006166799 2005-10-10 17:52:45.857 N NULL
000006166806 2005-10-10 17:54:18.217 N NULL
000006166810 2005-10-10 18:10:17.500 N NULL
000006166812 2005-10-10 18:08:57.700 N NULL
000006166813 2005-10-10 18:05:56.513 N NULL
000006166822 2005-10-10 18:17:10.513 N NULL
000006166843 2005-10-10 19:03:46.780 N NULL
000006166851 2005-10-10 19:19:55.653 N NULL
000006166882 2005-10-10 20:24:02.530 N NULL
000006167379 2005-10-11 09:41:00.623 N NULL
000006167899 2005-10-11 10:01:27.373 N NULL
000006167906 2005-10-12 16:46:12.967 N NULL
000006167908 2005-10-11 10:16:20.247 N NULL
000006168111 2005-10-11 10:53:19.797 N NULL
000006168226 2005-10-11 12:28:26.093 N NULL
000006168303 2005-10-11 13:12:07.750 N NULL
000006168317 2005-10-11 13:29:20.373 N NULL
000006168317 2005-10-15 12:19:09.403 N NULL
000006168438 2005-10-11 14:06:23.077 N NULL
000006168491 2005-10-11 14:28:28.530 N NULL
000006168507 2005-10-11 14:39:09.873 N NULL
000006168531 2005-10-11 14:49:18.637 N NULL
000006168534 2005-10-11 14:50:05.293 N NULL
000006168549 2005-10-11 14:55:23.437 N NULL
000006168564 2005-10-11 15:02:10.000 N NULL
000006168785 2005-10-11 17:17:03.437 N NULL
000006168808 2005-10-11 17:36:53.700 N NULL
000006168817 2005-10-11 17:44:45.280 N NULL
000006168822 2005-10-11 17:50:08.530 N NULL
000006168875 2005-10-11 19:06:03.997 N NULL
000006168879 2005-10-11 19:16:24.153 N NULL
000006168881 2005-10-11 19:20:22.653 N NULL
000006170157 2005-10-18 09:37:15.140 N NULL
000006170348 2005-10-12 11:23:57.577 N NULL
000006170542 2005-10-12 11:56:24.827 N NULL
000006170553 2005-10-14 14:18:15.420 N NULL
000006170589 2005-10-12 12:35:31.873 N NULL
000006170606 2005-10-12 12:53:15.310 N NULL
000006170644 2005-10-12 13:25:56.403 N NULL
000006170646 2005-10-12 15:16:13.077 N NULL
000006170668 2005-10-12 13:55:45.373 N NULL
000006170752 2005-10-12 14:47:47.577 N NULL
000006170784 2005-10-20 14:35:21.560 N NULL
000006170889 2005-10-12 16:20:44.217 N NULL
000006170890 2005-10-12 16:20:56.437 N NULL
000006170925 2005-10-12 16:49:35.827 N NULL
000006170961 2005-10-12 17:15:06.717 N NULL
000006170965 2005-10-12 17:15:58.937 N NULL
000006170989 2005-10-12 17:34:10.420 N NULL
000006171003 2005-10-12 17:45:21.263 N NULL
000006171019 2005-10-12 18:04:58.217 N NULL
000006171032 2005-10-12 19:06:25.607 N NULL
000006171037 2005-10-12 19:30:41.233 N NULL
000006171269 2005-10-13 08:37:32.060 N NULL
000006171307 2005-10-13 09:51:29.547 N NULL
000006171602 2005-10-14 12:38:01.763 N NULL
000006171871 2005-10-13 12:36:53.967 N NULL
000006171875 2005-10-14 09:27:03.123 N NULL
000006171937 2005-10-13 12:57:29.297 N NULL
000006171941 2005-10-13 13:02:04.280 N NULL
000006171948 2005-10-13 13:08:33.013 N NULL
000006171964 2005-10-13 13:52:31.310 N NULL
000006171971 2005-10-13 13:29:28.077 N NULL
000006171974 2005-10-13 13:32:55.890 N NULL
000006171999 2005-10-13 13:43:49.297 N NULL
000006172062 2005-10-13 14:07:12.217 N NULL
000006172140 2005-10-13 15:03:43.153 N NULL
000006172147 2005-10-13 15:04:59.810 N NULL
000006172200 2005-10-13 15:40:26.390 N NULL
000006172423 2005-10-13 19:25:01.950 N NULL
000006172429 2005-10-13 19:36:11.700 N 2005-10-13 19:36:48.357
000006172429 2005-10-13 19:36:48.357 N NULL
000006172435 2005-10-13 20:15:04.497 N NULL
000006172441 2005-10-13 20:22:39.233 N NULL
000006172618 2005-10-14 08:29:16.077 N NULL
000006172953 2005-10-14 10:03:39.060 N NULL
000006172957 2005-10-14 09:44:33.890 N NULL
000006172958 2005-10-14 09:49:29.530 N NULL
000006172998 2005-10-14 10:44:36.810 N NULL
000006173016 2005-10-14 10:57:04.390 N NULL
000006173241 2005-10-14 16:32:47.077 N NULL
000006173253 2005-10-18 14:14:39.263 N NULL
000006173272 2005-10-14 11:36:17.683 N NULL
000006173318 2005-10-14 11:59:37.640 N NULL
000006173329 2005-10-14 12:08:48.217 N NULL
000006173334 2005-10-14 12:17:55.700 N NULL
000006173606 2005-10-14 13:35:41.140 N NULL
000006173692 2005-10-14 14:18:15.513 N NULL
000006173767 2005-10-14 15:16:19.733 N NULL
000006173850 2005-10-14 15:59:42.700 N NULL
000006173938 2005-10-14 16:51:25.717 N NULL
000006174083 2005-10-15 09:06:52.843 N NULL
000006174084 2005-10-15 09:38:00.263 N NULL
000006174109 2005-10-15 10:47:12.500 N NULL
000006174138 2005-10-15 11:48:44.467 N NULL
000006174150 2005-10-15 12:03:26.357 N NULL
000006174152 2005-10-15 12:14:18.920 N NULL
000006174159 2005-10-15 12:30:06.593 N NULL
000006174171 2005-10-15 13:56:14.047 N NULL
000006174172 2005-10-15 13:26:03.077 N NULL
000006174189 2005-10-15 15:21:34.153 N NULL
000006174202 2005-10-15 16:22:40.547 N NULL
000006174206 2005-10-15 16:43:29.263 N NULL
000006174243 2005-10-16 12:28:05.560 N NULL
000006174248 2005-10-16 09:44:18.780 N NULL
000006174249 2005-10-16 10:04:18.560 N NULL
000006174250 2005-10-16 10:57:48.217 N NULL
000006174254 2005-10-16 14:03:23.390 N NULL
000006174255 2005-10-16 14:22:38.327 N NULL
000006174264 2005-10-16 15:47:25.107 N NULL
000006174303 2005-10-16 18:59:17.390 N NULL
000006174682 2005-10-17 07:59:10.043 N NULL
000006175328 2005-10-19 15:02:28.077 N NULL
000006175352 2005-10-17 09:03:33.373 N NULL
000006175382 2005-10-17 09:57:21.903 N NULL
000006175731 2005-10-17 11:11:08.717 N NULL
000006175769 2005-10-17 11:35:07.187 N NULL
000006175808 2005-10-17 13:37:40.793 N NULL
000006175889 2005-10-17 16:13:27.060 N NULL
000006175934 2005-10-17 13:59:43.763 N NULL
000006175982 2005-10-17 14:34:14.983 N NULL
000006176012 2005-10-17 14:59:46.247 N NULL
000006176205 2005-10-17 17:33:52.280 N NULL
000006176222 2005-10-17 18:06:03.950 N NULL
000006176291 2005-10-17 20:08:29.170 N NULL
000006176639 2005-10-18 08:08:42.093 N NULL
000006176866 2005-10-18 08:50:33.873 N NULL
000006176927 2005-10-18 09:55:51.450 N NULL
000006176945 2005-10-18 10:10:32.593 N NULL
000006176960 2005-10-18 10:35:58.937 N NULL
000006176961 2005-10-18 10:30:09.200 N NULL
000006177071 2005-10-19 07:41:02.343 N NULL
000006177150 2005-10-18 12:59:52.340 N NULL
000006177157 2005-10-18 13:11:12.717 N NULL
000006178479 2005-10-18 14:02:31.233 N NULL
000006178702 2005-10-18 16:37:18.030 N NULL
000006178758 2005-10-18 17:37:52.467 N NULL
000006178850 2005-10-18 18:41:40.060 N NULL
000006178924 2005-10-18 20:33:06.013 N NULL
000006179784 2005-10-19 09:20:13.733 N NULL
000006179785 2005-10-19 09:23:08.093 N NULL
000006179810 2005-10-19 10:27:46.873 N NULL
000006179823 2005-10-19 10:38:21.750 N NULL
000006179825 2005-10-19 12:38:26.933 N NULL
000006179830 2005-10-19 10:45:45.170 N NULL
000006179867 2005-10-19 11:20:11.810 N NULL
000006179872 2005-10-19 11:25:07.170 N NULL
000006179883 2005-10-19 11:46:47.810 N NULL
000006180133 2005-10-19 12:56:54.170 N NULL
000006180152 2005-10-19 13:12:27.653 N NULL
000006180183 2005-10-19 13:27:39.390 N NULL
000006180216 2005-10-19 14:01:55.547 N NULL
000006180250 2005-10-19 14:35:43.763 N NULL
000006180278 2005-10-19 15:04:57.420 N NULL
000006180353 2005-10-19 15:37:02.843 N NULL
000006181374 2005-10-19 17:06:00.593 N NULL
000006182683 2005-10-19 18:27:36.000 N NULL
000006182719 2005-10-19 19:26:16.653 N NULL
000006182721 2005-10-19 19:38:30.107 N NULL
000006183447 2005-10-20 08:57:27.687 N NULL
000006183574 2005-10-20 09:33:04.077 N NULL
000006183576 2005-10-20 09:25:33.030 N NULL
000006183586 2005-10-20 09:43:26.560 N NULL
000006183772 2005-10-20 10:23:26.810 N NULL
000006184851 2005-10-20 10:37:02.310 N NULL
000006185374 2005-10-20 11:07:43.950 N NULL
000006185448 2005-10-20 11:40:41.060 N NULL
000006186091 2005-10-20 11:48:00.140 N NULL
000006186122 2005-10-20 12:16:48.857 N NULL
000006186873 2005-10-20 13:12:27.750 N NULL
000006187684 2005-10-20 14:27:12.827 N NULL
000006187694 2005-10-20 14:35:56.000 N NULL
000006187771 2005-10-20 15:47:17.890 N NULL
000006187820 2005-10-20 16:13:28.013 N NULL
000006187852 2005-10-20 16:38:53.200 N NULL
000006187864 2005-10-20 16:59:24.717 N NULL
5987017 2005-09-20 20:14:59.597 N NULL
5987299 2005-09-25 16:57:28.500 N NULL
5987364 2005-10-03 10:33:36.483 N NULL
5987588 2005-09-30 12:24:57.690 N NULL
5987595 2005-10-20 09:50:22.607 N NULL
5987843 2005-10-13 13:51:14.183 N NULL
5988787 2005-09-21 11:59:47.097 N NULL
5988979 2005-10-06 19:09:25.000 N NULL
5989204 2005-09-29 16:42:44.593 N NULL
5990814 2005-09-26 17:14:43.893 N NULL
5991236 2005-10-17 09:33:24.060 N NULL
5992802 2005-10-19 13:14:16.107 N NULL
5993034 2005-10-01 09:34:08.657 N NULL
5996079 2005-10-04 13:55:31.953 N NULL
5996321 2005-10-17 15:31:20.530 N NULL
5996653 2005-10-20 08:22:00.967 N NULL
5997513 2005-09-22 10:25:50.440 N NULL
5997730 2005-10-03 17:44:33.780 N NULL
5997999 2005-09-23 18:28:43.267 N NULL
6001501 2005-10-03 11:24:53.190 N NULL
6003112 2005-09-19 20:17:49.237 N NULL
6003672 2005-09-25 17:21:45.940 N NULL
6004069 2005-09-23 10:46:43.250 N NULL
6004287 2005-10-11 13:51:06.700 N NULL
6007760 2005-10-16 06:22:09.327 N NULL
6008232 2005-10-01 13:47:03.750 N NULL
6008545 2005-09-19 16:55:55.877 N NULL
6008645 2005-09-20 15:36:27.233 N NULL
6008901 2005-10-19 12:25:41.297 N NULL
6008924 2005-10-01 13:42:03.627 N NULL
6009382 2005-09-23 12:35:15.673 N NULL
6009475 2005-09-27 11:54:15.097 N NULL
6009755 2005-10-17 15:17:30.890 N NULL
6009788 2005-10-08 12:12:06.720 N NULL
6009816 2005-09-22 15:27:29.250 N NULL
6009889 2005-09-26 16:48:23.157 N NULL
6010033 2005-10-19 13:48:10.153 N NULL
6010239 2005-09-29 11:34:10.783 N NULL
6010279 2005-10-14 10:14:36.293 N NULL
6010817 2005-09-27 09:58:26.157 N NULL
6011098 2005-09-29 14:38:41.267 N NULL
6011232 2005-10-07 18:13:38.097 N NULL
6012074 2005-10-16 18:34:24.077 N NULL
6012132 2005-10-16 18:15:56.390 N NULL
6013260 2005-10-19 10:58:29.390 N NULL
6014101 2005-10-10 12:02:22.780 N NULL
6014335 2005-10-03 12:35:35.533 N NULL
6015029 2005-09-21 12:38:05.440 N NULL
6015029 2005-09-22 10:50:17.063 N NULL
6016517 2005-10-05 14:27:07.440 N NULL
6017632 2005-09-27 13:03:06.643 N NULL
6018317 2005-10-15 19:00:39.513 N NULL
6020390 2005-09-20 18:59:33.657 N NULL
6020512 2005-09-23 17:25:25.377 N NULL
6020512 2005-09-27 11:33:56.050 N NULL
6020826 2005-10-12 22:52:26.560 N NULL
6021239 2005-09-22 11:08:42.267 N NULL
6021749 2005-09-22 11:08:06.657 N NULL
6021873 2005-09-29 11:26:58.563 N NULL
6021874 2005-09-29 11:32:03.000 N NULL
6021970 2005-09-20 17:05:41.220 N NULL
6021978 2005-10-07 12:12:46.347 N NULL
6022537 2005-10-02 01:24:04.550 N NULL
6022630 2005-10-12 18:17:47.153 N NULL
6022765 2005-09-26 16:49:43.877 N NULL
6022808 2005-10-04 13:37:44.440 N NULL
6023070 2005-10-07 12:34:59.923 N NULL
6023787 2005-10-04 13:54:06.203 N NULL
6023949 2005-10-13 13:08:06.810 N NULL
6024200 2005-09-23 19:52:43.470 N NULL
6024805 2005-10-18 13:20:30.890 N NULL
6025439 2005-10-20 15:33:49.297 N NULL
6026383 2005-10-10 12:40:11.903 N NULL
6026811 2005-10-10 10:05:42.000 N NULL
6027207 2005-10-10 14:13:39.403 N NULL
6027400 2005-10-12 20:51:05.967 N NULL
6027610 2005-10-17 14:33:25.403 N NULL
6027973 2005-10-05 11:53:22.000 N NULL
6028560 2005-10-10 15:18:39.310 N NULL
6028948 2005-10-12 17:34:40.997 N NULL
6029021 2005-10-06 10:11:34.783 N NULL
6029687 2005-09-30 02:31:39.907 N NULL
6029687 2005-09-30 14:57:27.547 N NULL
6029794 2005-09-30 07:27:28.233 N NULL
6029920 2005-10-05 15:00:43.190 N NULL
6029947 2005-10-17 16:50:51.137 N NULL
6029951 2005-10-11 11:40:14.107 N NULL
6030506 2005-10-10 09:09:19.733 N NULL
6030613 2005-10-20 11:10:35.327 N NULL
6030641 2005-10-02 14:09:51.360 N NULL
6031016 2005-10-14 13:23:36.653 N NULL
6031028 2005-10-20 12:00:45.763 N NULL
6031271 2005-09-29 16:51:52.487 N NULL
6032999 2005-09-23 08:43:01.923 N NULL
6034208 2005-09-26 16:27:40.783 N NULL
6034224 2005-10-16 09:14:10.327 N NULL
6034331 2005-10-07 11:17:31.470 N NULL
6034380 2005-10-06 16:05:13.297 N NULL
6034781 2005-10-19 11:49:55.747 N NULL
6035357 2005-10-04 15:09:54.330 N NULL
6035642 2005-10-10 16:56:56.780 N NULL
6035644 2005-10-04 10:46:13.953 N NULL
6035654 2005-10-07 11:57:13.487 N NULL
6035986 2005-09-22 10:41:19.173 N NULL
6036579 2005-09-26 11:33:03.627 N NULL
6036627 2005-10-10 14:02:31.750 N NULL
6038182 2005-10-13 13:30:01.013 N NULL
6038899 2005-10-20 17:57:43.403 N NULL
6040526 2005-10-04 13:29:32.783 N NULL
6040768 2005-09-22 10:13:20.423 N NULL
6040856 2005-09-28 11:17:23.907 N NULL
6040886 2005-09-27 11:53:55.140 N NULL
6041025 2005-10-19 12:51:33.340 N NULL
6041387 2005-09-27 17:38:49.563 N NULL
6041994 2005-10-17 17:07:26.403 N NULL
6042920 2005-10-06 15:25:42.860 N NULL
6042970 2005-09-27 14:51:03.580 N NULL
6046977 2005-09-30 11:30:19.830 N NULL
6047278 2005-10-06 13:52:38.220 N NULL
6047390 2005-09-26 16:12:07.640 N NULL
6047562 2005-10-01 20:49:14.970 N NULL
6047584 2005-10-20 08:21:56.093 N NULL
6048107 2005-10-18 16:04:03.390 N NULL
6048159 2005-09-26 13:00:46.283 N NULL
6048213 2005-09-25 12:24:54.017 N NULL
6048229 2005-10-06 12:08:07.750 N NULL
6048388 2005-10-03 13:00:33.830 N NULL
6052226 2005-09-26 17:01:16.517 N NULL
6053544 2005-10-17 10:29:29.763 N NULL
6057932 2005-09-26 16:22:25.627 N NULL
6064376 2005-10-19 14:42:35.857 N NULL
6064481 2005-10-01 11:59:34.233 N NULL
6068425 2005-09-30 15:11:36.080 N NULL
6068877 2005-10-17 10:35:23.750 N NULL

 

[Jeet2004]

sorry about such a big dump . I guess i am kind of desperate so got selfish without thinking of others.

Sorry about that.

even for contract numbers which are same if you check row 7,8, or 15, 16 they are same contract numbers but still

 

[vongrunt]

OK. Now we have a lot of data to play with ... so post query that doesn't work for you.

------
"There's a man... He's bald and wears a short-sleeved shirt, and somehow he's very important to me. I think his name is Homer."
(Jack O'Neill, Stargate)

 

[Jeet2004]

select t1.[Contract#]
, t1.[Date]
, case when dateadd(day,5,t1.[Date])
<= t2.[Date]
then 'Y' else 'N'
end as [DateDiff=>5days]
from daTable as t1
left outer
join daTable as t2
on t1.[Contract#] = t2.[Contract#]
and t2.[Date]
= ( select min([Date])
from daTable
where [Date] > t1.[Date] )


Thanks for your help

 

[vongrunt]

Looks like last subquery is only partially correlated. Try this:

...
     = ( select min([Date])
           from daTable
          where [Date] > t1.[Date] 
		[b]and [Contract#]=t1.[Contract#][/b])

------
"There's a man... He's bald and wears a short-sleeved shirt, and somehow he's very important to me. I think his name is Homer."
(Jack O'Neill, Stargate)

 

[r937]

yup, that'd explain it

ah, the benefits of extra eyes



r937.com | rudy.ca

 

[Jeet2004]

It Works!!!

thanks guys
I really appreciate all you help.