Re: Difficult query problem

I had solved this last night via some aggregate queries and VB code. I just got the first 2 via SQL, but the 3rd one is left.

Thanks

DFS wrote:
> Tough one here, I think. The following data set is building
> inspection visits. It consists of multiple visits (2+) made to the
> same building on the same day.
>
> There are 3 "conditions" I want to reveal using only SQL statements.
>
> 1) visits made by the same employee, for different visit codes (eg
> records 1 and 2)
> 2) visits made by different employees, for the same visit codes (eg
> records 7 and 8)
> 3) visits made by the different employees, for different visit codes
> (eg records 36 and 37)
>
>
> Here's the table
> =====================================
> CREATE TABLE VISITS
> (
> VISITID NUMBER(3,0) NOT NULL ,
> BLDGCODE VARCHAR2(10) NOT NULL ,
> VISITDATE DATE NOT NULL ,
> EMPID NUMBER(3,0) NOT NULL ,
> VISITCODE VARCHAR2(5) NOT NULL
> );
>
> ALTER TABLE VISITS
> ADD CONSTRAINT PK_VISITS PRIMARY KEY
> (
> VISITID
> );
>
> CREATE UNIQUE INDEX UIDX_VISITS ON VISITS
> (
> BLDGCODE,
> VISITDATE,
> EMPID,
> VISITCODE
> );
> =====================================
>
> And here's the data:
> =====================================
> VISITID,BLDGCODE,VISITDATE,EMPID,VISITCODE
> 1, BLDG1, 10/18/2005, 128, V6
> 2, BLDG1, 10/18/2005, 128, V9
> 3, BLDG2, 1/24/2006, 128, V8
> 4, BLDG2, 1/24/2006, 165, V22
> 5, BLDG3, 2/15/2006, 13, V14
> 6, BLDG3, 2/15/2006, 143, V8
> 7, BLDG4, 8/1/2006, 319, V9
> 8, BLDG4, 8/1/2006, 390, V9
> 9, BLDG4, 8/2/2006, 319, V9
> 10, BLDG4, 8/2/2006, 390, V9
> 11, BLDG4, 8/2/2006, 390, V8
> 12, BLDG5, 8/28/2006, 318, V11
> 13, BLDG5, 8/28/2006, 376, V11
> 14, BLDG5, 8/29/2006, 318, V11
> 15, BLDG5, 8/29/2006, 334, V11
> 16, BLDG5, 8/29/2006, 376, V11
> 17, BLDG5, 8/30/2006, 318, V11
> 18, BLDG5, 8/30/2006, 376, V11
> 19, BLDG5, 8/30/2006, 334, V11
> 20, BLDG5, 8/31/2006, 318, V11
> 21, BLDG5, 8/31/2006, 376, V11
> 22, BLDG5, 8/31/2006, 334, V11
> 23, BLDG6, 10/11/2005, 323, V19
> 24, BLDG6, 10/11/2005, 323, V27
> 25, BLDG6, 11/8/2005, 323, V8
> 26, BLDG6, 11/8/2005, 323, V27
> 27, BLDG7, 10/18/2005, 323, V3
> 28, BLDG7, 10/18/2005, 323, V27
> 29, BLDG7, 11/14/2005, 14, V3
> 30, BLDG7, 11/14/2005, 323, V3
> 31, BLDG7, 11/14/2005, 143, V3
> 32, BLDG7, 12/15/2005, 143, V3
> 33, BLDG7, 12/15/2005, 323, V3
> 34, BLDG8, 3/8/2006, 15, V23
> 35, BLDG8, 3/8/2006, 120, V23
> 36, BLDG9, 5/22/2006, 25, V2
> 37, BLDG9, 5/22/2006, 391, V14
> 38, BLDG10, 11/3/2005, 310, V6
> 39, BLDG10, 11/3/2005, 310, V8
> 40, BLDG10, 3/15/2006, 139, V28
> 41, BLDG10, 3/15/2006, 310, V28
> 42, BLDG10, 3/16/2006, 139, V28
> 43, BLDG10, 3/16/2006, 310, V28
> 44, BLDG11, 11/3/2005, 323, V22
> 45, BLDG11, 11/3/2005, 323, V27
> 46, BLDG12, 4/18/2006, 71, V2
> 47, BLDG12, 4/18/2006, 337, V13
> 48, BLDG12, 4/19/2006, 71, V2
> 49, BLDG12, 4/19/2006, 337, V13
> 50, BLDG13, 10/3/2005, 142, V22
> 51, BLDG13, 10/3/2005, 142, V27
> 52, BLDG14, 5/23/2006, 32, V23
> 53, BLDG14, 5/23/2006, 139, V23
> 54, BLDG14, 5/24/2006, 32, V23
> 55, BLDG14, 5/24/2006, 139, V23
> 56, BLDG15, 5/30/2006, 141, V17
> 57, BLDG15, 5/30/2006, 141, V22
> 58, BLDG16, 6/1/2006, 71, V18
> 59, BLDG16, 6/1/2006, 336, V18
> 60, BLDG16, 6/1/2006, 123, V18
> 61, BLDG17, 2/21/2006, 34, V8
> 62, BLDG17, 2/21/2006, 34, V19
> 63, BLDG18, 12/14/2005, 141, V7
> 64, BLDG18, 12/14/2005, 141, V17
> 65, BLDG19, 10/18/2005, 320, V14
> 66, BLDG19, 10/18/2005, 320, V16
> 67, BLDG20, 3/6/2006, 141, V8
> 68, BLDG20, 3/6/2006, 141, V22
> 69, BLDG21, 10/11/2005, 324, V6
> 70, BLDG21, 10/11/2005, 324, V7
> 71, BLDG22, 7/10/2006, 38, V23
> 72, BLDG22, 7/10/2006, 252, V11
> 73, BLDG22, 7/11/2006, 38, V23
> 74, BLDG22, 7/11/2006, 252, V11
> 75, BLDG22, 7/11/2006, 142, V22
> 76, BLDG23, 11/10/2005, 308, V7
> 77, BLDG23, 11/10/2005, 308, V8
> 78, BLDG23, 5/11/2006, 308, V8
> 79, BLDG23, 5/11/2006, 391, V2
> 80, BLDG24, 3/23/2006, 143, V24
> 81, BLDG24, 3/23/2006, 155, V2
> 82, BLDG24, 3/24/2006, 143, V24
> 83, BLDG24, 3/24/2006, 155, V25
> 84, BLDG25, 10/3/2005, 31, V14
> 85, BLDG25, 10/3/2005, 31, V19
> 86, BLDG26, 2/20/2006, 31, V14
> 87, BLDG26, 2/20/2006, 31, V22
> 88, BLDG27, 2/15/2006, 13, V14
> 89, BLDG27, 2/15/2006, 143, V8
> 90, BLDG28, 10/12/2005, 141, V8
> 91, BLDG28, 10/12/2005, 141, V17
> 92, BLDG29, 10/4/2005, 32, V22
> 93, BLDG29, 10/4/2005, 310, V2
> 94, BLDG30, 9/12/2005, 53, V23
> 95, BLDG30, 9/12/2005, 123, V21
> 96, BLDG30, 9/12/2005, 141, V23
> 97, BLDG30, 9/13/2005, 53, V23
> 98, BLDG30, 9/13/2005, 141, V23
> 99, BLDG30, 9/13/2005, 123, V21
> 100, BLDG30, 9/14/2005, 53, V23
> 101, BLDG30, 9/14/2005, 141, V23
> 102, BLDG30, 9/14/2005, 123, V21
> 103, BLDG31, 2/14/2006, 13, V14
> 104, BLDG31, 2/14/2006, 143, V8
> 105, BLDG32, 11/1/2005, 320, V3
> 106, BLDG32, 11/1/2005, 320, V27
> 107, BLDG33, 11/3/2005, 34, V7
> 108, BLDG33, 11/3/2005, 34, V19
> 109, BLDG34, 7/10/2006, 37, V23
> 110, BLDG34, 7/10/2006, 62, V23
> 111, BLDG34, 7/11/2006, 37, V23
> 112, BLDG34, 7/11/2006, 62, V23
> 113, BLDG34, 7/12/2006, 37, V23
> 114, BLDG34, 7/12/2006, 62, V23
> 115, BLDG35, 11/21/2005, 78, V27
> 116, BLDG35, 11/21/2005, 334, V8
> 117, BLDG36, 7/10/2006, 358, V1
> 118, BLDG36, 7/10/2006, 358, V8
> 119, BLDG37, 8/14/2006, 50, V14
> 120, BLDG37, 8/14/2006, 71, V11
> 121, BLDG37, 8/15/2006, 50, V14
> 122, BLDG37, 8/15/2006, 71, V11
> 123, BLDG38, 9/13/2005, 130, V6
> 124, BLDG38, 9/13/2005, 130, V8
> 125, BLDG39, 2/22/2006, 34, V8
> 126, BLDG39, 2/22/2006, 34, V14
> 127, BLDG40, 2/14/2006, 13, V14
> 128, BLDG40, 2/14/2006, 143, V8
> 129, BLDG41, 5/22/2006, 252, V17
> 130, BLDG41, 5/22/2006, 326, V17
> 131, BLDG41, 5/23/2006, 252, V17
> 132, BLDG41, 5/23/2006, 326, V17
> 133, BLDG42, 7/10/2006, 309, V2
> 134, BLDG42, 7/10/2006, 318, V23
> 135, BLDG42, 7/11/2006, 309, V2
> 136, BLDG42, 7/11/2006, 318, V23
> 137, BLDG42, 7/12/2006, 309, V2
> 138, BLDG42, 7/12/2006, 318, V23
> 139, BLDG43, 10/18/2005, 206, V8
> 140, BLDG43, 10/18/2005, 206, V14
> 141, BLDG44, 3/9/2006, 142, V24
> 142, BLDG44, 3/9/2006, 233, V23
> 143, BLDG44, 3/9/2006, 319, V24
> 144, BLDG44, 3/10/2006, 142, V24
> 145, BLDG44, 3/10/2006, 319, V24
> 146, BLDG44, 3/10/2006, 233, V23
> 147, BLDG45, 9/15/2005, 128, V6
> 148, BLDG45, 9/15/2005, 128, V9
> 149, BLDG46, 5/24/2006, 25, V2
> 150, BLDG46, 5/24/2006, 391, V8
> 151, BLDG47, 1/17/2006, 321, V6
> 152, BLDG47, 1/17/2006, 321, V22
> 153, BLDG48, 7/13/2006, 38, V18
> 154, BLDG48, 7/13/2006, 318, V11
> 155, BLDG49, 7/12/2006, 142, V23
> 156, BLDG49, 7/12/2006, 263, V23
> 157, BLDG50, 4/11/2006, 62, V24
> 158, BLDG50, 4/11/2006, 142, V24
> 159, BLDG50, 4/12/2006, 62, V24
> 160, BLDG50, 4/12/2006, 142, V24
> 161, BLDG51, 10/13/2005, 78, V13
> 162, BLDG51, 10/13/2005, 325, V13
> 163, BLDG52, 5/2/2006, 145, V9
> 164, BLDG52, 5/2/2006, 390, V12
> 165, BLDG52, 5/2/2006, 390, V9
> 166, BLDG52, 5/3/2006, 145, V8
> 167, BLDG52, 5/3/2006, 390, V9
> 168, BLDG52, 5/3/2006, 390, V12
> 169, BLDG53, 12/14/2005, 76, V9
> 170, BLDG53, 12/14/2005, 322, V9
> 171, BLDG53, 12/15/2005, 76, V9
> 172, BLDG53, 12/15/2005, 322, V9
> 173, BLDG53, 12/15/2005, 322, V22
> 174, BLDG54, 9/6/2005, 323, V3
> 175, BLDG54, 9/6/2005, 323, V27
> 176, BLDG54, 12/13/2005, 323, V22
> 177, BLDG54, 12/13/2005, 323, V27
> 178, BLDG55, 9/6/2005, 129, V21
> 179, BLDG55, 9/6/2005, 233, V23
> 180, BLDG55, 9/7/2005, 38, V23
> 181, BLDG55, 9/7/2005, 233, V23
> 182, BLDG55, 9/7/2005, 142, V23
> 183, BLDG55, 9/7/2005, 129, V21
> 184, BLDG55, 9/8/2005, 38, V23
> 185, BLDG55, 9/8/2005, 233, V23
> 186, BLDG55, 9/8/2005, 142, V23
> 187, BLDG55, 9/8/2005, 129, V21
> 188, BLDG55, 9/9/2005, 129, V21
> 189, BLDG55, 9/9/2005, 233, V23
> 190, BLDG55, 6/20/2006, 142, V8
> 191, BLDG55, 6/20/2006, 142, V29
> 192, BLDG56, 6/28/2006, 131, V13
> 193, BLDG56, 6/28/2006, 319, V13
> 194, BLDG56, 6/29/2006, 131, V13
> 195, BLDG56, 6/29/2006, 319, V13
> 196, BLDG57, 11/8/2005, 320, V22
> 197, BLDG57, 11/8/2005, 320, V27
> 198, BLDG58, 1/25/2006, 13, V3
> 199, BLDG58, 1/25/2006, 14, V13
> 200, BLDG59, 11/29/2005, 233, V9
> 201, BLDG59, 11/29/2005, 233, V14
> 202, BLDG60, 2/8/2006, 323, V22
> 203, BLDG60, 2/8/2006, 323, V27
> 204, BLDG61, 1/17/2006, 166, V3
> 205, BLDG61, 1/17/2006, 166, V22
> 206, BLDG62, 9/27/2005, 320, V3
> 207, BLDG62, 9/27/2005, 320, V22
> 208, BLDG62, 2/21/2006, 115, V9
> 209, BLDG62, 2/21/2006, 320, V9
> 210, BLDG62, 2/22/2006, 115, V9
> 211, BLDG62, 2/22/2006, 320, V9
> 212, BLDG63, 11/14/2005, 87, V11
> 213, BLDG63, 11/14/2005, 129, V27
> 214, BLDG63, 11/14/2005, 323, V27
> 215, BLDG63, 11/15/2005, 129, V11
> 216, BLDG63, 11/15/2005, 143, V11
> 217, BLDG63, 11/16/2005, 129, V11
> 218, BLDG63, 11/16/2005, 143, V11
> 219, BLDG63, 11/17/2005, 129, V11
> 220, BLDG63, 11/17/2005, 143, V11
> 221, BLDG63, 11/18/2005, 129, V27
> 222, BLDG63, 11/18/2005, 143, V11
> 223, BLDG64, 6/7/2006, 253, V2
> 224, BLDG64, 6/7/2006, 391, V6
> 225, BLDG65, 6/7/2006, 253, V2
> 226, BLDG65, 6/7/2006, 391, V14
> 227, BLDG66, 1/11/2006, 39, V25
> 228, BLDG66, 1/11/2006, 141, V25
> 229, BLDG66, 1/12/2006, 39, V25
> 230, BLDG66, 1/12/2006, 141, V25
> 231, BLDG66, 3/20/2006, 39, V23
> 232, BLDG66, 3/20/2006, 76, V23
> 233, BLDG66, 3/21/2006, 39, V23
> 234, BLDG66, 3/21/2006, 115, V23
> 235, BLDG66, 3/21/2006, 76, V23
> 236, BLDG66, 3/22/2006, 39, V23
> 237, BLDG66, 3/22/2006, 115, V23
> 238, BLDG66, 3/22/2006, 76, V23
> 239, BLDG67, 5/26/2006, 141, V7
> 240, BLDG67, 5/26/2006, 141, V17
> 241, BLDG68, 12/21/2005, 141, V8
> 242, BLDG68, 12/21/2005, 141, V17
> 243, BLDG69, 5/23/2006, 50, V3
> 244, BLDG69, 5/23/2006, 50, V8
> 245, BLDG70, 2/1/2006, 114, V17
> 246, BLDG70, 2/1/2006, 114, V22
> 247, BLDG71, 10/11/2005, 131, V8
> 248, BLDG71, 10/11/2005, 334, V8
> 249, BLDG71, 3/10/2006, 334, V8
> 250, BLDG71, 3/10/2006, 334, V22
> 251, BLDG72, 7/31/2006, 398, V2
> 252, BLDG72, 7/31/2006, 398, V22
> 253, BLDG73, 11/30/2005, 129, V23
> 254, BLDG73, 11/30/2005, 326, V24
> 255, BLDG74, 11/29/2005, 143, V22
> 256, BLDG74, 11/29/2005, 143, V23
> 257, BLDG75, 4/26/2006, 12, V18
> 258, BLDG75, 4/26/2006, 17, V18
> 259, BLDG76, 6/6/2006, 320, V14
> 260, BLDG76, 6/6/2006, 320, V15
> 261, BLDG77, 1/10/2006, 78, V2
> 262, BLDG77, 1/10/2006, 325, V9
> 263, BLDG77, 1/11/2006, 78, V2
> 264, BLDG77, 1/11/2006, 325, V8
> 265, BLDG77, 1/11/2006, 325, V6
> 266, BLDG78, 5/17/2006, 141, V17
> 267, BLDG78, 5/17/2006, 141, V22
> 268, BLDG79, 9/13/2005, 37, V19
> 269, BLDG79, 9/13/2005, 318, V19
> 270, BLDG80, 12/20/2005, 34, V13
> 271, BLDG80, 12/20/2005, 250, V13
> 272, BLDG81, 4/19/2006, 25, V22
> 273, BLDG81, 4/19/2006, 391, V2
> 274, BLDG82, 5/3/2006, 108, V14
> 275, BLDG82, 5/3/2006, 391, V2
> 276, BLDG83, 6/19/2006, 36, V8
> 277, BLDG83, 6/19/2006, 393, V8
> 278, BLDG84, 2/13/2006, 13, V14
> 279, BLDG84, 2/13/2006, 143, V8
> 280, BLDG85, 5/8/2006, 308, V8
> 281, BLDG85, 5/8/2006, 391, V2
> 282, BLDG86, 4/25/2006, 322, V8
> 283, BLDG86, 4/25/2006, 322, V22
> 284, BLDG87, 7/14/2006, 322, V13
> 285, BLDG87, 7/14/2006, 322, V15
> 286, BLDG88, 2/2/2006, 322, V8
> 287, BLDG88, 2/2/2006, 322, V22
> 288, BLDG89, 4/13/2006, 390, V2
> 289, BLDG89, 4/13/2006, 390, V8
> 290, BLDG90, 10/12/2005, 131, V8
> 291, BLDG90, 10/12/2005, 334, V8
> 292, BLDG91, 6/26/2006, 131, V22
> 293, BLDG91, 6/26/2006, 319, V22
> 294, BLDG91, 6/27/2006, 131, V22
> 295, BLDG91, 6/27/2006, 319, V22
> 296, BLDG92, 3/1/2006, 39, V23
> 297, BLDG92, 3/1/2006, 141, V23
> 298, BLDG92, 3/2/2006, 39, V23
> 299, BLDG92, 3/2/2006, 115, V23
> 300, BLDG92, 3/2/2006, 141, V23
> 301, BLDG92, 3/3/2006, 39, V23
> 302, BLDG92, 3/3/2006, 141, V23
> 303, BLDG92, 3/3/2006, 115, V23
> 304, BLDG92, 7/20/2006, 115, V23
> 305, BLDG92, 7/20/2006, 141, V25
> 306, BLDG92, 7/21/2006, 115, V23
> 307, BLDG92, 7/21/2006, 141, V25
> 308, BLDG93, 5/8/2006, 78, V2
> 309, BLDG93, 5/8/2006, 325, V9
> 310, BLDG93, 5/9/2006, 78, V2
> 311, BLDG93, 5/9/2006, 78, V9
> 312, BLDG93, 5/9/2006, 325, V9
> 313, BLDG94, 6/19/2006, 128, V9
> 314, BLDG94, 6/19/2006, 358, V9
> 315, BLDG94, 6/20/2006, 128, V9
> 316, BLDG94, 6/20/2006, 358, V9
> 317, BLDG95, 6/6/2006, 253, V2
> 318, BLDG95, 6/6/2006, 391, V14
> 319, BLDG96, 6/6/2006, 253, V2
> 320, BLDG96, 6/6/2006, 391, V14
> 321, BLDG97, 6/5/2006, 253, V7
> 322, BLDG97, 6/5/2006, 391, V7
> 323, BLDG98, 1/24/2006, 322, V9
> 324, BLDG98, 1/24/2006, 322, V22
> 325, BLDG99, 10/12/2005, 323, V7
> 326, BLDG99, 10/12/2005, 323, V15
> 327, BLDG100, 12/21/2005, 320, V14
> 328, BLDG100, 12/21/2005, 320, V22
> 329, BLDG100, 2/23/2006, 115, V9
> 330, BLDG100, 2/23/2006, 320, V9
> 331, BLDG100, 2/24/2006, 115, V9
> 332, BLDG100, 2/24/2006, 320, V9
> 333, BLDG101, 2/22/2006, 115, V9
> 334, BLDG101, 2/22/2006, 320, V9
> 335, BLDG101, 2/23/2006, 115, V9
> 336, BLDG101, 2/23/2006, 320, V9
> 337, BLDG102, 10/13/2005, 131, V8
> 338, BLDG102, 10/13/2005, 334, V8
> 339, BLDG103, 1/12/2006, 119, V7
> 340, BLDG103, 1/12/2006, 119, V22
> 341, BLDG104, 5/17/2006, 233, V23
> 342, BLDG104, 5/17/2006, 243, V23
> 343, BLDG104, 5/18/2006, 233, V23
> 344, BLDG104, 5/18/2006, 243, V23
> 345, BLDG105, 11/22/2005, 309, V6
> 346, BLDG105, 11/22/2005, 309, V22
> 347, BLDG106, 1/12/2006, 166, V8
> 348, BLDG106, 1/12/2006, 166, V22
> 349, BLDG107, 9/27/2005, 206, V7
> 350, BLDG107, 9/27/2005, 206, V20
> 351, BLDG108, 4/12/2006, 322, V14
> 352, BLDG108, 4/12/2006, 322, V22
> 353, BLDG109, 3/27/2006, 17, V11
> 354, BLDG109, 3/27/2006, 358, V11
> 355, BLDG109, 3/27/2006, 127, V11
> 356, BLDG109, 3/27/2006, 142, V11
> 357, BLDG109, 3/27/2006, 144, V11
> 358, BLDG109, 3/27/2006, 318, V11
> 359, BLDG109, 3/27/2006, 129, V11
> 360, BLDG109, 3/28/2006, 17, V11
> 361, BLDG109, 3/28/2006, 115, V11
> 362, BLDG109, 3/28/2006, 358, V11
> 363, BLDG109, 3/28/2006, 334, V11
> 364, BLDG109, 3/28/2006, 323, V11
> 365, BLDG109, 3/28/2006, 318, V11
> 366, BLDG109, 3/28/2006, 144, V11
> 367, BLDG109, 3/28/2006, 142, V11
> 368, BLDG109, 3/28/2006, 129, V11
> 369, BLDG109, 3/28/2006, 127, V11
> 370, BLDG109, 3/29/2006, 17, V11
> 371, BLDG109, 3/29/2006, 323, V11
> 372, BLDG109, 3/29/2006, 358, V11
> 373, BLDG109, 3/29/2006, 334, V11
> 374, BLDG109, 3/29/2006, 318, V11
> 375, BLDG109, 3/29/2006, 144, V11
> 376, BLDG109, 3/29/2006, 142, V11
> 377, BLDG109, 3/29/2006, 129, V11
> 378, BLDG109, 3/29/2006, 127, V11
> 379, BLDG109, 3/29/2006, 115, V11
> 380, BLDG109, 3/30/2006, 17, V11
> 381, BLDG109, 3/30/2006, 129, V11
> 382, BLDG109, 3/30/2006, 358, V11
> 383, BLDG109, 3/30/2006, 334, V11
> 384, BLDG109, 3/30/2006, 323, V11
> 385, BLDG109, 3/30/2006, 318, V11
> 386, BLDG109, 3/30/2006, 144, V11
> 387, BLDG109, 3/30/2006, 142, V11
> 388, BLDG109, 3/30/2006, 127, V11
> 389, BLDG109, 3/30/2006, 115, V11
> 390, BLDG109, 3/31/2006, 17, V11
> 391, BLDG109, 3/31/2006, 318, V11
> 392, BLDG109, 3/31/2006, 358, V11
> 393, BLDG109, 3/31/2006, 144, V11
> 394, BLDG109, 3/31/2006, 142, V11
> 395, BLDG109, 3/31/2006, 129, V11
> 396, BLDG109, 3/31/2006, 127, V11
> 397, BLDG109, 3/31/2006, 115, V11
> 398, BLDG110, 11/7/2005, 320, V22
> 399, BLDG110, 11/7/2005, 320, V27
> 400, BLDG111, 10/12/2005, 146, V8
> 401, BLDG111, 10/12/2005, 146, V22
> 402, BLDG112, 2/14/2006, 141, V8
> 403, BLDG112, 2/14/2006, 141, V22
> 404, BLDG113, 2/15/2006, 145, V9
> 405, BLDG113, 2/15/2006, 233, V9
> 406, BLDG113, 2/16/2006, 145, V8
> 407, BLDG113, 2/16/2006, 233, V9
> 408, BLDG114, 1/26/2006, 310, V6
> 409, BLDG114, 1/26/2006, 310, V8
> 410, BLDG115, 5/5/2006, 36, V9
> 411, BLDG115, 5/5/2006, 376, V9
> 412, BLDG115, 7/5/2006, 36, V9
> 413, BLDG115, 7/5/2006, 376, V9
> 414, BLDG115, 7/6/2006, 36, V9
> 415, BLDG115, 7/6/2006, 376, V9
> 416, BLDG116, 4/12/2006, 34, V4
> 417, BLDG116, 4/12/2006, 34, V13
> 418, BLDG117, 12/27/2005, 323, V13
> 419, BLDG117, 12/27/2005, 323, V27
> 420, BLDG117, 2/17/2006, 14, V3
> 421, BLDG117, 2/17/2006, 323, V3
> 422, BLDG118, 1/31/2006, 308, V17
> 423, BLDG118, 1/31/2006, 308, V22
> 424, BLDG119, 5/9/2006, 308, V8
> 425, BLDG119, 5/9/2006, 391, V2
> 426, BLDG120, 11/8/2005, 233, V28
> 427, BLDG120, 11/8/2005, 233, V29
> 428, BLDG121, 12/15/2005, 141, V8
> 429, BLDG121, 12/15/2005, 141, V17
> 430, BLDG122, 5/23/2006, 25, V2
> 431, BLDG122, 5/23/2006, 391, V22
> 432, BLDG123, 4/20/2006, 25, V14
> 433, BLDG123, 4/20/2006, 391, V2
> 434, BLDG124, 4/17/2006, 25, V22
> 435, BLDG124, 4/17/2006, 391, V2
> 436, BLDG125, 4/18/2006, 25, V22
> 437, BLDG125, 4/18/2006, 391, V2
> 438, BLDG126, 10/18/2005, 13, V19
> 439, BLDG126, 10/18/2005, 13, V22
> 440, BLDG127, 5/10/2006, 308, V8
> 441, BLDG127, 5/10/2006, 391, V2
> 442, BLDG128, 1/10/2006, 78, V11
> 443, BLDG128, 1/10/2006, 233, V23
> 444, BLDG129, 11/8/2005, 78, V9
> 445, BLDG129, 11/8/2005, 325, V9
> 446, BLDG129, 11/9/2005, 78, V9
> 447, BLDG129, 11/9/2005, 325, V9
> 448, BLDG130, 10/18/2005, 325, V28
> 449, BLDG130, 10/18/2005, 334, V9
> 450, BLDG130, 11/9/2005, 78, V9
> 451, BLDG130, 11/9/2005, 334, V9
> 452, BLDG130, 11/9/2005, 325, V9
> 453, BLDG130, 11/10/2005, 78, V9
> 454, BLDG130, 11/10/2005, 325, V9
> 455, BLDG130, 11/10/2005, 334, V6
> 456, BLDG131, 5/30/2006, 50, V3
> 457, BLDG131, 5/30/2006, 50, V8
> 458, BLDG132, 5/24/2006, 31, V6
> 459, BLDG132, 5/24/2006, 31, V22
> 460, BLDG133, 2/7/2006, 114, V17
> 461, BLDG133, 2/7/2006, 114, V22
> 462, BLDG134, 6/21/2006, 62, V9
> 463, BLDG134, 6/21/2006, 309, V28
> 464, BLDG135, 5/10/2006, 78, V9
> 465, BLDG135, 5/10/2006, 325, V9
> 466, BLDG135, 5/11/2006, 78, V9
> 467, BLDG135, 5/11/2006, 325, V9
> 468, BLDG136, 12/15/2005, 129, V23
> 469, BLDG136, 12/15/2005, 233, V23
> 470, BLDG137, 5/17/2006, 129, V6
> 471, BLDG137, 5/17/2006, 129, V8
> 472, BLDG138, 3/8/2006, 336, V8
> 473, BLDG138, 3/8/2006, 336, V22
> 474, BLDG139, 3/20/2006, 129, V14
> 475, BLDG139, 3/20/2006, 129, V19
> 476, BLDG140, 3/22/2006, 52, V29
> 477, BLDG140, 3/22/2006, 334, V29
> 478, BLDG140, 3/23/2006, 52, V29
> 479, BLDG140, 3/23/2006, 334, V29
> 480, BLDG141, 1/4/2006, 78, V22
> 481, BLDG141, 1/4/2006, 334, V22
> 482, BLDG142, 9/7/2005, 52, V8
> 483, BLDG142, 9/7/2005, 52, V10
> 484, BLDG143, 5/4/2006, 78, V28
> 485, BLDG143, 5/4/2006, 334, V29
> 486, BLDG144, 5/11/2006, 50, V3
> 487, BLDG144, 5/11/2006, 50, V8
> 488, BLDG144, 5/12/2006, 50, V7
> 489, BLDG144, 5/12/2006, 50, V8
> 490, BLDG145, 10/4/2005, 119, V16
> 491, BLDG145, 10/4/2005, 119, V19
> 492, BLDG146, 6/6/2006, 34, V7
> 493, BLDG146, 6/6/2006, 34, V8
> 494, BLDG147, 9/14/2005, 36, V28
> 495, BLDG147, 9/14/2005, 324, V5
> 496, BLDG148, 9/14/2005, 322, V14
> 497, BLDG148, 9/14/2005, 322, V15
> 498, BLDG149, 6/20/2006, 123, V8
> 499, BLDG149, 6/20/2006, 123, V22
> 500, BLDG150, 5/16/2006, 12, V18
> 501, BLDG150, 5/16/2006, 318, V18
> 502, BLDG151, 4/17/2006, 62, V23
> 503, BLDG151, 4/17/2006, 142, V23
> 504, BLDG151, 4/17/2006, 318, V23
> 505, BLDG151, 4/17/2006, 154, V2
> 506, BLDG151, 4/18/2006, 62, V23
> 507, BLDG151, 4/18/2006, 318, V23
> 508, BLDG151, 4/18/2006, 142, V23
> 509, BLDG151, 4/18/2006, 154, V2
> 510, BLDG151, 4/19/2006, 62, V22
> 511, BLDG151, 4/19/2006, 318, V23
> 512, BLDG151, 4/19/2006, 154, V2
> 513, BLDG151, 4/19/2006, 142, V23
> 514, BLDG152, 10/20/2005, 320, V14
> 515, BLDG152, 10/20/2005, 320, V15
> 516, BLDG153, 7/11/2006, 334, V8
> 517, BLDG153, 7/11/2006, 334, V9
> 518, BLDG154, 2/1/2006, 53, V23
> 519, BLDG154, 2/1/2006, 323, V23
> 520, BLDG154, 2/2/2006, 53, V23
> 521, BLDG154, 2/2/2006, 323, V23
> 522, BLDG154, 2/3/2006, 53, V23
> 523, BLDG154, 2/3/2006, 323, V27
> 524, BLDG154, 2/3/2006, 323, V23
> 525, BLDG154, 7/12/2006, 53, V24
> 526, BLDG154, 7/12/2006, 139, V26
> 527, BLDG154, 7/12/2006, 141, V25
> 528, BLDG154, 7/13/2006, 53, V24
> 529, BLDG154, 7/13/2006, 139, V26
> 530, BLDG154, 7/13/2006, 141, V25
> 531, BLDG154, 7/14/2006, 53, V24
> 532, BLDG154, 7/14/2006, 141, V25
> 533, BLDG154, 7/14/2006, 139, V26
> 534, BLDG155, 9/14/2005, 323, V7
> 535, BLDG155, 9/14/2005, 323, V27
> 536, BLDG156, 9/12/2005, 165, V6
> 537, BLDG156, 9/12/2005, 165, V8
> 538, BLDG157, 10/27/2005, 32, V13
> 539, BLDG157, 10/27/2005, 310, V13
> 540, BLDG158, 11/2/2005, 320, V14
> 541, BLDG158, 11/2/2005, 320, V15
> 542, BLDG158, 2/20/2006, 115, V9
> 543, BLDG158, 2/20/2006, 320, V9
> 544, BLDG158, 2/21/2006, 115, V9
> 545, BLDG158, 2/21/2006, 320, V9
> 546, BLDG158, 4/26/2006, 320, V3
> 547, BLDG158, 4/26/2006, 320, V17
> 548, BLDG159, 3/14/2006, 336, V14
> 549, BLDG159, 3/14/2006, 336, V22
> 550, BLDG160, 3/15/2006, 336, V8
> 551, BLDG160, 3/15/2006, 336, V14
> 552, BLDG160, 8/24/2006, 336, V8
> 553, BLDG160, 8/24/2006, 336, V27
> 554, BLDG161, 1/5/2006, 253, V6
> 555, BLDG161, 1/5/2006, 253, V17
> 556, BLDG162, 3/13/2006, 141, V9
> 557, BLDG162, 3/13/2006, 141, V22
> 558, BLDG163, 6/29/2006, 78, V6
> 559, BLDG163, 6/29/2006, 78, V9
> 560, BLDG164, 12/12/2005, 76, V9
> 561, BLDG164, 12/12/2005, 322, V9
> 562, BLDG164, 12/13/2005, 76, V9
> 563, BLDG164, 12/13/2005, 322, V22
> 564, BLDG164, 12/13/2005, 322, V9
> 565, BLDG165, 1/11/2006, 166, V8
> 566, BLDG165, 1/11/2006, 166, V22
> 567, BLDG166, 5/24/2006, 141, V17
> 568, BLDG166, 5/24/2006, 141, V22
> 569, BLDG167, 1/11/2006, 165, V8
> 570, BLDG167, 1/11/2006, 165, V22
> 571, BLDG168, 10/18/2005, 244, V14
> 572, BLDG168, 10/18/2005, 309, V14
> 573, BLDG169, 1/31/2006, 144, V8
> 574, BLDG169, 1/31/2006, 144, V22
> 575, BLDG170, 6/6/2006, 123, V18
> 576, BLDG170, 6/6/2006, 383, V18
> 577, BLDG171, 1/17/2006, 263, V6
> 578, BLDG171, 1/17/2006, 263, V9
> 579, BLDG172, 8/10/2006, 233, V9
> 580, BLDG172, 8/10/2006, 376, V9
> 581, BLDG172, 8/11/2006, 233, V9
> 582, BLDG172, 8/11/2006, 376, V9
> 583, BLDG173, 4/4/2006, 131, V13
> 584, BLDG173, 4/4/2006, 144, V13
> 585, BLDG174, 7/4/2006, 383, V4
> 586, BLDG174, 7/4/2006, 383, V8
>
> =====================================
>
> Your help is appreciated.
Received on Fri Aug 04 2006 - 22:32:50 CDT