Re: Difficult query problem

From: DFS <nospam_at_dfs_.com>
Date: Sat, 5 Aug 2006 08:40:40 -0400
Message-ID: <pk0Bg.42121$Bd.19396@bignews6.bellsouth.net>

Michel Cadot wrote:

> "Michel Cadot" <micadot{at}altern{dot}org> a écrit dans le message de
> news: 44d43437$0$29867$626a54ce_at_news.free.fr...

>>
>> "DFS" <nospam_at_dfs_.com> a écrit dans le message de news:
>> OiUAg.46080$Nt.19897_at_bignews8.bellsouth.net...
>>> 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
>>>
>>
>> And why don't you post:
>> - your Oracle version
>> - your solutions
>> - insert statements instead of raw data to help us to help you
> I forgot:
> - the results you should have with the data you provided.

Thanks

What's an Oracle version?

The solutions

Condition 1: same employee, for different visit codes (206 rows)

SELECT V.*
FROM VISITS V INNER JOIN
(
SELECT BLDGCODE, VISITDATE, EMPID, Count(EMPID) AS CountEMPID FROM VISITS
GROUP BY BLDGCODE, VISITDATE, EMPID
HAVING Count(EMPID) >1
) V2
ON (V.EMPID = V2.EMPID)
AND (V.VISITDATE = V2.VISITDATE)
AND (V.BLDGCODE = V2.BLDGCODE); Condition 2: different employees, same visit code (259 rows)

SELECT V.*
FROM VISITS V INNER JOIN
(
SELECT BLDGCODE, VISITDATE, VISITCODE, Count(VISITCODE) AS CountCODE FROM VISITS
GROUP BY BLDGCODE, VISITDATE, VISITCODE
HAVING Count(VISITCODE) >1
) V2
ON (V.VISITCODE = V2.VISITCODE)
AND (V.VISITDATE = V2.VISITDATE)
AND (V.BLDGCODE = V2.BLDGCODE); Condition 3: different employees, different visit code

Still unsolved via SQL, but my kludgey query/VB solution yielded 177 rows - and it's correct. I got it by adding the data to a temp table, adding 3 boolean conditon columns, marking the rows that met conditions 1 or 2, then looking for those that met neither or both conditions 1 and 2 (and marked those as condition3), and finally looking for rows meeting building/visit date condition 1 or 2 that still weren't marked after all this!

INSERTS INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(1, 'BLDG1', #10/18/2005#, 128, 'V6'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(2, 'BLDG1', #10/18/2005#, 128, 'V9'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(3, 'BLDG2', #1/24/2006#, 128, 'V8'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(4, 'BLDG2', #1/24/2006#, 165, 'V22'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(5, 'BLDG3', #2/15/2006#, 13, 'V14'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(6, 'BLDG3', #2/15/2006#, 143, 'V8'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(7, 'BLDG4', #8/1/2006#, 319, 'V9'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(8, 'BLDG4', #8/1/2006#, 390, 'V9'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(9, 'BLDG4', #8/2/2006#, 319, 'V9'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(10, 'BLDG4', #8/2/2006#, 390, 'V9'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(11, 'BLDG4', #8/2/2006#, 390, 'V8'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(12, 'BLDG5', #8/28/2006#, 318, 'V11'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(13, 'BLDG5', #8/28/2006#, 376, 'V11'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(14, 'BLDG5', #8/29/2006#, 318, 'V11'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(15, 'BLDG5', #8/29/2006#, 334, 'V11'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(16, 'BLDG5', #8/29/2006#, 376, 'V11'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(17, 'BLDG5', #8/30/2006#, 318, 'V11'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(18, 'BLDG5', #8/30/2006#, 376, 'V11'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(19, 'BLDG5', #8/30/2006#, 334, 'V11'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(20, 'BLDG5', #8/31/2006#, 318, 'V11'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(21, 'BLDG5', #8/31/2006#, 376, 'V11'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(22, 'BLDG5', #8/31/2006#, 334, 'V11');

INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) 
VALUES(23, 'BLDG6', #10/11/2005#, 323, 'V19');
INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) 
VALUES(24, 'BLDG6', #10/11/2005#, 323, 'V27');
INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE)

VALUES(25, 'BLDG6', #11/8/2005#, 323, 'V8'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(26, 'BLDG6', #11/8/2005#, 323, 'V27');

INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) 
VALUES(27, 'BLDG7', #10/18/2005#, 323, 'V3');
INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) 
VALUES(28, 'BLDG7', #10/18/2005#, 323, 'V27');
INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE)

VALUES(29, 'BLDG7', #11/14/2005#, 14, 'V3');

INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) 
VALUES(30, 'BLDG7', #11/14/2005#, 323, 'V3');
INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) 
VALUES(31, 'BLDG7', #11/14/2005#, 143, 'V3');
INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) 
VALUES(32, 'BLDG7', #12/15/2005#, 143, 'V3');
INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) 
VALUES(33, 'BLDG7', #12/15/2005#, 323, 'V3');
INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE)

VALUES(34, 'BLDG8', #3/8/2006#, 15, 'V23'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(35, 'BLDG8', #3/8/2006#, 120, 'V23'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(36, 'BLDG9', #5/22/2006#, 25, 'V2'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(37, 'BLDG9', #5/22/2006#, 391, 'V14');

INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) 
VALUES(38, 'BLDG10', #11/3/2005#, 310, 'V6');
INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) 
VALUES(39, 'BLDG10', #11/3/2005#, 310, 'V8');
INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) 
VALUES(40, 'BLDG10', #3/15/2006#, 139, 'V28');
INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) 
VALUES(41, 'BLDG10', #3/15/2006#, 310, 'V28');
INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) 
VALUES(42, 'BLDG10', #3/16/2006#, 139, 'V28');
INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) 
VALUES(43, 'BLDG10', #3/16/2006#, 310, 'V28');
INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) 
VALUES(44, 'BLDG11', #11/3/2005#, 323, 'V22');
INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) 
VALUES(45, 'BLDG11', #11/3/2005#, 323, 'V27');
INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE)

VALUES(46, 'BLDG12', #4/18/2006#, 71, 'V2');

INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) 
VALUES(47, 'BLDG12', #4/18/2006#, 337, 'V13');
INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE)

VALUES(48, 'BLDG12', #4/19/2006#, 71, 'V2');

INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) 
VALUES(49, 'BLDG12', #4/19/2006#, 337, 'V13');
INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) 
VALUES(50, 'BLDG13', #10/3/2005#, 142, 'V22');
INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) 
VALUES(51, 'BLDG13', #10/3/2005#, 142, 'V27');
INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE)

VALUES(52, 'BLDG14', #5/23/2006#, 32, 'V23');

INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) 
VALUES(53, 'BLDG14', #5/23/2006#, 139, 'V23');
INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE)

VALUES(54, 'BLDG14', #5/24/2006#, 32, 'V23');

INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) 
VALUES(55, 'BLDG14', #5/24/2006#, 139, 'V23');
INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) 
VALUES(56, 'BLDG15', #5/30/2006#, 141, 'V17');
INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) 
VALUES(57, 'BLDG15', #5/30/2006#, 141, 'V22');
INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE)

VALUES(58, 'BLDG16', #6/1/2006#, 71, 'V18'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(59, 'BLDG16', #6/1/2006#, 336, 'V18'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(60, 'BLDG16', #6/1/2006#, 123, 'V18'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(61, 'BLDG17', #2/21/2006#, 34, 'V8'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(62, 'BLDG17', #2/21/2006#, 34, 'V19'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(63, 'BLDG18', #12/14/2005#, 141, 'V7'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(64, 'BLDG18', #12/14/2005#, 141, 'V17'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(65, 'BLDG19', #10/18/2005#, 320, 'V14'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(66, 'BLDG19', #10/18/2005#, 320, 'V16'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(67, 'BLDG20', #3/6/2006#, 141, 'V8'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(68, 'BLDG20', #3/6/2006#, 141, 'V22'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(69, 'BLDG21', #10/11/2005#, 324, 'V6'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(70, 'BLDG21', #10/11/2005#, 324, 'V7'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(71, 'BLDG22', #7/10/2006#, 38, 'V23');

INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) 
VALUES(72, 'BLDG22', #7/10/2006#, 252, 'V11');
INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE)

VALUES(73, 'BLDG22', #7/11/2006#, 38, 'V23');

INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) 
VALUES(74, 'BLDG22', #7/11/2006#, 252, 'V11');
INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) 
VALUES(75, 'BLDG22', #7/11/2006#, 142, 'V22');
INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE)

VALUES(76, 'BLDG23', #11/10/2005#, 308, 'V7'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(77, 'BLDG23', #11/10/2005#, 308, 'V8');

INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) 
VALUES(78, 'BLDG23', #5/11/2006#, 308, 'V8');
INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) 
VALUES(79, 'BLDG23', #5/11/2006#, 391, 'V2');
INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) 
VALUES(80, 'BLDG24', #3/23/2006#, 143, 'V24');
INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) 
VALUES(81, 'BLDG24', #3/23/2006#, 155, 'V2');
INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) 
VALUES(82, 'BLDG24', #3/24/2006#, 143, 'V24');
INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) 
VALUES(83, 'BLDG24', #3/24/2006#, 155, 'V25');
INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE)

VALUES(84, 'BLDG25', #10/3/2005#, 31, 'V14'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(85, 'BLDG25', #10/3/2005#, 31, 'V19'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(86, 'BLDG26', #2/20/2006#, 31, 'V14'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(87, 'BLDG26', #2/20/2006#, 31, 'V22'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(88, 'BLDG27', #2/15/2006#, 13, 'V14');

INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) 
VALUES(89, 'BLDG27', #2/15/2006#, 143, 'V8');
INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE)

VALUES(90, 'BLDG28', #10/12/2005#, 141, 'V8'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(91, 'BLDG28', #10/12/2005#, 141, 'V17'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(92, 'BLDG29', #10/4/2005#, 32, 'V22');

INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) 
VALUES(93, 'BLDG29', #10/4/2005#, 310, 'V2');
INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE)

VALUES(94, 'BLDG30', #9/12/2005#, 53, 'V23');

INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) 
VALUES(95, 'BLDG30', #9/12/2005#, 123, 'V21');
INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) 
VALUES(96, 'BLDG30', #9/12/2005#, 141, 'V23');
INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE)

VALUES(97, 'BLDG30', #9/13/2005#, 53, 'V23');

INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) 
VALUES(98, 'BLDG30', #9/13/2005#, 141, 'V23');
INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) 
VALUES(99, 'BLDG30', #9/13/2005#, 123, 'V21');
INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) 
VALUES(100, 'BLDG30', #9/14/2005#, 53, 'V23');
INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE)

VALUES(101, 'BLDG30', #9/14/2005#, 141, 'V23'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(102, 'BLDG30', #9/14/2005#, 123, 'V21');

INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) 
VALUES(103, 'BLDG31', #2/14/2006#, 13, 'V14');
INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE)

VALUES(104, 'BLDG31', #2/14/2006#, 143, 'V8'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(105, 'BLDG32', #11/1/2005#, 320, 'V3'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(106, 'BLDG32', #11/1/2005#, 320, 'V27');

INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) 
VALUES(107, 'BLDG33', #11/3/2005#, 34, 'V7');
INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) 
VALUES(108, 'BLDG33', #11/3/2005#, 34, 'V19');
INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) 
VALUES(109, 'BLDG34', #7/10/2006#, 37, 'V23');
INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) 
VALUES(110, 'BLDG34', #7/10/2006#, 62, 'V23');
INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) 
VALUES(111, 'BLDG34', #7/11/2006#, 37, 'V23');
INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) 
VALUES(112, 'BLDG34', #7/11/2006#, 62, 'V23');
INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) 
VALUES(113, 'BLDG34', #7/12/2006#, 37, 'V23');
INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) 
VALUES(114, 'BLDG34', #7/12/2006#, 62, 'V23');
INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE)

VALUES(115, 'BLDG35', #11/21/2005#, 78, 'V27'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(116, 'BLDG35', #11/21/2005#, 334, 'V8'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(117, 'BLDG36', #7/10/2006#, 358, 'V1'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(118, 'BLDG36', #7/10/2006#, 358, 'V8');

INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) 
VALUES(119, 'BLDG37', #8/14/2006#, 50, 'V14');
INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) 
VALUES(120, 'BLDG37', #8/14/2006#, 71, 'V11');
INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) 
VALUES(121, 'BLDG37', #8/15/2006#, 50, 'V14');
INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) 
VALUES(122, 'BLDG37', #8/15/2006#, 71, 'V11');
INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE)

VALUES(123, 'BLDG38', #9/13/2005#, 130, 'V6'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(124, 'BLDG38', #9/13/2005#, 130, 'V8');

INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) 
VALUES(125, 'BLDG39', #2/22/2006#, 34, 'V8');
INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) 
VALUES(126, 'BLDG39', #2/22/2006#, 34, 'V14');
INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) 
VALUES(127, 'BLDG40', #2/14/2006#, 13, 'V14');
INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE)

VALUES(128, 'BLDG40', #2/14/2006#, 143, 'V8'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(129, 'BLDG41', #5/22/2006#, 252, 'V17'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(130, 'BLDG41', #5/22/2006#, 326, 'V17'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(131, 'BLDG41', #5/23/2006#, 252, 'V17'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(132, 'BLDG41', #5/23/2006#, 326, 'V17'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(133, 'BLDG42', #7/10/2006#, 309, 'V2'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(134, 'BLDG42', #7/10/2006#, 318, 'V23'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(135, 'BLDG42', #7/11/2006#, 309, 'V2'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(136, 'BLDG42', #7/11/2006#, 318, 'V23'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(137, 'BLDG42', #7/12/2006#, 309, 'V2'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(138, 'BLDG42', #7/12/2006#, 318, 'V23'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(139, 'BLDG43', #10/18/2005#, 206, 'V8'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(140, 'BLDG43', #10/18/2005#, 206, 'V14');

INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) 
VALUES(141, 'BLDG44', #3/9/2006#, 142, 'V24');
INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) 
VALUES(142, 'BLDG44', #3/9/2006#, 233, 'V23');
INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) 
VALUES(143, 'BLDG44', #3/9/2006#, 319, 'V24');
INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE)

VALUES(144, 'BLDG44', #3/10/2006#, 142, 'V24'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(145, 'BLDG44', #3/10/2006#, 319, 'V24'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(146, 'BLDG44', #3/10/2006#, 233, 'V23'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(147, 'BLDG45', #9/15/2005#, 128, 'V6'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(148, 'BLDG45', #9/15/2005#, 128, 'V9');

INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) 
VALUES(149, 'BLDG46', #5/24/2006#, 25, 'V2');
INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE)

VALUES(150, 'BLDG46', #5/24/2006#, 391, 'V8'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(151, 'BLDG47', #1/17/2006#, 321, 'V6'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(152, 'BLDG47', #1/17/2006#, 321, 'V22');

INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) 
VALUES(153, 'BLDG48', #7/13/2006#, 38, 'V18');
INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE)

VALUES(154, 'BLDG48', #7/13/2006#, 318, 'V11'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(155, 'BLDG49', #7/12/2006#, 142, 'V23'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(156, 'BLDG49', #7/12/2006#, 263, 'V23');

INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) 
VALUES(157, 'BLDG50', #4/11/2006#, 62, 'V24');
INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE)

VALUES(158, 'BLDG50', #4/11/2006#, 142, 'V24');

INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) 
VALUES(159, 'BLDG50', #4/12/2006#, 62, 'V24');
INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE)

VALUES(160, 'BLDG50', #4/12/2006#, 142, 'V24'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(161, 'BLDG51', #10/13/2005#, 78, 'V13'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(162, 'BLDG51', #10/13/2005#, 325, 'V13');

INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) 
VALUES(163, 'BLDG52', #5/2/2006#, 145, 'V9');
INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) 
VALUES(164, 'BLDG52', #5/2/2006#, 390, 'V12');
INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) 
VALUES(165, 'BLDG52', #5/2/2006#, 390, 'V9');
INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) 
VALUES(166, 'BLDG52', #5/3/2006#, 145, 'V8');
INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) 
VALUES(167, 'BLDG52', #5/3/2006#, 390, 'V9');
INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) 
VALUES(168, 'BLDG52', #5/3/2006#, 390, 'V12');
INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE)

VALUES(169, 'BLDG53', #12/14/2005#, 76, 'V9'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(170, 'BLDG53', #12/14/2005#, 322, 'V9'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(171, 'BLDG53', #12/15/2005#, 76, 'V9'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(172, 'BLDG53', #12/15/2005#, 322, 'V9'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(173, 'BLDG53', #12/15/2005#, 322, 'V22');

INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) 
VALUES(174, 'BLDG54', #9/6/2005#, 323, 'V3');
INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) 
VALUES(175, 'BLDG54', #9/6/2005#, 323, 'V27');
INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE)

VALUES(176, 'BLDG54', #12/13/2005#, 323, 'V22'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(177, 'BLDG54', #12/13/2005#, 323, 'V27');

INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) 
VALUES(178, 'BLDG55', #9/6/2005#, 129, 'V21');
INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) 
VALUES(179, 'BLDG55', #9/6/2005#, 233, 'V23');
INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE)

VALUES(180, 'BLDG55', #9/7/2005#, 38, 'V23');

INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) 
VALUES(181, 'BLDG55', #9/7/2005#, 233, 'V23');
INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) 
VALUES(182, 'BLDG55', #9/7/2005#, 142, 'V23');
INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) 
VALUES(183, 'BLDG55', #9/7/2005#, 129, 'V21');
INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE)

VALUES(184, 'BLDG55', #9/8/2005#, 38, 'V23');

INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) 
VALUES(185, 'BLDG55', #9/8/2005#, 233, 'V23');
INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) 
VALUES(186, 'BLDG55', #9/8/2005#, 142, 'V23');
INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) 
VALUES(187, 'BLDG55', #9/8/2005#, 129, 'V21');
INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) 
VALUES(188, 'BLDG55', #9/9/2005#, 129, 'V21');
INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) 
VALUES(189, 'BLDG55', #9/9/2005#, 233, 'V23');
INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE)

VALUES(190, 'BLDG55', #6/20/2006#, 142, 'V8'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(191, 'BLDG55', #6/20/2006#, 142, 'V29'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(192, 'BLDG56', #6/28/2006#, 131, 'V13'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(193, 'BLDG56', #6/28/2006#, 319, 'V13'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(194, 'BLDG56', #6/29/2006#, 131, 'V13'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(195, 'BLDG56', #6/29/2006#, 319, 'V13'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(196, 'BLDG57', #11/8/2005#, 320, 'V22'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(197, 'BLDG57', #11/8/2005#, 320, 'V27');

INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) 
VALUES(198, 'BLDG58', #1/25/2006#, 13, 'V3');
INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) 
VALUES(199, 'BLDG58', #1/25/2006#, 14, 'V13');
INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE)

VALUES(200, 'BLDG59', #11/29/2005#, 233, 'V9'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(201, 'BLDG59', #11/29/2005#, 233, 'V14');

INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) 
VALUES(202, 'BLDG60', #2/8/2006#, 323, 'V22');
INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) 
VALUES(203, 'BLDG60', #2/8/2006#, 323, 'V27');
INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE)

VALUES(204, 'BLDG61', #1/17/2006#, 166, 'V3'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(205, 'BLDG61', #1/17/2006#, 166, 'V22'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(206, 'BLDG62', #9/27/2005#, 320, 'V3'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(207, 'BLDG62', #9/27/2005#, 320, 'V22'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(208, 'BLDG62', #2/21/2006#, 115, 'V9'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(209, 'BLDG62', #2/21/2006#, 320, 'V9'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(210, 'BLDG62', #2/22/2006#, 115, 'V9'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(211, 'BLDG62', #2/22/2006#, 320, 'V9'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(212, 'BLDG63', #11/14/2005#, 87, 'V11'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(213, 'BLDG63', #11/14/2005#, 129, 'V27'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(214, 'BLDG63', #11/14/2005#, 323, 'V27'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(215, 'BLDG63', #11/15/2005#, 129, 'V11'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(216, 'BLDG63', #11/15/2005#, 143, 'V11'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(217, 'BLDG63', #11/16/2005#, 129, 'V11'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(218, 'BLDG63', #11/16/2005#, 143, 'V11'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(219, 'BLDG63', #11/17/2005#, 129, 'V11'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(220, 'BLDG63', #11/17/2005#, 143, 'V11'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(221, 'BLDG63', #11/18/2005#, 129, 'V27'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(222, 'BLDG63', #11/18/2005#, 143, 'V11');

INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) 
VALUES(223, 'BLDG64', #6/7/2006#, 253, 'V2');
INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) 
VALUES(224, 'BLDG64', #6/7/2006#, 391, 'V6');
INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) 
VALUES(225, 'BLDG65', #6/7/2006#, 253, 'V2');
INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) 
VALUES(226, 'BLDG65', #6/7/2006#, 391, 'V14');
INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) 
VALUES(227, 'BLDG66', #1/11/2006#, 39, 'V25');
INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE)

VALUES(228, 'BLDG66', #1/11/2006#, 141, 'V25');

INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) 
VALUES(229, 'BLDG66', #1/12/2006#, 39, 'V25');
INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE)

VALUES(230, 'BLDG66', #1/12/2006#, 141, 'V25');

INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) 
VALUES(231, 'BLDG66', #3/20/2006#, 39, 'V23');
INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) 
VALUES(232, 'BLDG66', #3/20/2006#, 76, 'V23');
INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) 
VALUES(233, 'BLDG66', #3/21/2006#, 39, 'V23');
INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE)

VALUES(234, 'BLDG66', #3/21/2006#, 115, 'V23');

INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) 
VALUES(235, 'BLDG66', #3/21/2006#, 76, 'V23');
INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) 
VALUES(236, 'BLDG66', #3/22/2006#, 39, 'V23');
INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE)

VALUES(237, 'BLDG66', #3/22/2006#, 115, 'V23');

INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) 
VALUES(238, 'BLDG66', #3/22/2006#, 76, 'V23');
INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE)

VALUES(239, 'BLDG67', #5/26/2006#, 141, 'V7'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(240, 'BLDG67', #5/26/2006#, 141, 'V17'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(241, 'BLDG68', #12/21/2005#, 141, 'V8'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(242, 'BLDG68', #12/21/2005#, 141, 'V17');

INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) 
VALUES(243, 'BLDG69', #5/23/2006#, 50, 'V3');
INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) 
VALUES(244, 'BLDG69', #5/23/2006#, 50, 'V8');
INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) 
VALUES(245, 'BLDG70', #2/1/2006#, 114, 'V17');
INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) 
VALUES(246, 'BLDG70', #2/1/2006#, 114, 'V22');
INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE)

VALUES(247, 'BLDG71', #10/11/2005#, 131, 'V8'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(248, 'BLDG71', #10/11/2005#, 334, 'V8'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(249, 'BLDG71', #3/10/2006#, 334, 'V8'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(250, 'BLDG71', #3/10/2006#, 334, 'V22'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(251, 'BLDG72', #7/31/2006#, 398, 'V2'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(252, 'BLDG72', #7/31/2006#, 398, 'V22'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(253, 'BLDG73', #11/30/2005#, 129, 'V23'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(254, 'BLDG73', #11/30/2005#, 326, 'V24'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(255, 'BLDG74', #11/29/2005#, 143, 'V22'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(256, 'BLDG74', #11/29/2005#, 143, 'V23');

INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) 
VALUES(257, 'BLDG75', #4/26/2006#, 12, 'V18');
INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) 
VALUES(258, 'BLDG75', #4/26/2006#, 17, 'V18');
INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) 
VALUES(259, 'BLDG76', #6/6/2006#, 320, 'V14');
INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) 
VALUES(260, 'BLDG76', #6/6/2006#, 320, 'V15');
INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) 
VALUES(261, 'BLDG77', #1/10/2006#, 78, 'V2');
INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE)

VALUES(262, 'BLDG77', #1/10/2006#, 325, 'V9');

INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) 
VALUES(263, 'BLDG77', #1/11/2006#, 78, 'V2');
INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE)

VALUES(264, 'BLDG77', #1/11/2006#, 325, 'V8'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(265, 'BLDG77', #1/11/2006#, 325, 'V6'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(266, 'BLDG78', #5/17/2006#, 141, 'V17'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(267, 'BLDG78', #5/17/2006#, 141, 'V22');

INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) 
VALUES(268, 'BLDG79', #9/13/2005#, 37, 'V19');
INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE)

VALUES(269, 'BLDG79', #9/13/2005#, 318, 'V19'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(270, 'BLDG80', #12/20/2005#, 34, 'V13'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(271, 'BLDG80', #12/20/2005#, 250, 'V13');

INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) 
VALUES(272, 'BLDG81', #4/19/2006#, 25, 'V22');
INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE)

VALUES(273, 'BLDG81', #4/19/2006#, 391, 'V2');

INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) 
VALUES(274, 'BLDG82', #5/3/2006#, 108, 'V14');
INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) 
VALUES(275, 'BLDG82', #5/3/2006#, 391, 'V2');
INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) 
VALUES(276, 'BLDG83', #6/19/2006#, 36, 'V8');
INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE)

VALUES(277, 'BLDG83', #6/19/2006#, 393, 'V8');

INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) 
VALUES(278, 'BLDG84', #2/13/2006#, 13, 'V14');
INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE)

VALUES(279, 'BLDG84', #2/13/2006#, 143, 'V8');

INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) 
VALUES(280, 'BLDG85', #5/8/2006#, 308, 'V8');
INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) 
VALUES(281, 'BLDG85', #5/8/2006#, 391, 'V2');
INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE)

VALUES(282, 'BLDG86', #4/25/2006#, 322, 'V8'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(283, 'BLDG86', #4/25/2006#, 322, 'V22'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(284, 'BLDG87', #7/14/2006#, 322, 'V13'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(285, 'BLDG87', #7/14/2006#, 322, 'V15');

INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) 
VALUES(286, 'BLDG88', #2/2/2006#, 322, 'V8');
INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) 
VALUES(287, 'BLDG88', #2/2/2006#, 322, 'V22');
INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE)

VALUES(288, 'BLDG89', #4/13/2006#, 390, 'V2'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(289, 'BLDG89', #4/13/2006#, 390, 'V8'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(290, 'BLDG90', #10/12/2005#, 131, 'V8'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(291, 'BLDG90', #10/12/2005#, 334, 'V8'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(292, 'BLDG91', #6/26/2006#, 131, 'V22'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(293, 'BLDG91', #6/26/2006#, 319, 'V22'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(294, 'BLDG91', #6/27/2006#, 131, 'V22'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(295, 'BLDG91', #6/27/2006#, 319, 'V22'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(296, 'BLDG92', #3/1/2006#, 39, 'V23');

INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) 
VALUES(297, 'BLDG92', #3/1/2006#, 141, 'V23');
INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE)

VALUES(298, 'BLDG92', #3/2/2006#, 39, 'V23');

INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) 
VALUES(299, 'BLDG92', #3/2/2006#, 115, 'V23');
INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) 
VALUES(300, 'BLDG92', #3/2/2006#, 141, 'V23');
INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE)

VALUES(301, 'BLDG92', #3/3/2006#, 39, 'V23');

INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) 
VALUES(302, 'BLDG92', #3/3/2006#, 141, 'V23');
INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) 
VALUES(303, 'BLDG92', #3/3/2006#, 115, 'V23');
INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE)

VALUES(304, 'BLDG92', #7/20/2006#, 115, 'V23'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(305, 'BLDG92', #7/20/2006#, 141, 'V25'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(306, 'BLDG92', #7/21/2006#, 115, 'V23'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(307, 'BLDG92', #7/21/2006#, 141, 'V25'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(308, 'BLDG93', #5/8/2006#, 78, 'V2');

INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) 
VALUES(309, 'BLDG93', #5/8/2006#, 325, 'V9');
INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE)

VALUES(310, 'BLDG93', #5/9/2006#, 78, 'V2'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(311, 'BLDG93', #5/9/2006#, 78, 'V9');

INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) 
VALUES(312, 'BLDG93', #5/9/2006#, 325, 'V9');
INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE)

VALUES(313, 'BLDG94', #6/19/2006#, 128, 'V9'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(314, 'BLDG94', #6/19/2006#, 358, 'V9'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(315, 'BLDG94', #6/20/2006#, 128, 'V9'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(316, 'BLDG94', #6/20/2006#, 358, 'V9');

INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) 
VALUES(317, 'BLDG95', #6/6/2006#, 253, 'V2');
INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) 
VALUES(318, 'BLDG95', #6/6/2006#, 391, 'V14');
INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) 
VALUES(319, 'BLDG96', #6/6/2006#, 253, 'V2');
INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) 
VALUES(320, 'BLDG96', #6/6/2006#, 391, 'V14');
INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) 
VALUES(321, 'BLDG97', #6/5/2006#, 253, 'V7');
INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) 
VALUES(322, 'BLDG97', #6/5/2006#, 391, 'V7');
INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE)

VALUES(323, 'BLDG98', #1/24/2006#, 322, 'V9'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(324, 'BLDG98', #1/24/2006#, 322, 'V22'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(325, 'BLDG99', #10/12/2005#, 323, 'V7'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(326, 'BLDG99', #10/12/2005#, 323, 'V15'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(327, 'BLDG100', #12/21/2005#, 320, 'V14'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(328, 'BLDG100', #12/21/2005#, 320, 'V22'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(329, 'BLDG100', #2/23/2006#, 115, 'V9'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(330, 'BLDG100', #2/23/2006#, 320, 'V9'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(331, 'BLDG100', #2/24/2006#, 115, 'V9'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(332, 'BLDG100', #2/24/2006#, 320, 'V9'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(333, 'BLDG101', #2/22/2006#, 115, 'V9'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(334, 'BLDG101', #2/22/2006#, 320, 'V9'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(335, 'BLDG101', #2/23/2006#, 115, 'V9'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(336, 'BLDG101', #2/23/2006#, 320, 'V9'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(337, 'BLDG102', #10/13/2005#, 131, 'V8'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(338, 'BLDG102', #10/13/2005#, 334, 'V8'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(339, 'BLDG103', #1/12/2006#, 119, 'V7'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(340, 'BLDG103', #1/12/2006#, 119, 'V22'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(341, 'BLDG104', #5/17/2006#, 233, 'V23'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(342, 'BLDG104', #5/17/2006#, 243, 'V23'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(343, 'BLDG104', #5/18/2006#, 233, 'V23'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(344, 'BLDG104', #5/18/2006#, 243, 'V23'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(345, 'BLDG105', #11/22/2005#, 309, 'V6'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(346, 'BLDG105', #11/22/2005#, 309, 'V22'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(347, 'BLDG106', #1/12/2006#, 166, 'V8'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(348, 'BLDG106', #1/12/2006#, 166, 'V22'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(349, 'BLDG107', #9/27/2005#, 206, 'V7'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(350, 'BLDG107', #9/27/2005#, 206, 'V20'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(351, 'BLDG108', #4/12/2006#, 322, 'V14'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(352, 'BLDG108', #4/12/2006#, 322, 'V22'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(353, 'BLDG109', #3/27/2006#, 17, 'V11'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(354, 'BLDG109', #3/27/2006#, 358, 'V11'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(355, 'BLDG109', #3/27/2006#, 127, 'V11'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(356, 'BLDG109', #3/27/2006#, 142, 'V11'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(357, 'BLDG109', #3/27/2006#, 144, 'V11'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(358, 'BLDG109', #3/27/2006#, 318, 'V11'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(359, 'BLDG109', #3/27/2006#, 129, 'V11'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(360, 'BLDG109', #3/28/2006#, 17, 'V11'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(361, 'BLDG109', #3/28/2006#, 115, 'V11'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(362, 'BLDG109', #3/28/2006#, 358, 'V11'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(363, 'BLDG109', #3/28/2006#, 334, 'V11'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(364, 'BLDG109', #3/28/2006#, 323, 'V11'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(365, 'BLDG109', #3/28/2006#, 318, 'V11'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(366, 'BLDG109', #3/28/2006#, 144, 'V11'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(367, 'BLDG109', #3/28/2006#, 142, 'V11'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(368, 'BLDG109', #3/28/2006#, 129, 'V11'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(369, 'BLDG109', #3/28/2006#, 127, 'V11'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(370, 'BLDG109', #3/29/2006#, 17, 'V11'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(371, 'BLDG109', #3/29/2006#, 323, 'V11'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(372, 'BLDG109', #3/29/2006#, 358, 'V11'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(373, 'BLDG109', #3/29/2006#, 334, 'V11'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(374, 'BLDG109', #3/29/2006#, 318, 'V11'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(375, 'BLDG109', #3/29/2006#, 144, 'V11'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(376, 'BLDG109', #3/29/2006#, 142, 'V11'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(377, 'BLDG109', #3/29/2006#, 129, 'V11'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(378, 'BLDG109', #3/29/2006#, 127, 'V11'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(379, 'BLDG109', #3/29/2006#, 115, 'V11'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(380, 'BLDG109', #3/30/2006#, 17, 'V11'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(381, 'BLDG109', #3/30/2006#, 129, 'V11'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(382, 'BLDG109', #3/30/2006#, 358, 'V11'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(383, 'BLDG109', #3/30/2006#, 334, 'V11'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(384, 'BLDG109', #3/30/2006#, 323, 'V11'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(385, 'BLDG109', #3/30/2006#, 318, 'V11'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(386, 'BLDG109', #3/30/2006#, 144, 'V11'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(387, 'BLDG109', #3/30/2006#, 142, 'V11'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(388, 'BLDG109', #3/30/2006#, 127, 'V11'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(389, 'BLDG109', #3/30/2006#, 115, 'V11'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(390, 'BLDG109', #3/31/2006#, 17, 'V11'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(391, 'BLDG109', #3/31/2006#, 318, 'V11'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(392, 'BLDG109', #3/31/2006#, 358, 'V11'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(393, 'BLDG109', #3/31/2006#, 144, 'V11'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(394, 'BLDG109', #3/31/2006#, 142, 'V11'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(395, 'BLDG109', #3/31/2006#, 129, 'V11'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(396, 'BLDG109', #3/31/2006#, 127, 'V11'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(397, 'BLDG109', #3/31/2006#, 115, 'V11'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(398, 'BLDG110', #11/7/2005#, 320, 'V22'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(399, 'BLDG110', #11/7/2005#, 320, 'V27'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(400, 'BLDG111', #10/12/2005#, 146, 'V8'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(401, 'BLDG111', #10/12/2005#, 146, 'V22'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(402, 'BLDG112', #2/14/2006#, 141, 'V8'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(403, 'BLDG112', #2/14/2006#, 141, 'V22'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(404, 'BLDG113', #2/15/2006#, 145, 'V9'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(405, 'BLDG113', #2/15/2006#, 233, 'V9'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(406, 'BLDG113', #2/16/2006#, 145, 'V8'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(407, 'BLDG113', #2/16/2006#, 233, 'V9'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(408, 'BLDG114', #1/26/2006#, 310, 'V6'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(409, 'BLDG114', #1/26/2006#, 310, 'V8');

INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) 
VALUES(410, 'BLDG115', #5/5/2006#, 36, 'V9');
INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE)

VALUES(411, 'BLDG115', #5/5/2006#, 376, 'V9');

INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) 
VALUES(412, 'BLDG115', #7/5/2006#, 36, 'V9');
INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE)

VALUES(413, 'BLDG115', #7/5/2006#, 376, 'V9');

INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) 
VALUES(414, 'BLDG115', #7/6/2006#, 36, 'V9');
INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE)

VALUES(415, 'BLDG115', #7/6/2006#, 376, 'V9'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(416, 'BLDG116', #4/12/2006#, 34, 'V4'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(417, 'BLDG116', #4/12/2006#, 34, 'V13'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(418, 'BLDG117', #12/27/2005#, 323, 'V13'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(419, 'BLDG117', #12/27/2005#, 323, 'V27'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(420, 'BLDG117', #2/17/2006#, 14, 'V3'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(421, 'BLDG117', #2/17/2006#, 323, 'V3'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(422, 'BLDG118', #1/31/2006#, 308, 'V17'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(423, 'BLDG118', #1/31/2006#, 308, 'V22'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(424, 'BLDG119', #5/9/2006#, 308, 'V8'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(425, 'BLDG119', #5/9/2006#, 391, 'V2'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(426, 'BLDG120', #11/8/2005#, 233, 'V28'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(427, 'BLDG120', #11/8/2005#, 233, 'V29'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(428, 'BLDG121', #12/15/2005#, 141, 'V8'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(429, 'BLDG121', #12/15/2005#, 141, 'V17'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(430, 'BLDG122', #5/23/2006#, 25, 'V2'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(431, 'BLDG122', #5/23/2006#, 391, 'V22'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(432, 'BLDG123', #4/20/2006#, 25, 'V14'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(433, 'BLDG123', #4/20/2006#, 391, 'V2'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(434, 'BLDG124', #4/17/2006#, 25, 'V22'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(435, 'BLDG124', #4/17/2006#, 391, 'V2'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(436, 'BLDG125', #4/18/2006#, 25, 'V22'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(437, 'BLDG125', #4/18/2006#, 391, 'V2'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(438, 'BLDG126', #10/18/2005#, 13, 'V19'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(439, 'BLDG126', #10/18/2005#, 13, 'V22'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(440, 'BLDG127', #5/10/2006#, 308, 'V8'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(441, 'BLDG127', #5/10/2006#, 391, 'V2'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(442, 'BLDG128', #1/10/2006#, 78, 'V11'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(443, 'BLDG128', #1/10/2006#, 233, 'V23'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(444, 'BLDG129', #11/8/2005#, 78, 'V9'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(445, 'BLDG129', #11/8/2005#, 325, 'V9'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(446, 'BLDG129', #11/9/2005#, 78, 'V9'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(447, 'BLDG129', #11/9/2005#, 325, 'V9'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(448, 'BLDG130', #10/18/2005#, 325, 'V28'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(449, 'BLDG130', #10/18/2005#, 334, 'V9'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(450, 'BLDG130', #11/9/2005#, 78, 'V9'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(451, 'BLDG130', #11/9/2005#, 334, 'V9'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(452, 'BLDG130', #11/9/2005#, 325, 'V9'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(453, 'BLDG130', #11/10/2005#, 78, 'V9'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(454, 'BLDG130', #11/10/2005#, 325, 'V9'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(455, 'BLDG130', #11/10/2005#, 334, 'V6'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(456, 'BLDG131', #5/30/2006#, 50, 'V3'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(457, 'BLDG131', #5/30/2006#, 50, 'V8'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(458, 'BLDG132', #5/24/2006#, 31, 'V6'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(459, 'BLDG132', #5/24/2006#, 31, 'V22'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(460, 'BLDG133', #2/7/2006#, 114, 'V17'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(461, 'BLDG133', #2/7/2006#, 114, 'V22'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(462, 'BLDG134', #6/21/2006#, 62, 'V9'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(463, 'BLDG134', #6/21/2006#, 309, 'V28'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(464, 'BLDG135', #5/10/2006#, 78, 'V9'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(465, 'BLDG135', #5/10/2006#, 325, 'V9'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(466, 'BLDG135', #5/11/2006#, 78, 'V9'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(467, 'BLDG135', #5/11/2006#, 325, 'V9'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(468, 'BLDG136', #12/15/2005#, 129, 'V23'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(469, 'BLDG136', #12/15/2005#, 233, 'V23'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(470, 'BLDG137', #5/17/2006#, 129, 'V6'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(471, 'BLDG137', #5/17/2006#, 129, 'V8'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(472, 'BLDG138', #3/8/2006#, 336, 'V8'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(473, 'BLDG138', #3/8/2006#, 336, 'V22'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(474, 'BLDG139', #3/20/2006#, 129, 'V14'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(475, 'BLDG139', #3/20/2006#, 129, 'V19'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(476, 'BLDG140', #3/22/2006#, 52, 'V29'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(477, 'BLDG140', #3/22/2006#, 334, 'V29'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(478, 'BLDG140', #3/23/2006#, 52, 'V29'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(479, 'BLDG140', #3/23/2006#, 334, 'V29');

INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) 
VALUES(480, 'BLDG141', #1/4/2006#, 78, 'V22');
INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE)

VALUES(481, 'BLDG141', #1/4/2006#, 334, 'V22');

INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) 
VALUES(482, 'BLDG142', #9/7/2005#, 52, 'V8');
INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) 
VALUES(483, 'BLDG142', #9/7/2005#, 52, 'V10');
INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) 
VALUES(484, 'BLDG143', #5/4/2006#, 78, 'V28');
INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE)

VALUES(485, 'BLDG143', #5/4/2006#, 334, 'V29'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(486, 'BLDG144', #5/11/2006#, 50, 'V3'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(487, 'BLDG144', #5/11/2006#, 50, 'V8'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(488, 'BLDG144', #5/12/2006#, 50, 'V7'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(489, 'BLDG144', #5/12/2006#, 50, 'V8'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(490, 'BLDG145', #10/4/2005#, 119, 'V16'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(491, 'BLDG145', #10/4/2005#, 119, 'V19');

INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) 
VALUES(492, 'BLDG146', #6/6/2006#, 34, 'V7');
INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) 
VALUES(493, 'BLDG146', #6/6/2006#, 34, 'V8');
INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE)

VALUES(494, 'BLDG147', #9/14/2005#, 36, 'V28'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(495, 'BLDG147', #9/14/2005#, 324, 'V5'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(496, 'BLDG148', #9/14/2005#, 322, 'V14'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(497, 'BLDG148', #9/14/2005#, 322, 'V15'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(498, 'BLDG149', #6/20/2006#, 123, 'V8'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(499, 'BLDG149', #6/20/2006#, 123, 'V22'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(500, 'BLDG150', #5/16/2006#, 12, 'V18'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(501, 'BLDG150', #5/16/2006#, 318, 'V18'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(502, 'BLDG151', #4/17/2006#, 62, 'V23'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(503, 'BLDG151', #4/17/2006#, 142, 'V23'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(504, 'BLDG151', #4/17/2006#, 318, 'V23'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(505, 'BLDG151', #4/17/2006#, 154, 'V2'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(506, 'BLDG151', #4/18/2006#, 62, 'V23'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(507, 'BLDG151', #4/18/2006#, 318, 'V23'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(508, 'BLDG151', #4/18/2006#, 142, 'V23'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(509, 'BLDG151', #4/18/2006#, 154, 'V2'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(510, 'BLDG151', #4/19/2006#, 62, 'V22'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(511, 'BLDG151', #4/19/2006#, 318, 'V23'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(512, 'BLDG151', #4/19/2006#, 154, 'V2'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(513, 'BLDG151', #4/19/2006#, 142, 'V23'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(514, 'BLDG152', #10/20/2005#, 320, 'V14'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(515, 'BLDG152', #10/20/2005#, 320, 'V15'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(516, 'BLDG153', #7/11/2006#, 334, 'V8'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(517, 'BLDG153', #7/11/2006#, 334, 'V9');

INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) 
VALUES(518, 'BLDG154', #2/1/2006#, 53, 'V23');
INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE)

VALUES(519, 'BLDG154', #2/1/2006#, 323, 'V23');

INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) 
VALUES(520, 'BLDG154', #2/2/2006#, 53, 'V23');
INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE)

VALUES(521, 'BLDG154', #2/2/2006#, 323, 'V23');

INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) 
VALUES(522, 'BLDG154', #2/3/2006#, 53, 'V23');
INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE)

VALUES(523, 'BLDG154', #2/3/2006#, 323, 'V27'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(524, 'BLDG154', #2/3/2006#, 323, 'V23'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(525, 'BLDG154', #7/12/2006#, 53, 'V24'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(526, 'BLDG154', #7/12/2006#, 139, 'V26'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(527, 'BLDG154', #7/12/2006#, 141, 'V25'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(528, 'BLDG154', #7/13/2006#, 53, 'V24'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(529, 'BLDG154', #7/13/2006#, 139, 'V26'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(530, 'BLDG154', #7/13/2006#, 141, 'V25'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(531, 'BLDG154', #7/14/2006#, 53, 'V24'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(532, 'BLDG154', #7/14/2006#, 141, 'V25'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(533, 'BLDG154', #7/14/2006#, 139, 'V26'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(534, 'BLDG155', #9/14/2005#, 323, 'V7'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(535, 'BLDG155', #9/14/2005#, 323, 'V27'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(536, 'BLDG156', #9/12/2005#, 165, 'V6'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(537, 'BLDG156', #9/12/2005#, 165, 'V8'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(538, 'BLDG157', #10/27/2005#, 32, 'V13'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(539, 'BLDG157', #10/27/2005#, 310, 'V13'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(540, 'BLDG158', #11/2/2005#, 320, 'V14'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(541, 'BLDG158', #11/2/2005#, 320, 'V15'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(542, 'BLDG158', #2/20/2006#, 115, 'V9'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(543, 'BLDG158', #2/20/2006#, 320, 'V9'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(544, 'BLDG158', #2/21/2006#, 115, 'V9'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(545, 'BLDG158', #2/21/2006#, 320, 'V9'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(546, 'BLDG158', #4/26/2006#, 320, 'V3'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(547, 'BLDG158', #4/26/2006#, 320, 'V17'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(548, 'BLDG159', #3/14/2006#, 336, 'V14'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(549, 'BLDG159', #3/14/2006#, 336, 'V22'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(550, 'BLDG160', #3/15/2006#, 336, 'V8'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(551, 'BLDG160', #3/15/2006#, 336, 'V14'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(552, 'BLDG160', #8/24/2006#, 336, 'V8'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(553, 'BLDG160', #8/24/2006#, 336, 'V27'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(554, 'BLDG161', #1/5/2006#, 253, 'V6'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(555, 'BLDG161', #1/5/2006#, 253, 'V17'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(556, 'BLDG162', #3/13/2006#, 141, 'V9'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(557, 'BLDG162', #3/13/2006#, 141, 'V22'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(558, 'BLDG163', #6/29/2006#, 78, 'V6'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(559, 'BLDG163', #6/29/2006#, 78, 'V9'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(560, 'BLDG164', #12/12/2005#, 76, 'V9'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(561, 'BLDG164', #12/12/2005#, 322, 'V9'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(562, 'BLDG164', #12/13/2005#, 76, 'V9'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(563, 'BLDG164', #12/13/2005#, 322, 'V22'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(564, 'BLDG164', #12/13/2005#, 322, 'V9'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(565, 'BLDG165', #1/11/2006#, 166, 'V8'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(566, 'BLDG165', #1/11/2006#, 166, 'V22'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(567, 'BLDG166', #5/24/2006#, 141, 'V17'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(568, 'BLDG166', #5/24/2006#, 141, 'V22'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(569, 'BLDG167', #1/11/2006#, 165, 'V8'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(570, 'BLDG167', #1/11/2006#, 165, 'V22'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(571, 'BLDG168', #10/18/2005#, 244, 'V14'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(572, 'BLDG168', #10/18/2005#, 309, 'V14'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(573, 'BLDG169', #1/31/2006#, 144, 'V8'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(574, 'BLDG169', #1/31/2006#, 144, 'V22'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(575, 'BLDG170', #6/6/2006#, 123, 'V18'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(576, 'BLDG170', #6/6/2006#, 383, 'V18'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(577, 'BLDG171', #1/17/2006#, 263, 'V6'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(578, 'BLDG171', #1/17/2006#, 263, 'V9'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(579, 'BLDG172', #8/10/2006#, 233, 'V9'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(580, 'BLDG172', #8/10/2006#, 376, 'V9'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(581, 'BLDG172', #8/11/2006#, 233, 'V9'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(582, 'BLDG172', #8/11/2006#, 376, 'V9'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(583, 'BLDG173', #4/4/2006#, 131, 'V13'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(584, 'BLDG173', #4/4/2006#, 144, 'V13'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(585, 'BLDG174', #7/4/2006#, 383, 'V4'); INSERT INTO VISITS (VISITID, BLDGCODE, VISITDATE, EMPID, VISITCODE) VALUES(586, 'BLDG174', #7/4/2006#, 383, 'V8'); Received on Sat Aug 05 2006 - 07:40:40 CDT