December 29, 2009 at 10:02 am
I have two tables used for logging file actions on a server.
The first table logs when a file is opened and closed(START and STOP).
SELECT [id], [fi_id], [fi_num_locks], [fi_pathname], [fi_permission], [fi_username], [action], [dttm] FROM [REPORTING_1].[dbo].[file_info]
The second table contains events that occured to files.
SELECT [id], [FullPath], [ChangeType], [dttm] FROM [REPORTING_1].[dbo].[file_modify]
The [REPORTING_1].[dbo].[file_modify].[FullPath] should equal [REPORTING_1].[dbo].[file_info].[fi_pathname] AND [REPORTING_1].[dbo].[file_modify].[dttm] should be between a START and STOP event in [REPORTING_1].[dbo].[file_info]
I really am not sure where to start here. I eventually want to just put this in a view.
Thanks for any help.
December 29, 2009 at 10:56 am
Read the article below and post your question accordingly, it would result in better, quicker and tested replies.
http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
December 29, 2009 at 12:45 pm
I do apologize for my hasty post.
I am trying to find the #file_info.[fi_username] that caused the #file_modify.[ChangeType] from the data contained in the #file_info
It may be very general and may not be exact but I think it's a good place to start. I apologize for the excessive data, I just felt it would be necessary to make an accurate query.
--===== If the test tables already exist, drop them
IF OBJECT_ID('TempDB..#file_info','U') IS NOT NULL
DROP TABLE #file_info
IF OBJECT_ID('TempDB..#file_modify','U') IS NOT NULL
DROP TABLE #file_modify
--===== Create the test table for opening and closings(START and STOP) performed on the file with
CREATE TABLE #file_info (
[id] [bigint] NOT NULL ,
[fi_id] [bigint] NOT NULL ,
[fi_num_locks] [bigint] NOT NULL ,
[fi_pathname] [varchar] (500) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[fi_permission] [varchar] (500) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[fi_username] [varchar] (500) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[action] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[dttm] [datetime] NOT NULL ,
CONSTRAINT [PK_file_info] PRIMARY KEY CLUSTERED
(
[id]
) ON [PRIMARY]
) ON [PRIMARY]
--===== Create the test table for actions performed on the file with
CREATE TABLE #file_modify(
[id] [bigint] NOT NULL ,
[FullPath] [varchar] (5000) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[ChangeType] [varchar] (500) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[dttm] [datetime] NOT NULL ,
CONSTRAINT [PK_file_modify] PRIMARY KEY CLUSTERED
(
[id]
) ON [PRIMARY]
) ON [PRIMARY]
--===== All Inserts into the IDENTITY column
SET IDENTITY_INSERT #file_info ON
SET IDENTITY_INSERT #file_modify ON
--===== Insert the test data into the test tables
INSERT INTO #file_info([id], [fi_id], [fi_num_locks], [fi_pathname], [fi_permission], [fi_username], [action], [dttm])
SELECT '53852','163536','0','D:\Users\rbutler\Cover Letter-Resume-07.doc','1','RBUTLER','START','Dec 12 2008 8:00AM' UNION ALL
SELECT '53853','163537','0','D:\Users\rbutler\Cover Letter-Resume-07.doc','1','RBUTLER','START','Dec 12 2008 8:00AM' UNION ALL
SELECT '53854','163536','0','D:\Users\rbutler\Cover Letter-Resume-07.doc','1','RBUTLER','STOP','Dec 12 2008 8:00AM' UNION ALL
SELECT '53855','163537','0','D:\Users\rbutler\Cover Letter-Resume-07.doc','1','RBUTLER','STOP','Dec 12 2008 8:00AM' UNION ALL
SELECT '53861','163541','0','D:\Users\rbutler\Cust Action Report.doc','1','RBUTLER','START','Dec 12 2008 8:00AM' UNION ALL
SELECT '53863','163541','0','D:\Users\rbutler\Cust Action Report.doc','1','RBUTLER','STOP','Dec 12 2008 8:00AM' UNION ALL
SELECT '54057','166447','0','D:\QuickBooks\Inventory\Inventory Control December 08.xls','33','WSUN','START','Dec 12 2008 8:14AM' UNION ALL
SELECT '54058','166449','0','D:\QuickBooks\Inventory\Inventory Control December 08.xls','35','WSUN','START','Dec 12 2008 8:14AM' UNION ALL
SELECT '54059','166447','0','D:\QuickBooks\Inventory\Inventory Control December 08.xls','33','WSUN','STOP','Dec 12 2008 8:14AM' UNION ALL
SELECT '54060','166451','0','D:\QuickBooks\Inventory\Inventory Control December 08.xls','0','WSUN','START','Dec 12 2008 8:14AM' UNION ALL
SELECT '54064','166451','0','D:\QuickBooks\Inventory\Inventory Control December 08.xls','0','WSUN','STOP','Dec 12 2008 8:14AM' UNION ALL
SELECT '54394','166746','0','D:\MTR\11-15-2008\08-11-15_WDI--LIST1\2008-11-15 PACKING LIST-WDI.xls','1','WSUN','START','Dec 12 2008 8:20AM' UNION ALL
SELECT '54395','166748','0','D:\MTR\11-15-2008\08-11-15_WDI--LIST1\2008-11-15 PACKING LIST-WDI.xls','35','WSUN','START','Dec 12 2008 8:20AM' UNION ALL
SELECT '54396','166746','0','D:\MTR\11-15-2008\08-11-15_WDI--LIST1\2008-11-15 PACKING LIST-WDI.xls','1','WSUN','STOP','Dec 12 2008 8:20AM' UNION ALL
SELECT '54400','166748','3','D:\MTR\11-15-2008\08-11-15_WDI--LIST1\2008-11-15 PACKING LIST-WDI.xls','35','WSUN','STOP','Dec 12 2008 8:21AM' UNION ALL
SELECT '54401','166757','0','D:\MTR\11-15-2008\08-11-15_WDI--LIST1\2008-11-15 PACKING LIST-WDI.xls','1','WSUN','START','Dec 12 2008 8:21AM' UNION ALL
SELECT '54412','166757','0','D:\MTR\11-15-2008\08-11-15_WDI--LIST1\2008-11-15 PACKING LIST-WDI.xls','1','WSUN','STOP','Dec 12 2008 8:21AM' UNION ALL
SELECT '55510','167193','0','D:\QuickBooks\Inventory\Inventory Control December 08.xls','33','WSUN','START','Dec 12 2008 8:31AM' UNION ALL
SELECT '55511','167196','0','D:\QuickBooks\Inventory\Inventory Control December 08.xls','32','WSUN','START','Dec 12 2008 8:31AM' UNION ALL
SELECT '55512','166449','0','D:\QuickBooks\Inventory\Inventory Control December 08.xls','35','WSUN','STOP','Dec 12 2008 8:31AM' UNION ALL
SELECT '55513','167193','0','D:\QuickBooks\Inventory\Inventory Control December 08.xls','33','WSUN','STOP','Dec 12 2008 8:31AM' UNION ALL
SELECT '55514','167200','0','D:\QuickBooks\Inventory\Inventory Control December 08.xls','0','WSUN','START','Dec 12 2008 8:31AM' UNION ALL
SELECT '55516','167196','0','D:\QuickBooks\Inventory\Inventory Control December 08.xls','32','WSUN','STOP','Dec 12 2008 8:31AM' UNION ALL
SELECT '55517','167201','0','D:\QuickBooks\Inventory\Inventory Control December 08.xls','33','WSUN','START','Dec 12 2008 8:31AM' UNION ALL
SELECT '55518','167200','0','D:\QuickBooks\Inventory\Inventory Control December 08.xls','0','WSUN','STOP','Dec 12 2008 8:31AM' UNION ALL
SELECT '55519','167203','0','D:\QuickBooks\Inventory\Inventory Control December 08.xls','33','WSUN','START','Dec 12 2008 8:31AM' UNION ALL
SELECT '55520','167201','0','D:\QuickBooks\Inventory\Inventory Control December 08.xls','33','WSUN','STOP','Dec 12 2008 8:31AM' UNION ALL
SELECT '55521','167205','0','D:\QuickBooks\Inventory\Inventory Control December 08.xls','17','WSUN','START','Dec 12 2008 8:31AM' UNION ALL
SELECT '55523','167203','0','D:\QuickBooks\Inventory\Inventory Control December 08.xls','33','WSUN','STOP','Dec 12 2008 8:31AM' UNION ALL
SELECT '55524','167205','0','D:\QuickBooks\Inventory\Inventory Control December 08.xls','17','WSUN','STOP','Dec 12 2008 8:31AM' UNION ALL
SELECT '55526','167216','0','D:\QuickBooks\Inventory\Inventory Control December 08.xls','33','WSUN','START','Dec 12 2008 8:31AM' UNION ALL
SELECT '55527','167218','0','D:\QuickBooks\Inventory\Inventory Control December 08.xls','35','WSUN','START','Dec 12 2008 8:31AM' UNION ALL
SELECT '55528','167216','0','D:\QuickBooks\Inventory\Inventory Control December 08.xls','33','WSUN','STOP','Dec 12 2008 8:31AM' UNION ALL
SELECT '55712','167394','0','D:\QuickBooks\WDI FORMS\Credit Card - Employee Forms\Expense Report Form - BLANK.xls','1','MCOLE','START','Dec 12 2008 8:35AM' UNION ALL
SELECT '55713','167406','0','D:\QuickBooks\WDI FORMS\Credit Card - Employee Forms\Expense Report Form - BLANK.xls','1','MCOLE','START','Dec 12 2008 8:35AM' UNION ALL
SELECT '55714','167394','0','D:\QuickBooks\WDI FORMS\Credit Card - Employee Forms\Expense Report Form - BLANK.xls','1','MCOLE','STOP','Dec 12 2008 8:35AM' UNION ALL
SELECT '55715','167416','0','D:\QuickBooks\WDI FORMS\Credit Card - Employee Forms\Credit Card Agreement.doc','1','MCOLE','START','Dec 12 2008 8:35AM' UNION ALL
SELECT '55716','167422','0','D:\QuickBooks\WDI FORMS\Credit Card - Employee Forms\Credit Card Agreement.doc','1','MCOLE','START','Dec 12 2008 8:35AM' UNION ALL
SELECT '55717','167416','0','D:\QuickBooks\WDI FORMS\Credit Card - Employee Forms\Credit Card Agreement.doc','1','MCOLE','STOP','Dec 12 2008 8:35AM' UNION ALL
SELECT '55718','167432','0','D:\QuickBooks\WDI FORMS\Credit Card - Employee Forms\Credit Card Documentation Requirements.doc','1','MCOLE','START','Dec 12 2008 8:35AM' UNION ALL
SELECT '55719','167438','0','D:\QuickBooks\WDI FORMS\Credit Card - Employee Forms\Credit Card Documentation Requirements.doc','1','MCOLE','START','Dec 12 2008 8:35AM' UNION ALL
SELECT '55720','167432','0','D:\QuickBooks\WDI FORMS\Credit Card - Employee Forms\Credit Card Documentation Requirements.doc','1','MCOLE','STOP','Dec 12 2008 8:35AM' UNION ALL
SELECT '55721','167454','0','D:\QuickBooks\WDI FORMS\Credit Card - Employee Forms\Credit Card expense reports.doc','1','MCOLE','START','Dec 12 2008 8:35AM' UNION ALL
SELECT '55722','167456','0','D:\QuickBooks\WDI FORMS\Credit Card - Employee Forms\Credit Card Documentation Requirements.doc','0','MCOLE','START','Dec 12 2008 8:35AM' UNION ALL
SELECT '55723','167460','0','D:\QuickBooks\WDI FORMS\Credit Card - Employee Forms\Credit Card expense reports.doc','0','MCOLE','START','Dec 12 2008 8:35AM' UNION ALL
SELECT '55732','167406','0','D:\QuickBooks\WDI FORMS\Credit Card - Employee Forms\Expense Report Form - BLANK.xls','1','MCOLE','STOP','Dec 12 2008 8:35AM' UNION ALL
SELECT '55733','167422','0','D:\QuickBooks\WDI FORMS\Credit Card - Employee Forms\Credit Card Agreement.doc','1','MCOLE','STOP','Dec 12 2008 8:35AM' UNION ALL
SELECT '55734','167438','0','D:\QuickBooks\WDI FORMS\Credit Card - Employee Forms\Credit Card Documentation Requirements.doc','1','MCOLE','STOP','Dec 12 2008 8:35AM' UNION ALL
SELECT '55735','167454','0','D:\QuickBooks\WDI FORMS\Credit Card - Employee Forms\Credit Card expense reports.doc','1','MCOLE','STOP','Dec 12 2008 8:35AM' UNION ALL
SELECT '55736','167456','0','D:\QuickBooks\WDI FORMS\Credit Card - Employee Forms\Credit Card Documentation Requirements.doc','0','MCOLE','STOP','Dec 12 2008 8:35AM' UNION ALL
SELECT '55737','167460','0','D:\QuickBooks\WDI FORMS\Credit Card - Employee Forms\Credit Card expense reports.doc','0','MCOLE','STOP','Dec 12 2008 8:35AM' UNION ALL
SELECT '57461','168727','0','D:\Users\Wsun\Xunlei\ENGote.xls','35','WSUN','START','Dec 12 2008 9:20AM' UNION ALL
SELECT '57462','168728','0','D:\Users\Wsun\Xunlei\ENGote.xls','0','WSUN','START','Dec 12 2008 9:20AM' UNION ALL
SELECT '57472','168728','0','D:\Users\Wsun\Xunlei\ENGote.xls','0','WSUN','STOP','Dec 12 2008 9:20AM' UNION ALL
SELECT '59258','169992','3','D:\Users\mcole\invoice.xls','35','MCOLE','START','Dec 12 2008 9:49AM' UNION ALL
SELECT '59265','169992','3','D:\Users\mcole\invoice.xls','35','MCOLE','STOP','Dec 12 2008 9:49AM' UNION ALL
SELECT '59285','170017','0','D:\Users\mcole\invoice.xls','1','MCOLE','START','Dec 12 2008 9:49AM' UNION ALL
SELECT '59287','170017','0','D:\Users\mcole\invoice.xls','1','MCOLE','STOP','Dec 12 2008 9:49AM' UNION ALL
SELECT '59321','170077','0','D:\QuickBooks\Inventory\Inventory Control December 08.xls','33','WSUN','START','Dec 12 2008 9:51AM' UNION ALL
SELECT '59322','167218','0','D:\QuickBooks\Inventory\Inventory Control December 08.xls','35','WSUN','STOP','Dec 12 2008 9:51AM' UNION ALL
SELECT '59325','170081','0','D:\QuickBooks\Inventory\Inventory Control December 08.xls','17','WSUN','START','Dec 12 2008 9:51AM' UNION ALL
SELECT '59327','170077','0','D:\QuickBooks\Inventory\Inventory Control December 08.xls','33','WSUN','STOP','Dec 12 2008 9:51AM' UNION ALL
SELECT '59329','170089','0','D:\QuickBooks\Inventory\Inventory Control December 08.xls','33','WSUN','START','Dec 12 2008 9:51AM' UNION ALL
SELECT '59331','170092','0','D:\QuickBooks\Inventory\Inventory Control December 08.xls','33','WSUN','START','Dec 12 2008 9:51AM' UNION ALL
SELECT '59332','170081','0','D:\QuickBooks\Inventory\Inventory Control December 08.xls','17','WSUN','STOP','Dec 12 2008 9:51AM' UNION ALL
SELECT '59334','170089','0','D:\QuickBooks\Inventory\Inventory Control December 08.xls','33','WSUN','STOP','Dec 12 2008 9:51AM' UNION ALL
SELECT '59335','170094','0','D:\QuickBooks\Inventory\Inventory Control December 08.xls','35','WSUN','START','Dec 12 2008 9:51AM' UNION ALL
SELECT '59340','170092','0','D:\QuickBooks\Inventory\Inventory Control December 08.xls','33','WSUN','STOP','Dec 12 2008 9:51AM' UNION ALL
SELECT '60755','170906','0','D:\Human Resources\Payroll tracker.xls','35','SROANE','START','Dec 12 2008 10:25AM' UNION ALL
SELECT '60756','170907','0','D:\Human Resources\Payroll tracker.xls','0','SROANE','START','Dec 12 2008 10:25AM' UNION ALL
SELECT '60769','170907','0','D:\Human Resources\Payroll tracker.xls','0','SROANE','STOP','Dec 12 2008 10:25AM' UNION ALL
SELECT '61674','171265','0','D:\Human Resources\Payroll tracker.xls','35','SROANE','START','Dec 12 2008 10:25AM' UNION ALL
SELECT '61675','170906','0','D:\Human Resources\Payroll tracker.xls','35','SROANE','STOP','Dec 12 2008 10:25AM' UNION ALL
SELECT '61677','171265','3','D:\Human Resources\Payroll tracker.xls','35','SROANE','STOP','Dec 12 2008 10:25AM' UNION ALL
SELECT '61778','171302','0','D:\QuickBooks\Inventory\Inventory Control November 08.xls','33','WSUN','START','Dec 12 2008 10:30AM' UNION ALL
SELECT '61779','171304','0','D:\QuickBooks\Inventory\Inventory Control November 08.xls','35','WSUN','START','Dec 12 2008 10:30AM' UNION ALL
SELECT '61780','171302','0','D:\QuickBooks\Inventory\Inventory Control November 08.xls','33','WSUN','STOP','Dec 12 2008 10:30AM' UNION ALL
SELECT '61781','171306','0','D:\QuickBooks\Inventory\Inventory Control November 08.xls','0','WSUN','START','Dec 12 2008 10:30AM' UNION ALL
SELECT '61784','171306','0','D:\QuickBooks\Inventory\Inventory Control November 08.xls','0','WSUN','STOP','Dec 12 2008 10:30AM' UNION ALL
SELECT '61807','171340','0','D:\QuickBooks\Inventory\Inventory Control November 08.xls','33','WSUN','START','Dec 12 2008 10:31AM' UNION ALL
SELECT '61808','171342','0','D:\QuickBooks\Inventory\Inventory Control November 08.xls','33','WSUN','START','Dec 12 2008 10:31AM' UNION ALL
SELECT '61809','171304','0','D:\QuickBooks\Inventory\Inventory Control November 08.xls','35','WSUN','STOP','Dec 12 2008 10:31AM' UNION ALL
SELECT '61810','171340','0','D:\QuickBooks\Inventory\Inventory Control November 08.xls','33','WSUN','STOP','Dec 12 2008 10:31AM' UNION ALL
SELECT '61813','171342','0','D:\QuickBooks\Inventory\Inventory Control November 08.xls','33','WSUN','STOP','Dec 12 2008 10:31AM' UNION ALL
SELECT '61814','171349','0','D:\QuickBooks\Inventory\Inventory Control November 08.xls','33','WSUN','START','Dec 12 2008 10:31AM' UNION ALL
SELECT '61818','171351','0','D:\QuickBooks\Inventory\Inventory Control November 08.xls','33','WSUN','START','Dec 12 2008 10:31AM' UNION ALL
SELECT '61819','171349','0','D:\QuickBooks\Inventory\Inventory Control November 08.xls','33','WSUN','STOP','Dec 12 2008 10:31AM' UNION ALL
SELECT '61820','171353','0','D:\QuickBooks\Inventory\Inventory Control November 08.xls','17','WSUN','START','Dec 12 2008 10:31AM' UNION ALL
SELECT '61822','171351','0','D:\QuickBooks\Inventory\Inventory Control November 08.xls','33','WSUN','STOP','Dec 12 2008 10:31AM' UNION ALL
SELECT '61824','171361','0','D:\QuickBooks\Inventory\Inventory Control November 08.xls','33','WSUN','START','Dec 12 2008 10:31AM' UNION ALL
SELECT '61826','171364','0','D:\QuickBooks\Inventory\Inventory Control November 08.xls','33','WSUN','START','Dec 12 2008 10:31AM' UNION ALL
SELECT '61827','171353','0','D:\QuickBooks\Inventory\Inventory Control November 08.xls','17','WSUN','STOP','Dec 12 2008 10:31AM' UNION ALL
SELECT '61829','171361','0','D:\QuickBooks\Inventory\Inventory Control November 08.xls','33','WSUN','STOP','Dec 12 2008 10:31AM' UNION ALL
SELECT '61830','171366','0','D:\QuickBooks\Inventory\Inventory Control November 08.xls','35','WSUN','START','Dec 12 2008 10:31AM' UNION ALL
SELECT '61831','171364','0','D:\QuickBooks\Inventory\Inventory Control November 08.xls','33','WSUN','STOP','Dec 12 2008 10:31AM' UNION ALL
SELECT '61861','171392','0','D:\QuickBooks\Inventory\Inventory Control November 08.xls','0','WSUN','START','Dec 12 2008 10:31AM' UNION ALL
SELECT '61866','171366','0','D:\QuickBooks\Inventory\Inventory Control November 08.xls','35','WSUN','STOP','Dec 12 2008 10:32AM' UNION ALL
SELECT '61867','171392','0','D:\QuickBooks\Inventory\Inventory Control November 08.xls','0','WSUN','STOP','Dec 12 2008 10:32AM' UNION ALL
SELECT '63229','168727','0','D:\Users\Wsun\Xunlei\ENGote.xls','35','WSUN','STOP','Dec 12 2008 11:01AM' UNION ALL
SELECT '63230','172341','3','D:\Users\Wsun\Xunlei\ENGote.xls','35','WSUN','START','Dec 12 2008 11:01AM' UNION ALL
SELECT '63538','172341','3','D:\Users\Wsun\Xunlei\ENGote.xls','35','WSUN','STOP','Dec 12 2008 11:07AM' UNION ALL
SELECT '63539','172518','0','D:\Users\Wsun\Xunlei\ENGote.xls','17','WSUN','START','Dec 12 2008 11:07AM' UNION ALL
SELECT '63541','172525','0','D:\Users\Wsun\Xunlei\ENGote.xls','35','WSUN','START','Dec 12 2008 11:07AM' UNION ALL
SELECT '63542','172518','0','D:\Users\Wsun\Xunlei\ENGote.xls','17','WSUN','STOP','Dec 12 2008 11:07AM' UNION ALL
SELECT '63544','172525','3','D:\Users\Wsun\Xunlei\ENGote.xls','35','WSUN','STOP','Dec 12 2008 11:07AM' UNION ALL
SELECT '63551','172534','0','D:\Users\Wsun\Xunlei\ENGote.xls','0','WSUN','START','Dec 12 2008 11:07AM' UNION ALL
SELECT '63552','172534','0','D:\Users\Wsun\Xunlei\ENGote.xls','0','WSUN','STOP','Dec 12 2008 11:07AM' UNION ALL
SELECT '63698','172633','0','D:\Human Resources\401K\401K Introductory letter.doc','35','SROANE','START','Dec 12 2008 11:17AM' UNION ALL
SELECT '63700','172635','0','D:\Human Resources\401K\401K Introductory letter.doc','0','SROANE','START','Dec 12 2008 11:17AM' UNION ALL
SELECT '63706','172635','0','D:\Human Resources\401K\401K Introductory letter.doc','0','SROANE','STOP','Dec 12 2008 11:17AM' UNION ALL
SELECT '63714','172643','0','D:\Human Resources\401K\401K Introductory letter.doc','0','SROANE','START','Dec 12 2008 11:18AM' UNION ALL
SELECT '63717','172633','0','D:\Human Resources\401K\401K Introductory letter.doc','35','SROANE','STOP','Dec 12 2008 11:18AM' UNION ALL
SELECT '63718','172643','0','D:\Human Resources\401K\401K Introductory letter.doc','0','SROANE','STOP','Dec 12 2008 11:18AM' UNION ALL
SELECT '63827','172726','0','D:\Human Resources\Trackers - 2008.xls','35','SROANE','START','Dec 12 2008 11:22AM' UNION ALL
SELECT '63828','172727','0','D:\Human Resources\Trackers - 2008.xls','0','SROANE','START','Dec 12 2008 11:22AM' UNION ALL
SELECT '63841','172727','0','D:\Human Resources\Trackers - 2008.xls','0','SROANE','STOP','Dec 12 2008 11:22AM' UNION ALL
SELECT '63844','172726','0','D:\Human Resources\Trackers - 2008.xls','35','SROANE','STOP','Dec 12 2008 11:22AM' UNION ALL
SELECT '63846','172740','3','D:\Human Resources\Trackers - 2008.xls','35','SROANE','START','Dec 12 2008 11:22AM' UNION ALL
SELECT '64038','172740','3','D:\Human Resources\Trackers - 2008.xls','35','SROANE','STOP','Dec 12 2008 11:24AM' UNION ALL
SELECT '70732','176439','0','D:\Users\mcole\WDI COLLECTIONS\report 11-24.xls','1','MCOLE','START','Dec 12 2008 1:31PM' UNION ALL
SELECT '70734','176441','0','D:\Users\mcole\WDI COLLECTIONS\report 11-24.xls','35','MCOLE','START','Dec 12 2008 1:31PM' UNION ALL
SELECT '70735','176439','0','D:\Users\mcole\WDI COLLECTIONS\report 11-24.xls','1','MCOLE','STOP','Dec 12 2008 1:31PM' UNION ALL
SELECT '70736','176442','0','D:\Users\mcole\WDI COLLECTIONS\report 11-24.xls','0','MCOLE','START','Dec 12 2008 1:31PM' UNION ALL
SELECT '70742','176441','0','D:\Users\mcole\WDI COLLECTIONS\report 11-24.xls','35','MCOLE','STOP','Dec 12 2008 1:31PM' UNION ALL
SELECT '70743','176442','0','D:\Users\mcole\WDI COLLECTIONS\report 11-24.xls','0','MCOLE','STOP','Dec 12 2008 1:31PM' UNION ALL
SELECT '70744','176447','0','D:\Users\mcole\WDI COLLECTIONS\report 11-24.xls','1','MCOLE','START','Dec 12 2008 1:31PM' UNION ALL
SELECT '70746','176449','0','D:\Users\mcole\WDI COLLECTIONS\report 11-24.xls','35','MCOLE','START','Dec 12 2008 1:31PM' UNION ALL
SELECT '70747','176447','0','D:\Users\mcole\WDI COLLECTIONS\report 11-24.xls','1','MCOLE','STOP','Dec 12 2008 1:31PM' UNION ALL
SELECT '70748','176450','0','D:\Users\mcole\WDI COLLECTIONS\report 11-24.xls','0','MCOLE','START','Dec 12 2008 1:31PM' UNION ALL
SELECT '70757','176450','0','D:\Users\mcole\WDI COLLECTIONS\report 11-24.xls','0','MCOLE','STOP','Dec 12 2008 1:31PM' UNION ALL
SELECT '70809','176628','0','D:\QuickBooks\COLLECTION\Weatherford\WEATHERFORD ACCOUNT STATUS.xls','1','JFRANK','START','Dec 12 2008 1:36PM' UNION ALL
SELECT '70810','176630','0','D:\QuickBooks\COLLECTION\Weatherford\WEATHERFORD ACCOUNT STATUS.xls','33','JFRANK','START','Dec 12 2008 1:36PM' UNION ALL
SELECT '70811','176628','0','D:\QuickBooks\COLLECTION\Weatherford\WEATHERFORD ACCOUNT STATUS.xls','1','JFRANK','STOP','Dec 12 2008 1:36PM' UNION ALL
SELECT '70812','176632','0','D:\QuickBooks\COLLECTION\Weatherford\WEATHERFORD ACCOUNT STATUS.xls','35','JFRANK','START','Dec 12 2008 1:36PM' UNION ALL
SELECT '70813','176630','0','D:\QuickBooks\COLLECTION\Weatherford\WEATHERFORD ACCOUNT STATUS.xls','33','JFRANK','STOP','Dec 12 2008 1:36PM' UNION ALL
SELECT '70814','176634','0','D:\QuickBooks\COLLECTION\Weatherford\WEATHERFORD ACCOUNT STATUS.xls','0','JFRANK','START','Dec 12 2008 1:36PM' UNION ALL
SELECT '70817','176632','0','D:\QuickBooks\COLLECTION\Weatherford\WEATHERFORD ACCOUNT STATUS.xls','35','JFRANK','STOP','Dec 12 2008 1:36PM' UNION ALL
SELECT '70818','176634','0','D:\QuickBooks\COLLECTION\Weatherford\WEATHERFORD ACCOUNT STATUS.xls','0','JFRANK','STOP','Dec 12 2008 1:36PM' UNION ALL
SELECT '70830','176655','0','D:\QuickBooks\COLLECTION\Statements\12-8-08 -JENNY.xls','33','JFRANK','START','Dec 12 2008 1:37PM' UNION ALL
SELECT '70831','176657','0','D:\QuickBooks\COLLECTION\Statements\12-8-08 -JENNY.xls','35','JFRANK','START','Dec 12 2008 1:37PM' UNION ALL
SELECT '70832','176655','0','D:\QuickBooks\COLLECTION\Statements\12-8-08 -JENNY.xls','33','JFRANK','STOP','Dec 12 2008 1:37PM' UNION ALL
SELECT '70833','176659','0','D:\QuickBooks\COLLECTION\Statements\12-8-08 -JENNY.xls','0','JFRANK','START','Dec 12 2008 1:37PM' UNION ALL
SELECT '70836','176666','0','D:\QuickBooks\COLLECTION\Statements\12-8-08 -JENNY.xls','33','JFRANK','START','Dec 12 2008 1:37PM' UNION ALL
SELECT '70837','176657','0','D:\QuickBooks\COLLECTION\Statements\12-8-08 -JENNY.xls','35','JFRANK','STOP','Dec 12 2008 1:37PM' UNION ALL
SELECT '70838','176659','0','D:\QuickBooks\COLLECTION\Statements\12-8-08 -JENNY.xls','0','JFRANK','STOP','Dec 12 2008 1:37PM' UNION ALL
SELECT '70839','176666','0','D:\QuickBooks\COLLECTION\Statements\12-8-08 -JENNY.xls','33','JFRANK','STOP','Dec 12 2008 1:37PM' UNION ALL
SELECT '70855','176680','0','D:\QuickBooks\COLLECTION\Statements\12-8-08 -JENNY.xls','1','JFRANK','START','Dec 12 2008 1:38PM' UNION ALL
SELECT '70856','176684','0','D:\QuickBooks\COLLECTION\Statements\12-8-08 -JENNY.xls','35','JFRANK','START','Dec 12 2008 1:38PM' UNION ALL
SELECT '70857','176680','0','D:\QuickBooks\COLLECTION\Statements\12-8-08 -JENNY.xls','1','JFRANK','STOP','Dec 12 2008 1:38PM' UNION ALL
SELECT '70858','176686','0','D:\QuickBooks\COLLECTION\Statements\12-8-08 -JENNY.xls','0','JFRANK','START','Dec 12 2008 1:38PM' UNION ALL
SELECT '70862','176686','0','D:\QuickBooks\COLLECTION\Statements\12-8-08 -JENNY.xls','0','JFRANK','STOP','Dec 12 2008 1:38PM' UNION ALL
SELECT '71116','176911','0','D:\Human Resources\Personnel\Offer Letters\Offer Letter - Cindy Johnson.doc','35','SROANE','START','Dec 12 2008 1:48PM' UNION ALL
SELECT '71118','176913','0','D:\Human Resources\Personnel\Offer Letters\Offer Letter - Cindy Johnson.doc','0','SROANE','START','Dec 12 2008 1:48PM' UNION ALL
SELECT '71126','176913','0','D:\Human Resources\Personnel\Offer Letters\Offer Letter - Cindy Johnson.doc','0','SROANE','STOP','Dec 12 2008 1:48PM' UNION ALL
SELECT '72812','177669','0','D:\Human Resources\Personnel\Offer Letters\Offer Letter - Cindy Johnson.doc','17','SROANE','START','Dec 12 2008 1:57PM' UNION ALL
SELECT '72814','176911','0','D:\Human Resources\Personnel\Offer Letters\Offer Letter - Cindy Johnson.doc','35','SROANE','STOP','Dec 12 2008 1:57PM' UNION ALL
SELECT '72816','177675','0','D:\Human Resources\Personnel\Offer Letters\Offer Letter - Cindy Johnson.doc','35','SROANE','START','Dec 12 2008 1:57PM' UNION ALL
SELECT '72818','177680','0','D:\Human Resources\Personnel\Offer Letters\Offer Letter - Cindy Johnson.doc','0','SROANE','START','Dec 12 2008 1:57PM' UNION ALL
SELECT '72819','177669','0','D:\Human Resources\Personnel\Offer Letters\Offer Letter - Cindy Johnson.doc','17','SROANE','STOP','Dec 12 2008 1:57PM' UNION ALL
SELECT '72825','177686','0','D:\Human Resources\Personnel\Offer Letters\Offer Letter - Jamie Bednar.doc','35','SROANE','START','Dec 12 2008 1:57PM' UNION ALL
SELECT '72826','177688','0','D:\Human Resources\Personnel\Offer Letters\Offer Letter - Jamie Bednar.doc','0','SROANE','START','Dec 12 2008 1:57PM' UNION ALL
SELECT '72832','177680','0','D:\Human Resources\Personnel\Offer Letters\Offer Letter - Cindy Johnson.doc','0','SROANE','STOP','Dec 12 2008 1:57PM' UNION ALL
SELECT '72833','177688','0','D:\Human Resources\Personnel\Offer Letters\Offer Letter - Jamie Bednar.doc','0','SROANE','STOP','Dec 12 2008 1:57PM' UNION ALL
SELECT '72840','177707','0','D:\Human Resources\Personnel\Offer Letters\Offer Letter - Jamie Bednar.doc','35','SROANE','START','Dec 12 2008 1:58PM' UNION ALL
SELECT '72841','177686','0','D:\Human Resources\Personnel\Offer Letters\Offer Letter - Jamie Bednar.doc','35','SROANE','STOP','Dec 12 2008 1:58PM' UNION ALL
SELECT '72848','177707','3','D:\Human Resources\Personnel\Offer Letters\Offer Letter - Jamie Bednar.doc','35','SROANE','STOP','Dec 12 2008 1:58PM' UNION ALL
SELECT '72849','177675','3','D:\Human Resources\Personnel\Offer Letters\Offer Letter - Cindy Johnson.doc','35','SROANE','STOP','Dec 12 2008 1:58PM' UNION ALL
SELECT '72858','177734','0','D:\Human Resources\Personnel\Offer Letters\Offer Letter - Cindy Johnson.doc','1','SROANE','START','Dec 12 2008 1:58PM' UNION ALL
SELECT '72859','177735','0','D:\Human Resources\Personnel\Offer Letters\Offer Letter - Cindy Johnson.doc','0','SROANE','START','Dec 12 2008 1:58PM' UNION ALL
SELECT '72867','177745','0','D:\Human Resources\Personnel\Offer Letters\Offer Letter - Jamie Bednar.doc','1','SROANE','START','Dec 12 2008 1:58PM' UNION ALL
SELECT '72869','177746','0','D:\Human Resources\Personnel\Offer Letters\Offer Letter - Jamie Bednar.doc','0','SROANE','START','Dec 12 2008 1:58PM' UNION ALL
SELECT '72883','177734','0','D:\Human Resources\Personnel\Offer Letters\Offer Letter - Cindy Johnson.doc','1','SROANE','STOP','Dec 12 2008 1:58PM' UNION ALL
SELECT '72884','177735','0','D:\Human Resources\Personnel\Offer Letters\Offer Letter - Cindy Johnson.doc','0','SROANE','STOP','Dec 12 2008 1:58PM' UNION ALL
SELECT '72885','177745','0','D:\Human Resources\Personnel\Offer Letters\Offer Letter - Jamie Bednar.doc','1','SROANE','STOP','Dec 12 2008 1:58PM' UNION ALL
SELECT '72886','177746','0','D:\Human Resources\Personnel\Offer Letters\Offer Letter - Jamie Bednar.doc','0','SROANE','STOP','Dec 12 2008 1:58PM' UNION ALL
SELECT '73164','178567','0','D:\Users\Wsun\Inventory\2008\11-30-08 Inventory Summary.xls','35','WSUN','START','Dec 12 2008 2:12PM' UNION ALL
SELECT '73200','178775','0','D:\Users\mcole\WDI COLLECTIONS\report 11-24.xls','35','MCOLE','START','Dec 12 2008 2:16PM' UNION ALL
SELECT '73201','176449','0','D:\Users\mcole\WDI COLLECTIONS\report 11-24.xls','35','MCOLE','STOP','Dec 12 2008 2:16PM' UNION ALL
SELECT '73228','178966','0','D:\Users\Wsun\Inventory\2008\11-30-08 Inventory Summary.xls','35','WSUN','START','Dec 12 2008 2:17PM' UNION ALL
SELECT '73229','178567','3','D:\Users\Wsun\Inventory\2008\11-30-08 Inventory Summary.xls','35','WSUN','STOP','Dec 12 2008 2:17PM' UNION ALL
SELECT '73271','178995','0','D:\Human Resources\Personnel\Employee list 2.xls','1','TKISS','START','Dec 12 2008 2:19PM' UNION ALL
SELECT '73272','178996','0','D:\Human Resources\Personnel\Employee list 2.xls','0','TKISS','START','Dec 12 2008 2:19PM' UNION ALL
SELECT '73275','179000','0','D:\Human Resources\Personnel\Employee list 2.xls','35','TKISS','START','Dec 12 2008 2:19PM' UNION ALL
SELECT '73276','178995','0','D:\Human Resources\Personnel\Employee list 2.xls','1','TKISS','STOP','Dec 12 2008 2:19PM' UNION ALL
SELECT '73277','178996','0','D:\Human Resources\Personnel\Employee list 2.xls','0','TKISS','STOP','Dec 12 2008 2:19PM' UNION ALL
SELECT '73278','179001','0','D:\Human Resources\Personnel\Employee list 2.xls','0','TKISS','START','Dec 12 2008 2:19PM' UNION ALL
SELECT '73279','179001','0','D:\Human Resources\Personnel\Employee list 2.xls','0','TKISS','STOP','Dec 12 2008 2:19PM' UNION ALL
SELECT '73282','179000','3','D:\Human Resources\Personnel\Employee list 2.xls','35','TKISS','STOP','Dec 12 2008 2:20PM' UNION ALL
SELECT '73283','179007','0','D:\Human Resources\Personnel\Employee list 2.xls','1','TKISS','START','Dec 12 2008 2:20PM' UNION ALL
SELECT '73286','179021','0','D:\Human Resources\Personnel\Employee list.xls','1','TKISS','START','Dec 12 2008 2:20PM' UNION ALL
SELECT '73287','179022','0','D:\Human Resources\Personnel\Employee list.xls','0','TKISS','START','Dec 12 2008 2:20PM' UNION ALL
SELECT '73288','179024','0','D:\Human Resources\Personnel\Employee list.xls','1','TKISS','START','Dec 12 2008 2:20PM' UNION ALL
SELECT '73289','179021','0','D:\Human Resources\Personnel\Employee list.xls','1','TKISS','STOP','Dec 12 2008 2:20PM' UNION ALL
SELECT '73290','179022','0','D:\Human Resources\Personnel\Employee list.xls','0','TKISS','STOP','Dec 12 2008 2:20PM' UNION ALL
SELECT '73293','179007','0','D:\Human Resources\Personnel\Employee list 2.xls','1','TKISS','STOP','Dec 12 2008 2:20PM' UNION ALL
SELECT '73294','179024','0','D:\Human Resources\Personnel\Employee list.xls','1','TKISS','STOP','Dec 12 2008 2:20PM' UNION ALL
SELECT '73335','179064','0','D:\Users\Wsun\Inventory\2008\11-30-08 Inventory Summary.xls','35','WSUN','START','Dec 12 2008 2:23PM' UNION ALL
SELECT '73336','178966','3','D:\Users\Wsun\Inventory\2008\11-30-08 Inventory Summary.xls','35','WSUN','STOP','Dec 12 2008 2:23PM' UNION ALL
SELECT '73338','179065','0','D:\Human Resources\Payroll\salaried employees 9-1.xls','1','TKISS','START','Dec 12 2008 2:23PM' UNION ALL
SELECT '73339','179066','0','D:\Human Resources\Payroll\salaried employees 9-1.xls','0','TKISS','START','Dec 12 2008 2:23PM' UNION ALL
SELECT '73342','179070','0','D:\Human Resources\Payroll\salaried employees 9-1.xls','35','TKISS','START','Dec 12 2008 2:23PM' UNION ALL
SELECT '73343','179065','0','D:\Human Resources\Payroll\salaried employees 9-1.xls','1','TKISS','STOP','Dec 12 2008 2:23PM' UNION ALL
SELECT '73344','179066','0','D:\Human Resources\Payroll\salaried employees 9-1.xls','0','TKISS','STOP','Dec 12 2008 2:23PM' UNION ALL
SELECT '73345','179071','0','D:\Human Resources\Payroll\salaried employees 9-1.xls','0','TKISS','START','Dec 12 2008 2:23PM' UNION ALL
SELECT '73347','179073','2','D:\Human Resources\Payroll\salaried employees 9-1.xls','1','TKISS','START','Dec 12 2008 2:23PM' UNION ALL
SELECT '73348','179071','0','D:\Human Resources\Payroll\salaried employees 9-1.xls','0','TKISS','STOP','Dec 12 2008 2:23PM' UNION ALL
SELECT '73349','179073','2','D:\Human Resources\Payroll\salaried employees 9-1.xls','1','TKISS','STOP','Dec 12 2008 2:23PM' UNION ALL
SELECT '73352','179070','3','D:\Human Resources\Payroll\salaried employees 9-1.xls','35','TKISS','STOP','Dec 12 2008 2:23PM' UNION ALL
SELECT '73353','179077','0','D:\Human Resources\Payroll\salaried employees 9-1.xls','1','TKISS','START','Dec 12 2008 2:23PM' UNION ALL
SELECT '73356','179077','0','D:\Human Resources\Payroll\salaried employees 9-1.xls','1','TKISS','STOP','Dec 12 2008 2:23PM' UNION ALL
SELECT '74462','180060','0','D:\Users\wsun\Inventory\2008\10-31-08 Inventory Summary.xls','35','WSUN','START','Dec 12 2008 2:38PM' UNION ALL
SELECT '74464','180061','0','D:\Users\wsun\Inventory\2008\10-31-08 Inventory Summary.xls','0','WSUN','START','Dec 12 2008 2:38PM' UNION ALL
SELECT '74466','180061','0','D:\Users\wsun\Inventory\2008\10-31-08 Inventory Summary.xls','0','WSUN','STOP','Dec 12 2008 2:38PM' UNION ALL
SELECT '74522','180060','0','D:\Users\wsun\Inventory\2008\10-31-08 Inventory Summary.xls','35','WSUN','STOP','Dec 12 2008 2:44PM' UNION ALL
SELECT '74526','180210','0','D:\Users\wsun\Inventory\2008\10-31-08 Inventory Report.xls','35','WSUN','START','Dec 12 2008 2:44PM' UNION ALL
SELECT '74528','180211','0','D:\Users\wsun\Inventory\2008\10-31-08 Inventory Report.xls','0','WSUN','START','Dec 12 2008 2:44PM' UNION ALL
SELECT '74532','180211','0','D:\Users\wsun\Inventory\2008\10-31-08 Inventory Report.xls','0','WSUN','STOP','Dec 12 2008 2:44PM' UNION ALL
SELECT '74537','180210','0','D:\Users\wsun\Inventory\2008\10-31-08 Inventory Report.xls','35','WSUN','STOP','Dec 12 2008 2:45PM' UNION ALL
SELECT '74539','180234','3','D:\Users\wsun\Inventory\2008\10-31-08 Inventory Report.xls','35','WSUN','START','Dec 12 2008 2:45PM' UNION ALL
SELECT '74542','179064','3','D:\Users\Wsun\Inventory\2008\11-30-08 Inventory Summary.xls','35','WSUN','STOP','Dec 12 2008 2:45PM' UNION ALL
SELECT '74544','180245','3','D:\Users\Wsun\Inventory\2008\11-30-08 Inventory Summary.xls','35','WSUN','START','Dec 12 2008 2:45PM' UNION ALL
SELECT '74615','180234','3','D:\Users\wsun\Inventory\2008\10-31-08 Inventory Report.xls','35','WSUN','STOP','Dec 12 2008 2:53PM' UNION ALL
SELECT '74617','180245','3','D:\Users\Wsun\Inventory\2008\11-30-08 Inventory Summary.xls','35','WSUN','STOP','Dec 12 2008 2:53PM' UNION ALL
SELECT '74619','182729','3','D:\Users\Wsun\Inventory\2008\11-30-08 Inventory Summary.xls','35','WSUN','START','Dec 12 2008 2:53PM' UNION ALL
SELECT '74628','182729','3','D:\Users\Wsun\Inventory\2008\11-30-08 Inventory Summary.xls','35','WSUN','STOP','Dec 12 2008 2:53PM' UNION ALL
SELECT '74630','182739','3','D:\Users\Wsun\Inventory\2008\11-30-08 Inventory Report.xls','35','WSUN','START','Dec 12 2008 2:53PM' UNION ALL
SELECT '74633','182739','3','D:\Users\Wsun\Inventory\2008\11-30-08 Inventory Report.xls','35','WSUN','STOP','Dec 12 2008 2:53PM' UNION ALL
SELECT '75690','183205','0','D:\QuickBooks\COLLECTION\Statements\12-8-08 -JENNY.xls','33','JFRANK','START','Dec 12 2008 2:57PM' UNION ALL
SELECT '75691','183205','0','D:\QuickBooks\COLLECTION\Statements\12-8-08 -JENNY.xls','33','JFRANK','STOP','Dec 12 2008 2:57PM' UNION ALL
SELECT '75692','183214','1','D:\QuickBooks\COLLECTION\Statements\12-8-08 -JENNY.xls','1','JFRANK','START','Dec 12 2008 2:57PM' UNION ALL
SELECT '75693','183217','2','D:\QuickBooks\COLLECTION\Statements\12-8-08 -JENNY.xls','1','JFRANK','START','Dec 12 2008 2:57PM' UNION ALL
SELECT '75694','183214','1','D:\QuickBooks\COLLECTION\Statements\12-8-08 -JENNY.xls','1','JFRANK','STOP','Dec 12 2008 2:57PM' UNION ALL
SELECT '75695','183217','2','D:\QuickBooks\COLLECTION\Statements\12-8-08 -JENNY.xls','1','JFRANK','STOP','Dec 12 2008 2:57PM' UNION ALL
SELECT '75944','183509','0','D:\Human Resources\Insurance Forms\Notice to Remove Dependent.doc','1','SROANE','START','Dec 12 2008 3:09PM' UNION ALL
SELECT '75945','183510','0','D:\Human Resources\Insurance Forms\Notice to Remove Dependent.doc','0','SROANE','START','Dec 12 2008 3:09PM' UNION ALL
SELECT '75949','183509','0','D:\Human Resources\Insurance Forms\Notice to Remove Dependent.doc','1','SROANE','STOP','Dec 12 2008 3:09PM' UNION ALL
SELECT '75950','183510','0','D:\Human Resources\Insurance Forms\Notice to Remove Dependent.doc','0','SROANE','STOP','Dec 12 2008 3:09PM' UNION ALL
SELECT '75960','183527','0','D:\Human Resources\Insurance Forms\Notice to Remove Dependent.doc','1','SROANE','START','Dec 12 2008 3:10PM' UNION ALL
SELECT '75961','183530','0','D:\Human Resources\Insurance Forms\Notice to Remove Dependent.doc','35','SROANE','START','Dec 12 2008 3:10PM' UNION ALL
SELECT '75963','183527','0','D:\Human Resources\Insurance Forms\Notice to Remove Dependent.doc','1','SROANE','STOP','Dec 12 2008 3:10PM' UNION ALL
SELECT '75965','183541','0','D:\Human Resources\Insurance Forms\Notice to Remove Dependent.doc','35','SROANE','START','Dec 12 2008 3:10PM' UNION ALL
SELECT '75966','183545','0','D:\Human Resources\Insurance Forms\Notice to Remove Dependent.doc','0','SROANE','START','Dec 12 2008 3:10PM' UNION ALL
SELECT '75967','183530','0','D:\Human Resources\Insurance Forms\Notice to Remove Dependent.doc','35','SROANE','STOP','Dec 12 2008 3:10PM' UNION ALL
SELECT '75970','183541','3','D:\Human Resources\Insurance Forms\Notice to Remove Dependent.doc','35','SROANE','STOP','Dec 12 2008 3:10PM' UNION ALL
SELECT '75975','183545','0','D:\Human Resources\Insurance Forms\Notice to Remove Dependent.doc','0','SROANE','STOP','Dec 12 2008 3:10PM' UNION ALL
SELECT '75987','183561','0','D:\Human Resources\Insurance Forms\Notice to Remove Dependent.doc','35','SROANE','START','Dec 12 2008 3:11PM' UNION ALL
SELECT '75989','183563','0','D:\Human Resources\Insurance Forms\Notice to Remove Dependent.doc','0','SROANE','START','Dec 12 2008 3:11PM' UNION ALL
SELECT '75992','183563','0','D:\Human Resources\Insurance Forms\Notice to Remove Dependent.doc','0','SROANE','STOP','Dec 12 2008 3:11PM' UNION ALL
SELECT '75996','183579','3','D:\Human Resources\Insurance Forms\Notice to Remove Dependent.doc','35','SROANE','START','Dec 12 2008 3:11PM' UNION ALL
SELECT '75997','183561','0','D:\Human Resources\Insurance Forms\Notice to Remove Dependent.doc','35','SROANE','STOP','Dec 12 2008 3:11PM' UNION ALL
SELECT '75999','183589','0','D:\Human Resources\Insurance Forms\Notice to Remove Dependent.doc','0','SROANE','START','Dec 12 2008 3:11PM' UNION ALL
SELECT '76001','183579','3','D:\Human Resources\Insurance Forms\Notice to Remove Dependent.doc','35','SROANE','STOP','Dec 12 2008 3:11PM' UNION ALL
SELECT '76002','183589','0','D:\Human Resources\Insurance Forms\Notice to Remove Dependent.doc','0','SROANE','STOP','Dec 12 2008 3:11PM' UNION ALL
SELECT '76200','183745','0','D:\QuickBooks\Inventory\Inventory Control December 08.xls','33','WSUN','START','Dec 12 2008 3:26PM' UNION ALL
SELECT '76201','170094','0','D:\QuickBooks\Inventory\Inventory Control December 08.xls','35','WSUN','STOP','Dec 12 2008 3:26PM' UNION ALL
SELECT '76204','183749','0','D:\QuickBooks\Inventory\Inventory Control December 08.xls','17','WSUN','START','Dec 12 2008 3:26PM' UNION ALL
SELECT '76206','183745','0','D:\QuickBooks\Inventory\Inventory Control December 08.xls','33','WSUN','STOP','Dec 12 2008 3:26PM' UNION ALL
SELECT '76208','183757','0','D:\QuickBooks\Inventory\Inventory Control December 08.xls','33','WSUN','START','Dec 12 2008 3:26PM' UNION ALL
SELECT '76210','183760','0','D:\QuickBooks\Inventory\Inventory Control December 08.xls','33','WSUN','START','Dec 12 2008 3:26PM' UNION ALL
SELECT '76211','183749','0','D:\QuickBooks\Inventory\Inventory Control December 08.xls','17','WSUN','STOP','Dec 12 2008 3:26PM' UNION ALL
SELECT '76213','183757','0','D:\QuickBooks\Inventory\Inventory Control December 08.xls','33','WSUN','STOP','Dec 12 2008 3:26PM' UNION ALL
SELECT '76214','183762','0','D:\QuickBooks\Inventory\Inventory Control December 08.xls','35','WSUN','START','Dec 12 2008 3:26PM' UNION ALL
SELECT '76215','183760','0','D:\QuickBooks\Inventory\Inventory Control December 08.xls','33','WSUN','STOP','Dec 12 2008 3:26PM' UNION ALL
SELECT '77142','184160','0','D:\Users\Wsun\Inventory\2008\11-30-08 Inventory Report.xls','1','WSUN','START','Dec 12 2008 3:27PM' UNION ALL
SELECT '77277','184160','0','D:\Users\Wsun\Inventory\2008\11-30-08 Inventory Report.xls','1','WSUN','STOP','Dec 12 2008 3:27PM' UNION ALL
SELECT '77289','184160','0','D:\Users\Wsun\Inventory\2008\11-30-08 Inventory Report.xls','1','WSUN','STOP','Dec 12 2008 3:27PM' UNION ALL
SELECT '77358','184232','0','D:\Users\mcole\WDI COLLECTIONS\report 11-24.xls','35','MCOLE','START','Dec 12 2008 3:33PM' UNION ALL
SELECT '77359','178775','3','D:\Users\mcole\WDI COLLECTIONS\report 11-24.xls','35','MCOLE','STOP','Dec 12 2008 3:33PM' UNION ALL
SELECT '77362','184232','3','D:\Users\mcole\WDI COLLECTIONS\report 11-24.xls','35','MCOLE','STOP','Dec 12 2008 3:33PM' UNION ALL
SELECT '79065','185657','0','D:\Human Resources\Trackers - 2008.xls','35','SROANE','START','Dec 12 2008 4:14PM' UNION ALL
SELECT '79066','185658','0','D:\Human Resources\Trackers - 2008.xls','0','SROANE','START','Dec 12 2008 4:14PM' UNION ALL
SELECT '79069','185658','0','D:\Human Resources\Trackers - 2008.xls','0','SROANE','STOP','Dec 12 2008 4:14PM' UNION ALL
SELECT '79095','185714','0','D:\Human Resources\Trackers - 2008.xls','35','SROANE','START','Dec 12 2008 4:16PM' UNION ALL
SELECT '79096','185657','0','D:\Human Resources\Trackers - 2008.xls','35','SROANE','STOP','Dec 12 2008 4:16PM' UNION ALL
SELECT '79107','185725','0','D:\Human Resources\Trackers - 2008.xls','17','SROANE','START','Dec 12 2008 4:16PM' UNION ALL
SELECT '79109','185714','3','D:\Human Resources\Trackers - 2008.xls','35','SROANE','STOP','Dec 12 2008 4:16PM' UNION ALL
SELECT '79111','185732','3','D:\Human Resources\Trackers - 2008.xls','35','SROANE','START','Dec 12 2008 4:16PM' UNION ALL
SELECT '79112','185725','0','D:\Human Resources\Trackers - 2008.xls','17','SROANE','STOP','Dec 12 2008 4:16PM' UNION ALL
SELECT '79192','185732','3','D:\Human Resources\Trackers - 2008.xls','35','SROANE','STOP','Dec 12 2008 4:22PM' UNION ALL
SELECT '79194','185832','3','D:\Human Resources\Trackers - 2008.xls','35','SROANE','START','Dec 12 2008 4:22PM' UNION ALL
SELECT '79201','185835','0','D:\Human Resources\Trackers - 2008.xls','17','SROANE','START','Dec 12 2008 4:22PM' UNION ALL
SELECT '79203','185832','3','D:\Human Resources\Trackers - 2008.xls','35','SROANE','STOP','Dec 12 2008 4:22PM' UNION ALL
SELECT '79205','185842','3','D:\Human Resources\Trackers - 2008.xls','35','SROANE','START','Dec 12 2008 4:22PM' UNION ALL
SELECT '79206','185835','0','D:\Human Resources\Trackers - 2008.xls','17','SROANE','STOP','Dec 12 2008 4:22PM' UNION ALL
SELECT '79316','186001','0','D:\QuickBooks\COLLECTION\Statements\12-8-08 -JENNY.xls','33','JFRANK','START','Dec 12 2008 4:26PM' UNION ALL
SELECT '79317','176684','3','D:\QuickBooks\COLLECTION\Statements\12-8-08 -JENNY.xls','35','JFRANK','STOP','Dec 12 2008 4:26PM' UNION ALL
SELECT '79319','186001','0','D:\QuickBooks\COLLECTION\Statements\12-8-08 -JENNY.xls','33','JFRANK','STOP','Dec 12 2008 4:26PM' UNION ALL
SELECT '79320','186009','0','D:\QuickBooks\COLLECTION\Statements\12-8-08 -JENNY.xls','17','JFRANK','START','Dec 12 2008 4:26PM' UNION ALL
SELECT '79322','186020','0','D:\QuickBooks\COLLECTION\Statements\12-8-08 -JENNY.xls','33','JFRANK','START','Dec 12 2008 4:26PM' UNION ALL
SELECT '79323','186009','0','D:\QuickBooks\COLLECTION\Statements\12-8-08 -JENNY.xls','17','JFRANK','STOP','Dec 12 2008 4:26PM' UNION ALL
SELECT '79325','186022','0','D:\QuickBooks\COLLECTION\Statements\12-8-08 -JENNY.xls','35','JFRANK','START','Dec 12 2008 4:26PM' UNION ALL
SELECT '79326','186020','0','D:\QuickBooks\COLLECTION\Statements\12-8-08 -JENNY.xls','33','JFRANK','STOP','Dec 12 2008 4:26PM' UNION ALL
SELECT '79328','186022','0','D:\QuickBooks\COLLECTION\Statements\12-8-08 -JENNY.xls','35','JFRANK','STOP','Dec 12 2008 4:26PM' UNION ALL
SELECT '80600','189526','0','D:\Human Resources\Personnel\Employee list 2.xls','35','SROANE','START','Dec 12 2008 4:45PM' UNION ALL
SELECT '80602','189527','0','D:\Human Resources\Personnel\Employee list 2.xls','0','SROANE','START','Dec 12 2008 4:45PM' UNION ALL
SELECT '80609','189527','0','D:\Human Resources\Personnel\Employee list 2.xls','0','SROANE','STOP','Dec 12 2008 4:45PM' UNION ALL
SELECT '80625','189526','0','D:\Human Resources\Personnel\Employee list 2.xls','35','SROANE','STOP','Dec 12 2008 4:49PM' UNION ALL
SELECT '80626','185842','3','D:\Human Resources\Trackers - 2008.xls','35','SROANE','STOP','Dec 12 2008 4:49PM' UNION ALL
SELECT '81101','201196','3','D:\Users\Wsun\2008\hvc\MIP Invoice# 0214.xls','35','WSUN','START','Dec 12 2008 4:57PM' UNION ALL
SELECT '81110','201196','3','D:\Users\Wsun\2008\hvc\MIP Invoice# 0214.xls','35','WSUN','STOP','Dec 12 2008 4:57PM' UNION ALL
SELECT '81247','203686','0','D:\QuickBooks\Inventory\Inventory Control December 08.xls','33','WSUN','START','Dec 12 2008 5:03PM' UNION ALL
SELECT '81248','183762','0','D:\QuickBooks\Inventory\Inventory Control December 08.xls','35','WSUN','STOP','Dec 12 2008 5:03PM' UNION ALL
SELECT '81251','203690','0','D:\QuickBooks\Inventory\Inventory Control December 08.xls','17','WSUN','START','Dec 12 2008 5:03PM' UNION ALL
SELECT '81252','203686','0','D:\QuickBooks\Inventory\Inventory Control December 08.xls','33','WSUN','STOP','Dec 12 2008 5:03PM' UNION ALL
SELECT '81254','203701','0','D:\QuickBooks\Inventory\Inventory Control December 08.xls','33','WSUN','START','Dec 12 2008 5:03PM' UNION ALL
SELECT '81255','203690','0','D:\QuickBooks\Inventory\Inventory Control December 08.xls','17','WSUN','STOP','Dec 12 2008 5:03PM' UNION ALL
SELECT '81257','203703','0','D:\QuickBooks\Inventory\Inventory Control December 08.xls','35','WSUN','START','Dec 12 2008 5:03PM' UNION ALL
SELECT '81258','203701','0','D:\QuickBooks\Inventory\Inventory Control December 08.xls','33','WSUN','STOP','Dec 12 2008 5:03PM' UNION ALL
SELECT '81259','203705','0','D:\QuickBooks\Inventory\Inventory Control December 08.xls','0','WSUN','START','Dec 12 2008 5:03PM' UNION ALL
SELECT '81262','203703','0','D:\QuickBooks\Inventory\Inventory Control December 08.xls','35','WSUN','STOP','Dec 12 2008 5:03PM' UNION ALL
SELECT '81263','203705','0','D:\QuickBooks\Inventory\Inventory Control December 08.xls','0','WSUN','STOP','Dec 12 2008 5:03PM' UNION ALL
INSERT INTO #file_modify([id], [FullPath], [ChangeType], [dttm])
SELECT '29248','D:\Users\eburnett\aaquality wdi rev102606\aaawdi manufacturing qms\REVISIONS\WORKINGeed maintaince.DOC','Created','Dec 12 2008 8:12AM' UNION ALL
SELECT '29254','D:\Users\eburnett\aaquality wdi rev102606\aaawdi manufacturing qms\REVISIONS\WORKINGeed maintaince JD.DOC///D:\Users\eburnett\','Renamed','Dec 12 2008 8:12AM' UNION ALL
SELECT '29297','D:\QuickBooks\Inventory\Inventory Control December 08.xls','Changed','Dec 12 2008 8:14AM' UNION ALL
SELECT '29301','D:\Users\rhernandez\EALT3.xls','Created','Dec 12 2008 8:14AM' UNION ALL
SELECT '29303','D:\Warehouse\Tomball Warehouse\EAL.xls','Deleted','Dec 12 2008 8:14AM' UNION ALL
SELECT '29307','D:\Warehouse\Tomball Warehouse\EAL.xls','Created','Dec 12 2008 8:14AM' UNION ALL
SELECT '29312','D:\Warehouse\TOMBALL BACKORDER REPORT\Tomball Backorder Report.xls','Deleted','Dec 12 2008 8:14AM' UNION ALL
SELECT '29316','D:\Warehouse\TOMBALL BACKORDER REPORT\Tomball Backorder Report.xls','Created','Dec 12 2008 8:14AM' UNION ALL
SELECT '29496','D:\Users\eburnett\aaquality wdi rev102606\aaawdi manufacturing qms\REVISIONS\COMPLETE READY\WDIMQP 6202 REV C JD MANUFACTURING ','Created','Dec 12 2008 8:16AM' UNION ALL
SELECT '29500','D:\Users\eburnett\aaquality wdi rev102606\aaawdi manufacturing qms\REVISIONS\COMPLETE READY\WDIMQP 6202 REV C JD MANUFACTURING ','Deleted','Dec 12 2008 8:16AM' UNION ALL
SELECT '29504','D:\Users\eburnett\aaquality wdi rev102606\aaawdi manufacturing qms\REVISIONS\COMPLETE READY\WDIMQP 6202 REV C JD MANUFACTURING ','Created','Dec 12 2008 8:16AM' UNION ALL
SELECT '29534','D:\Users\eburnett\aaquality wdi rev102606\aaawdi manufacturing qms\REVISIONS\WORKING\WDIMQP 6202 REV B JD MANUFACTURING PLANT M','Deleted','Dec 12 2008 8:17AM' UNION ALL
SELECT '29535','D:\Users\eburnett\aaquality wdi rev102606\aaawdi manufacturing qms\REVISIONS\OBOSOLETE\WDIMQP 6202 REV B JD MANUFACTURING PLANT','Created','Dec 12 2008 8:17AM' UNION ALL
SELECT '29656','D:\Users\eburnett\aaquality wdi rev102606\aaawdi manufacturing qms\REVISIONS\COMPLETE READY\WDIMQP 6210 REV C JD MANUAL MILL OPE','Created','Dec 12 2008 8:18AM' UNION ALL
SELECT '29659','D:\Users\eburnett\aaquality wdi rev102606\aaawdi manufacturing qms\REVISIONS\COMPLETE READY\WDIMQP 6210 REV C JD MANUAL MILL OPE','Deleted','Dec 12 2008 8:18AM' UNION ALL
SELECT '29663','D:\Users\eburnett\aaquality wdi rev102606\aaawdi manufacturing qms\REVISIONS\COMPLETE READY\WDIMQP 6210 REV C JD MANUAL MILL OPE','Created','Dec 12 2008 8:18AM' UNION ALL
SELECT '29664','D:\Users\eburnett\aaquality wdi rev102606\aaawdi manufacturing qms\REVISIONS\WORKING\WDIMQP 6210 REV B JD MANUAL MILL OPERATOR.D','Deleted','Dec 12 2008 8:19AM' UNION ALL
SELECT '29665','D:\Users\eburnett\aaquality wdi rev102606\aaawdi manufacturing qms\REVISIONS\OBOSOLETE\WDIMQP 6210 REV B JD MANUAL MILL OPERATOR','Created','Dec 12 2008 8:19AM' UNION ALL
SELECT '29685','D:\Users\eburnett\aaquality wdi rev102606\aaawdi manufacturing qms\REVISIONS\COMPLETE READY\WDIMQP 6209 REV C JD LATHE OPERATOR.','Created','Dec 12 2008 8:19AM' UNION ALL
SELECT '29690','D:\Users\eburnett\aaquality wdi rev102606\aaawdi manufacturing qms\REVISIONS\COMPLETE READY\WDIMQP 6209 REV C JD LATHE OPERATOR.','Deleted','Dec 12 2008 8:20AM' UNION ALL
SELECT '29694','D:\Users\eburnett\aaquality wdi rev102606\aaawdi manufacturing qms\REVISIONS\COMPLETE READY\WDIMQP 6209 REV C JD LATHE OPERATOR.','Created','Dec 12 2008 8:20AM' UNION ALL
SELECT '29701','D:\Users\eburnett\aaquality wdi rev102606\aaawdi manufacturing qms\REVISIONS\COMPLETE READY\WDIMQP 6211 REV C JD CNC OPERATOR.DO','Created','Dec 12 2008 8:20AM' UNION ALL
SELECT '29702','D:\MTR\11-15-2008\08-11-15_WDI--LIST1\2008-11-15 PACKING LIST-WDI.xls','Changed','Dec 12 2008 8:20AM' UNION ALL
SELECT '29703','D:\MTR\11-15-2008\08-11-15_WDI--LIST1\2008-11-15 PACKING LIST-WDI.xls','Changed','Dec 12 2008 8:21AM' UNION ALL
SELECT '29706','D:\Users\eburnett\aaquality wdi rev102606\aaawdi manufacturing qms\REVISIONS\COMPLETE READY\WDIMQP 6211 REV C JD CNC OPERATOR.DO','Deleted','Dec 12 2008 8:21AM' UNION ALL
SELECT '29710','D:\Users\eburnett\aaquality wdi rev102606\aaawdi manufacturing qms\REVISIONS\COMPLETE READY\WDIMQP 6211 REV C JD CNC OPERATOR.DO','Created','Dec 12 2008 8:21AM' UNION ALL
SELECT '29714','D:\Users\eburnett\aaquality wdi rev102606\aaawdi manufacturing qms\REVISIONS\COMPLETE READY\WDIMQP 6211 REV C JD CNC OPERATOR.DO','Deleted','Dec 12 2008 8:21AM' UNION ALL
SELECT '29718','D:\Users\eburnett\aaquality wdi rev102606\aaawdi manufacturing qms\REVISIONS\COMPLETE READY\WDIMQP 6211 REV C JD CNC OPERATOR.DO','Created','Dec 12 2008 8:21AM' UNION ALL
SELECT '29724','D:\Users\eburnett\aaquality wdi rev102606\aaawdi manufacturing qms\REVISIONS\COMPLETE READY\WDIMQP 6220 REV A JD ASSEMBLER.doc','Created','Dec 12 2008 8:22AM' UNION ALL
SELECT '29797','D:\Users\eburnett\aaquality wdi rev102606\aaawdi manufacturing qms\REVISIONS\COMPLETE READY\WDIMQP 6222 REV A JD CNC MACHNIST.DO','Created','Dec 12 2008 8:23AM' UNION ALL
SELECT '29855','D:\Users\eburnett\aaquality wdi rev102606\aaawdi manufacturing qms\REVISIONS\WORKING\WDIMQP 6222 REV NC JD CNC MACHNIST.DOC','Deleted','Dec 12 2008 8:23AM' UNION ALL
SELECT '29856','D:\Users\eburnett\aaquality wdi rev102606\aaawdi manufacturing qms\REVISIONS\OBOSOLETE\WDIMQP 6222 REV NC JD CNC MACHNIST.DOC','Created','Dec 12 2008 8:23AM' UNION ALL
SELECT '29896','D:\Users\eburnett\aaquality wdi rev102606\aaawdi manufacturing qms\REVISIONS\WORKING\WDIMQP 6220 REV NC JD ASSEMBLER.doc','Deleted','Dec 12 2008 8:23AM' UNION ALL
SELECT '29897','D:\Users\eburnett\aaquality wdi rev102606\aaawdi manufacturing qms\REVISIONS\OBOSOLETE\WDIMQP 6220 REV NC JD ASSEMBLER.doc','Created','Dec 12 2008 8:23AM' UNION ALL
SELECT '29910','D:\Users\eburnett\aaquality wdi rev102606\aaawdi manufacturing qms\REVISIONS\WORKING\WDIMQP 6211 REV B JD CNC OPERATOR.DOC','Deleted','Dec 12 2008 8:23AM' UNION ALL
SELECT '29911','D:\Users\eburnett\aaquality wdi rev102606\aaawdi manufacturing qms\REVISIONS\OBOSOLETE\WDIMQP 6211 REV B JD CNC OPERATOR.DOC','Created','Dec 12 2008 8:23AM' UNION ALL
SELECT '29912','D:\Users\eburnett\aaquality wdi rev102606\aaawdi manufacturing qms\REVISIONS\WORKING\WDIMQP 6209 REV B JD LATHE OPERATOR.DOC','Deleted','Dec 12 2008 8:23AM' UNION ALL
SELECT '29913','D:\Users\eburnett\aaquality wdi rev102606\aaawdi manufacturing qms\REVISIONS\OBOSOLETE\WDIMQP 6209 REV B JD LATHE OPERATOR.DOC','Created','Dec 12 2008 8:23AM' UNION ALL
SELECT '30113','D:\Users\eburnett\aaquality wdi rev102606\aaawdi manufacturing qms\REVISIONS\COMPLETE READY\WDIMQP 6221 REV A JD SAW OPTERATOR.d','Created','Dec 12 2008 8:26AM' UNION ALL
SELECT '30114','D:\Users\eburnett\aaquality wdi rev102606\aaawdi manufacturing qms\REVISIONS\WORKING\WDIMQP 6221 REV NC JD SAW OPTERATOR.doc','Deleted','Dec 12 2008 8:26AM' UNION ALL
SELECT '30115','D:\Users\eburnett\aaquality wdi rev102606\aaawdi manufacturing qms\REVISIONS\OBOSOLETE\WDIMQP 6221 REV NC JD SAW OPTERATOR.doc','Created','Dec 12 2008 8:26AM' UNION ALL
SELECT '30118','D:\Users\eburnett\aaquality wdi rev102606\aaawdi manufacturing qms\REVISIONS\WORKING\Manufacturing President JD Pending.DOC','Created','Dec 12 2008 8:27AM' UNION ALL
SELECT '30199','D:\QuickBooks\Inventory\Inventory Control December 08.xls','Changed','Dec 12 2008 8:31AM' UNION ALL
SELECT '30204','D:\QuickBooks\Inventory\Inventory Control December 08.xls~RF13b60213.TMP///D:\QuickBooks\Inventory\Inventory Control December 08','Renamed','Dec 12 2008 8:31AM' UNION ALL
SELECT '30451','D:\Users\dbowen\Copy of Expense Report Form - BLANK.xls','Created','Dec 12 2008 8:37AM' UNION ALL
SELECT '30452','D:\Users\dbowen\Copy of Expense Report Form - BLANK.xls','Deleted','Dec 12 2008 8:37AM' UNION ALL
SELECT '30456','D:\Users\dbowen\Copy of Expense Report Form - BLANK.xls','Created','Dec 12 2008 8:37AM' UNION ALL
SELECT '32284','D:\Warehouse\Tomball Warehouse\Cons. Inventory.xls','Deleted','Dec 12 2008 9:08AM' UNION ALL
SELECT '32288','D:\Warehouse\Tomball Warehouse\Cons. Inventory.xls','Created','Dec 12 2008 9:08AM' UNION ALL
SELECT '33401','D:\Users\wsun\Xunlei\ENGote.xls','Changed','Dec 12 2008 9:20AM' UNION ALL
SELECT '34136','D:\Accounting\BalanceSheetComparison\2008\Canada-10-31-08.xls','Changed','Dec 12 2008 9:33AM' UNION ALL
SELECT '34137','D:\Accounting\BalanceSheetComparison\2008\Canada-10-31-08.xls','Changed','Dec 12 2008 9:33AM' UNION ALL
SELECT '34142','D:\Accounting\BalanceSheetComparison\2008\Canada-10-31-08.xls','Changed','Dec 12 2008 9:33AM' UNION ALL
SELECT '34143','D:\Accounting\BalanceSheetComparison\2008\Canada-11-30-08.xls','Created','Dec 12 2008 9:33AM' UNION ALL
SELECT '34144','D:\Accounting\BalanceSheetComparison\2008\Canada-11-30-08.xls','Deleted','Dec 12 2008 9:33AM' UNION ALL
SELECT '34158','D:\Accounting\BalanceSheetComparison\2008\Canada-10-31-08.xls','Changed','Dec 12 2008 9:33AM' UNION ALL
SELECT '34195','D:\Accounting\BalanceSheetComparison\2008\WDI-10-31-08.xls','Changed','Dec 12 2008 9:41AM' UNION ALL
SELECT '34196','D:\Accounting\BalanceSheetComparison\2008\WDI-10-31-08.xls','Changed','Dec 12 2008 9:41AM' UNION ALL
SELECT '34197','D:\Accounting\BalanceSheetComparison\2008\WDI-10-31-08.xls','Changed','Dec 12 2008 9:41AM' UNION ALL
SELECT '34213','D:\Accounting\BalanceSheetComparison\2008\WDI-11-30-08.xls','Created','Dec 12 2008 9:42AM' UNION ALL
SELECT '34214','D:\Accounting\BalanceSheetComparison\2008\WDI-11-30-08.xls','Deleted','Dec 12 2008 9:42AM' UNION ALL
SELECT '34228','D:\Accounting\BalanceSheetComparison\2008\WDI-10-31-08.xls','Changed','Dec 12 2008 9:42AM' UNION ALL
SELECT '34249','D:\Accounting\BalanceSheetComparison\2008\WDI-11-30-08.xls~RF3b3399f.TMP///D:\Accounting\BalanceSheetComparison\2008\WDI-11-30-0','Renamed','Dec 12 2008 9:42AM' UNION ALL
SELECT '34269','D:\Accounting\BalanceSheetComparison\2008\Canada-11-30-08.xls~RF3b3705f.TMP///D:\Accounting\BalanceSheetComparison\2008\Canada-1','Renamed','Dec 12 2008 9:42AM' UNION ALL
SELECT '34273','D:\Human Resources\Bonus Spreadsheet\2008 Xmas.xls','Changed','Dec 12 2008 9:43AM' UNION ALL
SELECT '34274','D:\Users\mburkhalter\Marisa\time.xls','Changed','Dec 12 2008 9:43AM' UNION ALL
SELECT '34275','D:\Human Resources\Bonus Spreadsheet\2008 Xmas.xls','Changed','Dec 12 2008 9:44AM' UNION ALL
SELECT '34276','D:\Users\mburkhalter\AC-NOV.xls','Changed','Dec 12 2008 9:44AM' UNION ALL
SELECT '34277','D:\Users\mburkhalter\AR-NOV.xls','Changed','Dec 12 2008 9:44AM' UNION ALL
SELECT '34278','D:\Users\mburkhalter\MS-NOV.xls','Changed','Dec 12 2008 9:44AM' UNION ALL
SELECT '34279','D:\Users\mburkhalter\NT-NOV.xls','Changed','Dec 12 2008 9:45AM' UNION ALL
SELECT '34280','D:\Users\mburkhalter\PN-NOV.xls','Changed','Dec 12 2008 9:45AM' UNION ALL
SELECT '34281','D:\Users\mburkhalter\RK-NOV.xls','Changed','Dec 12 2008 9:45AM' UNION ALL
SELECT '34282','D:\Users\mburkhalter\ST-NOV.xls','Changed','Dec 12 2008 9:45AM' UNION ALL
SELECT '34283','D:\Users\mburkhalter\TY-NOV.xls','Changed','Dec 12 2008 9:45AM' UNION ALL
SELECT '34284','D:\Human Resources\HVC\Commissions\September sales commission.xls','Changed','Dec 12 2008 9:45AM' UNION ALL
SELECT '34286','D:\MTR\10-24-08_WDI MTR\10-95885 2.doc','Deleted','Dec 12 2008 9:46AM' UNION ALL
SELECT '34290','D:\MTR\10-24-08_WDI MTR\10-95885 2.doc','Created','Dec 12 2008 9:46AM' UNION ALL
SELECT '34456','D:\Human Resources\HVC\Commissions\September sales commission.xls','Changed','Dec 12 2008 9:48AM' UNION ALL
SELECT '34559','D:\Users\mburkhalter\TY-NOV.xls','Changed','Dec 12 2008 9:48AM' UNION ALL
SELECT '34560','D:\Users\mburkhalter\ST-NOV.xls','Changed','Dec 12 2008 9:48AM' UNION ALL
SELECT '34562','D:\Users\mburkhalter\RK-NOV.xls','Changed','Dec 12 2008 9:48AM' UNION ALL
SELECT '34563','D:\Users\mburkhalter\PN-NOV.xls','Changed','Dec 12 2008 9:48AM' UNION ALL
SELECT '34564','D:\Users\mburkhalter\NT-NOV.xls','Changed','Dec 12 2008 9:48AM' UNION ALL
SELECT '34566','D:\Users\mburkhalter\MS-NOV.xls','Changed','Dec 12 2008 9:48AM' UNION ALL
SELECT '34567','D:\Users\mburkhalter\AR-NOV.xls','Changed','Dec 12 2008 9:48AM' UNION ALL
SELECT '34568','D:\Users\mburkhalter\AC-NOV.xls','Changed','Dec 12 2008 9:48AM' UNION ALL
SELECT '34570','D:\Users\mcole\invoice.xls','Created','Dec 12 2008 9:49AM' UNION ALL
SELECT '34571','D:\Users\mcole\invoice.xls','Deleted','Dec 12 2008 9:49AM' UNION ALL
SELECT '34607','D:\Users\mburkhalter\Marisa\time.xls','Changed','Dec 12 2008 9:49AM' UNION ALL
SELECT '34612','D:\Users\mburkhalter\Marisa\time.xls~RF3b9deac.TMP///D:\Users\mburkhalter\Marisa\time.xls','Renamed','Dec 12 2008 9:49AM' UNION ALL
SELECT '34638','D:\Users\mburkhalter\Marisa\time.xls~RF3ba5ed9.TMP///D:\Users\mburkhalter\Marisa\time.xls','Renamed','Dec 12 2008 9:50AM' UNION ALL
SELECT '34698','D:\QuickBooks\Inventory\Inventory Control December 08.xls~RF13fe663d.TMP///D:\QuickBooks\Inventory\Inventory Control December 08','Renamed','Dec 12 2008 9:51AM' UNION ALL
SELECT '34900','D:\Manufacturing\Lisa M\Forms\Labels\File Lables.doc','Deleted','Dec 12 2008 10:06AM' UNION ALL
SELECT '34904','D:\Manufacturing\Lisa M\Forms\Labels\File Lables.doc','Created','Dec 12 2008 10:06AM' UNION ALL
SELECT '34906','D:\Accounting\BalanceSheetComparison\2008\Mfg-10-31-08.xls','Changed','Dec 12 2008 10:07AM' UNION ALL
SELECT '34907','D:\Accounting\BalanceSheetComparison\2008\Mfg-10-31-08.xls','Changed','Dec 12 2008 10:07AM' UNION ALL
SELECT '34908','D:\Accounting\BalanceSheetComparison\2008\Mfg-10-31-08.xls','Changed','Dec 12 2008 10:07AM' UNION ALL
SELECT '34909','D:\Accounting\BalanceSheetComparison\2008\Mfg-11-30-08.xls','Created','Dec 12 2008 10:08AM' UNION ALL
SELECT '34910','D:\Accounting\BalanceSheetComparison\2008\Mfg-11-30-08.xls','Deleted','Dec 12 2008 10:08AM' UNION ALL
SELECT '34924','D:\Accounting\BalanceSheetComparison\2008\Mfg-10-31-08.xls','Changed','Dec 12 2008 10:08AM' UNION ALL
SELECT '34942','D:\Accounting\BalanceSheetComparison\2008\Mfg-11-30-08.xls~RFf787a5db.TMP///D:\Accounting\BalanceSheetComparison\2008\Mfg-11-30-','Renamed','Dec 12 2008 10:08AM' UNION ALL
SELECT '34965','D:\Accounting\BalanceSheetComparison\2008\Mfg-11-30-08.xls~RFf78954d4.TMP///D:\Accounting\BalanceSheetComparison\2008\Mfg-11-30-','Renamed','Dec 12 2008 10:10AM' UNION ALL
SELECT '34987','D:\Accounting\BalanceSheetComparison\2008\Mfg-11-30-08.xls~RFf78af5b2.TMP///D:\Accounting\BalanceSheetComparison\2008\Mfg-11-30-','Renamed','Dec 12 2008 10:11AM' UNION ALL
SELECT '35014','D:\Accounting\BalanceSheetComparison\2008\Mfg-11-30-08.xls~RFf78d7827.TMP///D:\Accounting\BalanceSheetComparison\2008\Mfg-11-30-','Renamed','Dec 12 2008 10:14AM' UNION ALL
SELECT '35052','D:\Users\eburnett\aaquality wdi rev102606\aaawdi manufacturing qms\SECTION 6 MANF\WDIMQF 6014 REV A PERSONNENEL QUALIFICATION RE','Deleted','Dec 12 2008 10:22AM' UNION ALL
SELECT '35056','D:\Users\eburnett\aaquality wdi rev102606\aaawdi manufacturing qms\SECTION 6 MANF\WDIMQF 6014 REV A PERSONNENEL QUALIFICATION RE','Created','Dec 12 2008 10:22AM' UNION ALL
SELECT '35074','D:\Manufacturing\Lisa M\Credit Info\New Address.doc','Deleted','Dec 12 2008 10:23AM' UNION ALL
SELECT '35078','D:\Manufacturing\Lisa M\Credit Info\New Address.doc','Created','Dec 12 2008 10:23AM' UNION ALL
SELECT '35084','D:\Users\eburnett\aaquality wdi rev102606\aaawdi manufacturing qms\REVISIONS\WORKING\compantancy letter.doc','Deleted','Dec 12 2008 10:24AM' UNION ALL
SELECT '35088','D:\Users\eburnett\aaquality wdi rev102606\aaawdi manufacturing qms\REVISIONS\WORKING\compantancy letter.doc','Created','Dec 12 2008 10:24AM' UNION ALL
SELECT '35101','D:\Human Resources\Payroll tracker.xls','Changed','Dec 12 2008 10:25AM' UNION ALL
SELECT '35115','D:\Human Resources\Payroll tracker.xls','Changed','Dec 12 2008 10:25AM' UNION ALL
SELECT '35121','D:\Human Resources\Payroll tracker.xls~RF55096f96.TMP///D:\Human Resources\Payroll tracker.xls','Renamed','Dec 12 2008 10:25AM' UNION ALL
SELECT '35186','D:\QuickBooks\Inventory\Inventory Control November 08.xls','Changed','Dec 12 2008 10:30AM' UNION ALL
SELECT '35267','D:\QuickBooks\Inventory\Inventory Control November 08.xls','Changed','Dec 12 2008 10:31AM' UNION ALL
SELECT '35272','D:\QuickBooks\Inventory\Inventory Control November 08.xls~RF142386b2.TMP///D:\QuickBooks\Inventory\Inventory Control November 08','Renamed','Dec 12 2008 10:31AM' UNION ALL
SELECT '35295','D:\Users\mburkhalter\Marisa\time.xls','Changed','Dec 12 2008 10:34AM' UNION ALL
SELECT '35296','D:\Accounting\BalanceSheetComparison\2008\Canada-11-30-08.xls','Changed','Dec 12 2008 10:34AM' UNION ALL
SELECT '35440','D:\Manufacturing\Lisa M\Credit Info\CREDIT REFERENCES - MFG.doc','Deleted','Dec 12 2008 10:38AM' UNION ALL
SELECT '35444','D:\Manufacturing\Lisa M\Credit Info\CREDIT REFERENCES - MFG.doc','Created','Dec 12 2008 10:38AM' UNION ALL
SELECT '35448','D:\Manufacturing\Lisa M\Credit Info\CREDIT REFERENCES - MFG.doc','Deleted','Dec 12 2008 10:38AM' UNION ALL
SELECT '35452','D:\Manufacturing\Lisa M\Credit Info\CREDIT REFERENCES - MFG.doc','Created','Dec 12 2008 10:38AM' UNION ALL
SELECT '35467','D:\Manufacturing\Lisa M\Credit Info\WDI vs WDI Mfg.doc','Deleted','Dec 12 2008 10:39AM' UNION ALL
SELECT '35471','D:\Manufacturing\Lisa M\Credit Info\WDI vs WDI Mfg.doc','Created','Dec 12 2008 10:39AM' UNION ALL
SELECT '35485','D:\Users\eburnett\aaquality wdi rev102606\aaawdi manufacturing qms\SECTION 5 MANF\Management Review\MR 121008 WORKING.DOC','Deleted','Dec 12 2008 10:40AM' UNION ALL
SELECT '35489','D:\Users\eburnett\aaquality wdi rev102606\aaawdi manufacturing qms\SECTION 5 MANF\Management Review\MR 121008 WORKING.DOC','Created','Dec 12 2008 10:40AM' UNION ALL
SELECT '35510','D:\Users\mburkhalter\Marisa\time.xls','Changed','Dec 12 2008 10:41AM' UNION ALL
SELECT '35566','D:\Accounting\BalanceSheetComparison\2008\Canada-11-30-08.xls','Changed','Dec 12 2008 10:43AM' UNION ALL
SELECT '35571','D:\Accounting\BalanceSheetComparison\2008\Canada-11-30-08.xls~RF3eb833b.TMP///D:\Accounting\BalanceSheetComparison\2008\Canada-1','Renamed','Dec 12 2008 10:43AM' UNION ALL
SELECT '35575','D:\Accounting\BalanceSheetComparison\2008\Canada-10-31-08.xls','Changed','Dec 12 2008 10:43AM' UNION ALL
SELECT '35576','D:\Accounting\BalanceSheetComparison\2008\Canada-10-31-08.xls','Changed','Dec 12 2008 10:43AM' UNION ALL
SELECT '35580','D:\Users\eburnett\aaquality wdi rev102606\aaawdi manufacturing qms\SECTION 5 MANF\Management Review\MR 121008 WORKING.DOC','Deleted','Dec 12 2008 10:44AM' UNION ALL
SELECT '35584','D:\Users\eburnett\aaquality wdi rev102606\aaawdi manufacturing qms\SECTION 5 MANF\Management Review\MR 121008 WORKING.DOC','Created','Dec 12 2008 10:44AM' UNION ALL
SELECT '35585','D:\Accounting\BalanceSheetComparison\2008\Canada-11-30-08.xls','Changed','Dec 12 2008 10:44AM' UNION ALL
SELECT '35586','D:\Accounting\BalanceSheetComparison\2008\Canada-11-30-08.xls','Changed','Dec 12 2008 10:44AM' UNION ALL
SELECT '35591','D:\Accounting\BalanceSheetComparison\2008\Canada-11-30-08.xls','Changed','Dec 12 2008 10:44AM' UNION ALL
SELECT '35604','D:\Accounting\BalanceSheetComparison\2008\Canada-11-30-08.xls','Changed','Dec 12 2008 10:44AM' UNION ALL
SELECT '35609','D:\Accounting\BalanceSheetComparison\2008\Canada-11-30-08.xls~RF3ec6a01.TMP///D:\Accounting\BalanceSheetComparison\2008\Canada-1','Renamed','Dec 12 2008 10:44AM' UNION ALL
SELECT '35613','D:\Accounting\BalanceSheetComparison\2008\Canada-11-30-08.xls','Changed','Dec 12 2008 10:44AM' UNION ALL
SELECT '35614','D:\Accounting\BalanceSheetComparison\2008\Canada-11-30-08.xls','Changed','Dec 12 2008 10:44AM' UNION ALL
SELECT '35619','D:\Accounting\BalanceSheetComparison\2008\Canada-11-30-08.xls','Changed','Dec 12 2008 10:44AM' UNION ALL
SELECT '35632','D:\Accounting\BalanceSheetComparison\2008\Canada-11-30-08.xls','Changed','Dec 12 2008 10:45AM' UNION ALL
SELECT '35637','D:\Accounting\BalanceSheetComparison\2008\Canada-11-30-08.xls~RF3ed39d4.TMP///D:\Accounting\BalanceSheetComparison\2008\Canada-1','Renamed','Dec 12 2008 10:45AM' UNION ALL
SELECT '35641','D:\Accounting\BalanceSheetComparison\2008\Canada-11-30-08.xls','Changed','Dec 12 2008 10:46AM' UNION ALL
SELECT '35642','D:\Accounting\BalanceSheetComparison\2008\Canada-11-30-08.xls','Changed','Dec 12 2008 10:46AM' UNION ALL
SELECT '35647','D:\Accounting\BalanceSheetComparison\2008\Canada-11-30-08.xls','Changed','Dec 12 2008 10:46AM' UNION ALL
SELECT '35690','D:\Accounting\BalanceSheetComparison\2008\Canada-11-30-08.xls','Changed','Dec 12 2008 10:47AM' UNION ALL
SELECT '35695','D:\Accounting\BalanceSheetComparison\2008\Canada-11-30-08.xls~RF3ef3ce7.TMP///D:\Accounting\BalanceSheetComparison\2008\Canada-1','Renamed','Dec 12 2008 10:47AM' UNION ALL
SELECT '35715','D:\Accounting\BalanceSheetComparison\2008\Canada-11-30-08.xls~RF3ef5fa2.TMP///D:\Accounting\BalanceSheetComparison\2008\Canada-1','Renamed','Dec 12 2008 10:48AM' UNION ALL
SELECT '35720','D:\Accounting\BalanceSheetComparison\2008\Canada-11-30-08.xls','Changed','Dec 12 2008 10:48AM' UNION ALL
SELECT '35721','D:\Accounting\BalanceSheetComparison\2008\Canada-11-30-08.xls','Changed','Dec 12 2008 10:48AM' UNION ALL
SELECT '35726','D:\Accounting\BalanceSheetComparison\2008\Canada-11-30-08.xls','Changed','Dec 12 2008 10:48AM' UNION ALL
SELECT '35796','D:\Accounting\BalanceSheetComparison\2008\Canada-11-30-08.xls','Changed','Dec 12 2008 10:51AM' UNION ALL
SELECT '35801','D:\Accounting\BalanceSheetComparison\2008\Canada-11-30-08.xls~RF3f21e06.TMP///D:\Accounting\BalanceSheetComparison\2008\Canada-1','Renamed','Dec 12 2008 10:51AM' UNION ALL
SELECT '36487','D:\Users\wsun\Xunlei\ENGote.xls','Changed','Dec 12 2008 11:01AM' UNION ALL
SELECT '36492','D:\Users\wsun\Xunlei\ENGote.xls~RF143f5af7.TMP///D:\Users\wsun\Xunlei\ENGote.xls','Renamed','Dec 12 2008 11:01AM' UNION ALL
SELECT '36559','D:\Users\wsun\Xunlei\ENGote.xls~RF14445e3a.TMP///D:\Users\wsun\Xunlei\ENGote.xls','Renamed','Dec 12 2008 11:07AM' UNION ALL
SELECT '36702','D:\Human Resources\401K\~$1K Introductory letter.doc','Created','Dec 12 2008 11:17AM' UNION ALL
SELECT '36703','D:\Human Resources\401K\~$1K Introductory letter.doc','Changed','Dec 12 2008 11:17AM' UNION ALL
SELECT '36704','D:\Human Resources\401K\~$1K Introductory letter.doc','Changed','Dec 12 2008 11:17AM' UNION ALL
SELECT '36705','D:\Human Resources\401K\~$1K Introductory letter.doc','Changed','Dec 12 2008 11:17AM' UNION ALL
SELECT '36708','D:\Human Resources\401K\~$1K Introductory letter.doc','Deleted','Dec 12 2008 11:18AM' UNION ALL
SELECT '36722','D:\Manufacturing\INVENTORY CREDIT\1407.DOC','Created','Dec 12 2008 11:21AM' UNION ALL
SELECT '36736','D:\Human Resources\Trackers - 2008.xls','Changed','Dec 12 2008 11:22AM' UNION ALL
SELECT '36750','D:\Human Resources\Trackers - 2008.xls','Changed','Dec 12 2008 11:22AM' UNION ALL
SELECT '36756','D:\Human Resources\Trackers - 2008.xls~RF553cf8c3.TMP///D:\Human Resources\Trackers - 2008.xls','Renamed','Dec 12 2008 11:22AM' UNION ALL
SELECT '36764','D:\Manufacturing\INVENTORY CREDIT\1411.DOC','Created','Dec 12 2008 11:22AM' UNION ALL
SELECT '36807','D:\Manufacturing\WDI Mfg. Production 2008\Open WO.xls','Deleted','Dec 12 2008 11:26AM' UNION ALL
SELECT '36811','D:\Manufacturing\WDI Mfg. Production 2008\Open WO.xls','Created','Dec 12 2008 11:26AM' UNION ALL
SELECT '36815','D:\Manufacturing\WDI Mfg. Production 2008\Open WO.xls','Deleted','Dec 12 2008 11:26AM' UNION ALL
SELECT '36819','D:\Manufacturing\WDI Mfg. Production 2008\Open WO.xls','Created','Dec 12 2008 11:26AM' UNION ALL
SELECT '36886','D:\Manufacturing\QUALITY SYSTEM WDI MANUFACTURING\WDI MANF QUALITY SYSTEM PROCEDURES REV F 06-01-08\SECTION 6000\WDIMQF 6012 RE','Deleted','Dec 12 2008 11:33AM' UNION ALL
SELECT '36890','D:\Manufacturing\QUALITY SYSTEM WDI MANUFACTURING\WDI MANF QUALITY SYSTEM PROCEDURES REV F 06-01-08\SECTION 6000\WDIMQF 6012 RE','Created','Dec 12 2008 11:33AM' UNION ALL
SELECT '36923','D:\Warehouse\TOMBALL BACKORDER REPORT\Tomball Backorder Report.xls','Deleted','Dec 12 2008 11:36AM' UNION ALL
SELECT '36927','D:\Warehouse\TOMBALL BACKORDER REPORT\Tomball Backorder Report.xls','Created','Dec 12 2008 11:36AM' UNION ALL
SELECT '36931','D:\Manufacturing\WDI Mfg. Production 2008\Open WO.xls','Deleted','Dec 12 2008 11:36AM' UNION ALL
SELECT '36935','D:\Manufacturing\WDI Mfg. Production 2008\Open WO.xls','Created','Dec 12 2008 11:36AM' UNION ALL
SELECT '37664','D:\Warehouse\Tomball Warehouse\Cons. Inventory.xls','Deleted','Dec 12 2008 11:46AM' UNION ALL
SELECT '37668','D:\Warehouse\Tomball Warehouse\Cons. Inventory.xls','Created','Dec 12 2008 11:46AM' UNION ALL
SELECT '37970','D:\Warehouse\Tomball Warehouse\Cons. Inventory.xls','Deleted','Dec 12 2008 11:50AM' UNION ALL
SELECT '37974','D:\Warehouse\Tomball Warehouse\Cons. Inventory.xls','Created','Dec 12 2008 11:50AM' UNION ALL
SELECT '37976','D:\Warehouse\Tomball Warehouse\EAL.xls','Deleted','Dec 12 2008 11:50AM' UNION ALL
SELECT '37983','D:\Warehouse\Tomball Warehouse\EAL.xls','Created','Dec 12 2008 11:50AM' UNION ALL
SELECT '37987','D:\Warehouse\Tomball Warehouse\PDL.xls','Deleted','Dec 12 2008 11:50AM' UNION ALL
SELECT '37991','D:\Warehouse\Tomball Warehouse\PDL.xls','Created','Dec 12 2008 11:50AM' UNION ALL
SELECT '38015','D:\Users\chan\HR\Offer Letter - Cindy Johnson.doc','Created','Dec 12 2008 12:01PM' UNION ALL
SELECT '38038','D:\Users\chan\HR\~WRL3168.tmp///D:\Users\chan\HR\Offer Letter - Cindy Johnson.doc','Renamed','Dec 12 2008 12:01PM' UNION ALL
SELECT '38040','D:\Users\chan\HR\~$fer Letter - Cindy Johnson.doc','Created','Dec 12 2008 12:01PM' UNION ALL
SELECT '38041','D:\Users\chan\HR\~$fer Letter - Cindy Johnson.doc','Changed','Dec 12 2008 12:01PM' UNION ALL
SELECT '38042','D:\Users\chan\HR\~$fer Letter - Cindy Johnson.doc','Changed','Dec 12 2008 12:01PM' UNION ALL
SELECT '38043','D:\Users\chan\HR\~$fer Letter - Cindy Johnson.doc','Changed','Dec 12 2008 12:01PM' UNION ALL
SELECT '38048','D:\Users\chan\HR\~$fer Letter - Cindy Johnson.doc','Deleted','Dec 12 2008 12:01PM' UNION ALL
SELECT '38333','D:\Manufacturing\WDI Mfg. Production 2008\Open WO.xls','Deleted','Dec 12 2008 1:24PM' UNION ALL
SELECT '38337','D:\Manufacturing\WDI Mfg. Production 2008\Open WO.xls','Created','Dec 12 2008 1:24PM' UNION ALL
SELECT '38341','D:\Manufacturing\WDI Mfg. Production 2008\Open WO.xls','Deleted','Dec 12 2008 1:24PM' UNION ALL
SELECT '38345','D:\Manufacturing\WDI Mfg. Production 2008\Open WO.xls','Created','Dec 12 2008 1:24PM' UNION ALL
SELECT '38515','D:\Users\mcole\WDI COLLECTIONS\report 11-24.xls','Changed','Dec 12 2008 1:31PM' UNION ALL
SELECT '38516','D:\Users\mcole\WDI COLLECTIONS\report 11-24.xls','Changed','Dec 12 2008 1:31PM' UNION ALL
SELECT '38518','D:\Users\mcole\WDI COLLECTIONS\report 11-24.xls','Changed','Dec 12 2008 1:31PM' UNION ALL
SELECT '38550','D:\QuickBooks\COLLECTION\Weatherford\WEATHERFORD ACCOUNT STATUS.xls','Changed','Dec 12 2008 1:36PM' UNION ALL
SELECT '38551','D:\QuickBooks\COLLECTION\Weatherford\WEATHERFORD ACCOUNT STATUS.xls','Changed','Dec 12 2008 1:36PM' UNION ALL
SELECT '38552','D:\QuickBooks\COLLECTION\Statements\12-8-08 -JENNY.xls','Changed','Dec 12 2008 1:37PM' UNION ALL
SELECT '38553','D:\QuickBooks\COLLECTION\Statements\12-8-08 -JENNY.xls','Changed','Dec 12 2008 1:37PM' UNION ALL
SELECT '38554','D:\QuickBooks\COLLECTION\Statements\12-8-08 -JENNY.xls','Changed','Dec 12 2008 1:38PM' UNION ALL
SELECT '38560','D:\Users\eburnett\aaquality wdi rev102606\aaawdi manufacturing qms\SECTION 5 MANF\WDIMAN 5000.4.2 LETTER OF COMMENT.doc','Deleted','Dec 12 2008 1:39PM' UNION ALL
SELECT '38564','D:\Users\eburnett\aaquality wdi rev102606\aaawdi manufacturing qms\SECTION 5 MANF\WDIMAN 5000.4.2 LETTER OF COMMENT.doc','Created','Dec 12 2008 1:39PM' UNION ALL
SELECT '38690','D:\Users\eburnett\aaquality wdi rev102606\aaawdi manufacturing qms\QM WDI MANF REV C\qp WDI Manufacturing.doc','Deleted','Dec 12 2008 1:45PM' UNION ALL
SELECT '38694','D:\Users\eburnett\aaquality wdi rev102606\aaawdi manufacturing qms\QM WDI MANF REV C\qp WDI Manufacturing.doc','Created','Dec 12 2008 1:45PM' UNION ALL
SELECT '38695','D:\Human Resources\Personnel\Offer Letters\~$fer Letter - Cindy Johnson.doc','Created','Dec 12 2008 1:48PM' UNION ALL
SELECT '38696','D:\Human Resources\Personnel\Offer Letters\~$fer Letter - Cindy Johnson.doc','Changed','Dec 12 2008 1:48PM' UNION ALL
SELECT '38697','D:\Human Resources\Personnel\Offer Letters\~$fer Letter - Cindy Johnson.doc','Changed','Dec 12 2008 1:48PM' UNION ALL
SELECT '38698','D:\Human Resources\Personnel\Offer Letters\~$fer Letter - Cindy Johnson.doc','Changed','Dec 12 2008 1:48PM' UNION ALL
SELECT '38703','D:\Users\eburnett\aaquality wdi rev102606\aaawdi manufacturing qms\QM WDI MANF REV C\II OF IV WDIMQMINDEX Manf rev c 060108.DOC','Deleted','Dec 12 2008 1:49PM' UNION ALL
SELECT '38707','D:\Users\eburnett\aaquality wdi rev102606\aaawdi manufacturing qms\QM WDI MANF REV C\II OF IV WDIMQMINDEX Manf rev c 060108.DOC','Created','Dec 12 2008 1:49PM' UNION ALL
SELECT '38714','D:\Users\eburnett\aaquality wdi rev102606\aaawdi manufacturing qms\QM WDI MANF REV C\III OF IV WDI MANAGEMENT POLICY STATEMENT R','Deleted','Dec 12 2008 1:50PM' UNION ALL
SELECT '38718','D:\Users\eburnett\aaquality wdi rev102606\aaawdi manufacturing qms\QM WDI MANF REV C\III OF IV WDI MANAGEMENT POLICY STATEMENT R','Created','Dec 12 2008 1:50PM' UNION ALL
SELECT '38720','D:\Users\eburnett\aaquality wdi rev102606\aaawdi manufacturing qms\REVISIONS\WORKING\WDIMQF 5000.1.3 attach Organizational Char','Created','Dec 12 2008 1:52PM' UNION ALL
SELECT '38812','D:\Human Resources\Personnel\Offer Letters\~WRL1188.tmp///D:\Human Resources\Personnel\Offer Letters\Offer Letter - Cindy Johnso','Renamed','Dec 12 2008 1:57PM' UNION ALL
SELECT '38817','D:\Human Resources\Personnel\Offer Letters\~$fer Letter - Jamie Bednar.doc','Created','Dec 12 2008 1:57PM' UNION ALL
SELECT '38818','D:\Human Resources\Personnel\Offer Letters\~$fer Letter - Jamie Bednar.doc','Changed','Dec 12 2008 1:57PM' UNION ALL
SELECT '38819','D:\Human Resources\Personnel\Offer Letters\~$fer Letter - Jamie Bednar.doc','Changed','Dec 12 2008 1:57PM' UNION ALL
SELECT '38820','D:\Human Resources\Personnel\Offer Letters\~$fer Letter - Jamie Bednar.doc','Changed','Dec 12 2008 1:57PM' UNION ALL
SELECT '38843','D:\Human Resources\Personnel\Offer Letters\~WRL1268.tmp///D:\Human Resources\Personnel\Offer Letters\Offer Letter - Jamie Bednar','Renamed','Dec 12 2008 1:58PM' UNION ALL
SELECT '38848','D:\Human Resources\Personnel\Offer Letters\~$fer Letter - Jamie Bednar.doc','Deleted','Dec 12 2008 1:58PM' UNION ALL
SELECT '38850','D:\Human Resources\Personnel\Offer Letters\~$fer Letter - Cindy Johnson.doc','Deleted','Dec 12 2008 1:58PM' UNION ALL
SELECT '39079','D:\Manufacturing\QUALITY SYSTEM WDI MANUFACTURING\WDI MANF QUALITY SYSTEM PROCEDURES REV F 06-01-08\SECTION 6000\WDIMQF 6014 RE','Deleted','Dec 12 2008 2:08PM' UNION ALL
SELECT '39083','D:\Manufacturing\QUALITY SYSTEM WDI MANUFACTURING\WDI MANF QUALITY SYSTEM PROCEDURES REV F 06-01-08\SECTION 6000\WDIMQF 6014 RE','Created','Dec 12 2008 2:08PM' UNION ALL
SELECT '39087','D:\Users\wsun\Inventory\2008\11-30-08 Inventory Summary.xls','Created','Dec 12 2008 2:12PM' UNION ALL
SELECT '39088','D:\Users\wsun\Inventory\2008\11-30-08 Inventory Summary.xls','Deleted','Dec 12 2008 2:12PM' UNION ALL
SELECT '39153','D:\Users\mcole\WDI COLLECTIONS\report 11-24.xls','Changed','Dec 12 2008 2:16PM' UNION ALL
SELECT '39158','D:\Users\mcole\WDI COLLECTIONS\report 11-24.xls~RF33a86484.TMP///D:\Users\mcole\WDI COLLECTIONS\report 11-24.xls','Renamed','Dec 12 2008 2:16PM' UNION ALL
SELECT '39164','D:\Users\eburnett\aaquality wdi rev102606\aaawdi manufacturing qms\REVISIONS\WORKING\WDIMQF 5000.1.3 attach Organizational Char','Deleted','Dec 12 2008 2:16PM' UNION ALL
SELECT '39168','D:\Users\eburnett\aaquality wdi rev102606\aaawdi manufacturing qms\REVISIONS\WORKING\WDIMQF 5000.1.3 attach Organizational Char','Created','Dec 12 2008 2:16PM' UNION ALL
SELECT '39225','D:\Users\wsun\Inventory\2008\11-30-08 Inventory Summary.xls~RF14f2498b.TMP///D:\Users\wsun\Inventory\2008\11-30-08 Inventory Sum','Renamed','Dec 12 2008 2:17PM' UNION ALL
SELECT '39230','D:\Users\eburnett\aaquality wdi rev102606\aaawdi manufacturing qms\REVISIONS\WORKING\WDIMQF 5000.1.3 attach Organizational Char','Deleted','Dec 12 2008 2:18PM' UNION ALL
SELECT '39234','D:\Users\eburnett\aaquality wdi rev102606\aaawdi manufacturing qms\REVISIONS\WORKING\WDIMQF 5000.1.3 attach Organizational Char','Created','Dec 12 2008 2:18PM' UNION ALL
SELECT '39243','D:\Human Resources\Personnel\Employee list 2.xls','Changed','Dec 12 2008 2:19PM' UNION ALL
SELECT '39244','D:\Users\eburnett\aaquality wdi rev102606\aaawdi manufacturing qms\REVISIONS\WORKING\WDIMQF 5000.1.3 attach Organizational Char','Renamed','Dec 12 2008 2:19PM' UNION ALL
SELECT '39246','D:\Human Resources\Personnel\Employee list 2.xls','Changed','Dec 12 2008 2:20PM' UNION ALL
SELECT '39249','D:\Users\eburnett\aaquality wdi rev102606\aaawdi manufacturing qms\REVISIONS\WORKING\WDIMQF 5000.1.3 attach Organizational Char','Renamed','Dec 12 2008 2:20PM' UNION ALL
SELECT '39251','D:\Users\eburnett\aaquality wdi rev102606\aaawdi manufacturing qms\REVISIONS\WORKING\WDIMQF 5000.1.3 attach Organizational Char','Deleted','Dec 12 2008 2:20PM' UNION ALL
SELECT '39252','D:\Users\eburnett\aaquality wdi rev102606\aaawdi manufacturing qms\REVISIONS\COMPLETE READY\WDIMQF 5000.1.3 attach Organization','Created','Dec 12 2008 2:20PM' UNION ALL
SELECT '39278','D:\Users\wsun\Inventory\2008\11-30-08 Inventory Summary.xls~RF14f77083.TMP///D:\Users\wsun\Inventory\2008\11-30-08 Inventory Sum','Renamed','Dec 12 2008 2:23PM' UNION ALL
SELECT '39283','D:\Human Resources\Payroll\salaried employees 9-1.xls','Changed','Dec 12 2008 2:23PM' UNION ALL
SELECT '39284','D:\Human Resources\Payroll\salaried employees 9-1.xls','Changed','Dec 12 2008 2:23PM' UNION ALL
SELECT '39287','D:\Users\eburnett\aaquality wdi rev102606\aaawdi manufacturing qms\REVISIONS\COMPLETE READY\WDIMQF 5000.1.3 attach Organization','Deleted','Dec 12 2008 2:24PM' UNION ALL
SELECT '39291','D:\Users\eburnett\aaquality wdi rev102606\aaawdi manufacturing qms\REVISIONS\COMPLETE READY\WDIMQF 5000.1.3 attach Organization','Created','Dec 12 2008 2:24PM' UNION ALL
SELECT '39296','D:\Manufacturing\WDI Mfg. Production 2008\Open WO.xls','Deleted','Dec 12 2008 2:25PM' UNION ALL
SELECT '39300','D:\Manufacturing\WDI Mfg. Production 2008\Open WO.xls','Created','Dec 12 2008 2:25PM' UNION ALL
SELECT '39360','D:\Warehouse\Tomball Warehouse\Cons. Inventory.xls','Deleted','Dec 12 2008 2:34PM' UNION ALL
SELECT '39364','D:\Warehouse\Tomball Warehouse\Cons. Inventory.xls','Created','Dec 12 2008 2:34PM' UNION ALL
SELECT '39444','D:\Users\wsun\Inventory\2008\10-31-08 Inventory Summary.xls','Changed','Dec 12 2008 2:38PM' UNION ALL
SELECT '39472','D:\Users\wsun\Inventory\2008\10-31-08 Inventory Summary.xls','Changed','Dec 12 2008 2:44PM' UNION ALL
SELECT '39474','D:\Users\wsun\Inventory\2008\10-31-08 Inventory Report.xls','Changed','Dec 12 2008 2:44PM' UNION ALL
SELECT '39489','D:\Users\wsun\Inventory\2008\10-31-08 Inventory Report.xls','Changed','Dec 12 2008 2:45PM' UNION ALL
SELECT '39494','D:\Users\wsun\Inventory\2008\10-31-08 Inventory Report.xls~RF150c2b85.TMP///D:\Users\wsun\Inventory\2008\10-31-08 Inventory Repo','Renamed','Dec 12 2008 2:45PM' UNION ALL
SELECT '39516','D:\Users\wsun\Inventory\2008\11-30-08 Inventory Summary.xls~RF150c3af6.TMP///D:\Users\wsun\Inventory\2008\11-30-08 Inventory Sum','Renamed','Dec 12 2008 2:45PM' UNION ALL
SELECT '40631','D:\Users\wsun\Inventory\2008\11-30-08 Inventory Summary.xls~RF15134499.TMP///D:\Users\wsun\Inventory\2008\11-30-08 Inventory Sum','Renamed','Dec 12 2008 2:53PM' UNION ALL
SELECT '40637','D:\Users\wsun\Inventory\2008\11-30-08 Inventory Report.xls','Created','Dec 12 2008 2:53PM' UNION ALL
SELECT '40638','D:\Users\wsun\Inventory\2008\11-30-08 Inventory Report.xls','Deleted','Dec 12 2008 2:53PM' UNION ALL
SELECT '40672','D:\Warehouse\Tomball Warehouse\Cons. Inventory.xls','Deleted','Dec 12 2008 2:56PM' UNION ALL
SELECT '40676','D:\Warehouse\Tomball Warehouse\Cons. Inventory.xls','Created','Dec 12 2008 2:56PM' UNION ALL
SELECT '40725','D:\MTR\11-15-2008\08-11-15_WDI--LIST1\~$-15120.doc','Created','Dec 12 2008 3:03PM' UNION ALL
SELECT '40726','D:\MTR\11-15-2008\08-11-15_WDI--LIST1\~$-15120.doc','Changed','Dec 12 2008 3:03PM' UNION ALL
SELECT '40753','D:\Manufacturing\WDI Mfg. Production 2008\Open WO.xls','Deleted','Dec 12 2008 3:05PM' UNION ALL
SELECT '40757','D:\Manufacturing\WDI Mfg. Production 2008\Open WO.xls','Created','Dec 12 2008 3:05PM' UNION ALL
SELECT '40771','D:\Human Resources\Insurance Forms\~$tice to Remove Dependent.doc','Created','Dec 12 2008 3:10PM' UNION ALL
SELECT '40772','D:\Human Resources\Insurance Forms\~$tice to Remove Dependent.doc','Changed','Dec 12 2008 3:10PM' UNION ALL
SELECT '40773','D:\Human Resources\Insurance Forms\~$tice to Remove Dependent.doc','Changed','Dec 12 2008 3:10PM' UNION ALL
SELECT '40774','D:\Human Resources\Insurance Forms\~$tice to Remove Dependent.doc','Changed','Dec 12 2008 3:10PM' UNION ALL
SELECT '40797','D:\Human Resources\Insurance Forms\~WRL2531.tmp///D:\Human Resources\Insurance Forms\Notice to Remove Dependent.doc','Renamed','Dec 12 2008 3:10PM' UNION ALL
SELECT '40802','D:\Human Resources\Insurance Forms\~$tice to Remove Dependent.doc','Deleted','Dec 12 2008 3:10PM' UNION ALL
SELECT '40807','D:\Human Resources\Insurance Forms\~$tice to Remove Dependent.doc','Created','Dec 12 2008 3:11PM' UNION ALL
SELECT '40808','D:\Human Resources\Insurance Forms\~$tice to Remove Dependent.doc','Changed','Dec 12 2008 3:11PM' UNION ALL
SELECT '40809','D:\Human Resources\Insurance Forms\~$tice to Remove Dependent.doc','Changed','Dec 12 2008 3:11PM' UNION ALL
SELECT '40810','D:\Human Resources\Insurance Forms\~$tice to Remove Dependent.doc','Changed','Dec 12 2008 3:11PM' UNION ALL
SELECT '40839','D:\Human Resources\Insurance Forms\~WRL2941.tmp///D:\Human Resources\Insurance Forms\Notice to Remove Dependent.doc','Renamed','Dec 12 2008 3:11PM' UNION ALL
SELECT '40845','D:\Human Resources\Insurance Forms\~$tice to Remove Dependent.doc','Deleted','Dec 12 2008 3:11PM' UNION ALL
SELECT '40913','D:\MTR\11-15-2008\08-11-15_WDI--LIST1\~$-28253.doc','Created','Dec 12 2008 3:13PM' UNION ALL
SELECT '40914','D:\MTR\11-15-2008\08-11-15_WDI--LIST1\~$-28253.doc','Changed','Dec 12 2008 3:13PM' UNION ALL
SELECT '40916','D:\MTR\11-15-2008\08-11-15_WDI--LIST1\~$-CA009.doc','Created','Dec 12 2008 3:13PM' UNION ALL
SELECT '40917','D:\MTR\11-15-2008\08-11-15_WDI--LIST1\~$-CA009.doc','Changed','Dec 12 2008 3:13PM' UNION ALL
SELECT '40919','D:\MTR\11-15-2008\08-11-15_WDI--LIST1\~$-10500.doc','Created','Dec 12 2008 3:13PM' UNION ALL
SELECT '40920','D:\MTR\11-15-2008\08-11-15_WDI--LIST1\~$-10500.doc','Changed','Dec 12 2008 3:13PM' UNION ALL
SELECT '40923','D:\MTR\11-15-2008\08-11-15_WDI--LIST1\~$-43336.doc','Created','Dec 12 2008 3:13PM' UNION ALL
SELECT '40924','D:\MTR\11-15-2008\08-11-15_WDI--LIST1\~$-43336.doc','Changed','Dec 12 2008 3:13PM' UNION ALL
SELECT '40927','D:\MTR\11-15-2008\08-11-15_WDI--LIST1\~$-43338.doc','Created','Dec 12 2008 3:13PM' UNION ALL
SELECT '40928','D:\MTR\11-15-2008\08-11-15_WDI--LIST1\~$-43338.doc','Changed','Dec 12 2008 3:13PM' UNION ALL
SELECT '40932','D:\MTR\11-15-2008\08-11-15_WDI--LIST1\~$-89012.doc','Created','Dec 12 2008 3:13PM' UNION ALL
SELECT '40933','D:\MTR\11-15-2008\08-11-15_WDI--LIST1\~$-89012.doc','Changed','Dec 12 2008 3:13PM' UNION ALL
SELECT '40936','D:\MTR\11-15-2008\08-11-15_WDI--LIST1\~$-89375.doc','Created','Dec 12 2008 3:14PM' UNION ALL
SELECT '40937','D:\MTR\11-15-2008\08-11-15_WDI--LIST1\~$-89375.doc','Changed','Dec 12 2008 3:14PM' UNION ALL
SELECT '40939','D:\MTR\11-15-2008\08-11-15_WDI--LIST1\~$-93012.doc','Created','Dec 12 2008 3:14PM' UNION ALL
SELECT '40940','D:\MTR\11-15-2008\08-11-15_WDI--LIST1\~$-93012.doc','Changed','Dec 12 2008 3:14PM' UNION ALL
SELECT '40942','D:\MTR\11-15-2008\08-11-15_WDI--LIST1\~$-23989A.doc','Created','Dec 12 2008 3:14PM' UNION ALL
SELECT '40943','D:\MTR\11-15-2008\08-11-15_WDI--LIST1\~$-23989A.doc','Changed','Dec 12 2008 3:14PM' UNION ALL
SELECT '40945','D:\MTR\11-15-2008\08-11-15_WDI--LIST1\~$-36483A.doc','Created','Dec 12 2008 3:14PM' UNION ALL
SELECT '40946','D:\MTR\11-15-2008\08-11-15_WDI--LIST1\~$-36483A.doc','Changed','Dec 12 2008 3:14PM' UNION ALL
SELECT '40958','D:\MTR\11-15-2008\08-11-15_WDI--LIST1\~$-88396A.doc','Created','Dec 12 2008 3:14PM' UNION ALL
SELECT '40959','D:\MTR\11-15-2008\08-11-15_WDI--LIST1\~$-88396A.doc','Changed','Dec 12 2008 3:14PM' UNION ALL
SELECT '40982','D:\Users\lmentzer\2008 Xmas list.xls','Created','Dec 12 2008 3:20PM' UNION ALL
SELECT '41008','D:\MTR\11-15-2008\08-11-15_WDI--LIST1\~$-00001.doc','Created','Dec 12 2008 3:24PM' UNION ALL
SELECT '41009','D:\MTR\11-15-2008\08-11-15_WDI--LIST1\~$-00001.doc','Changed','Dec 12 2008 3:24PM' UNION ALL
SELECT '41090','D:\QuickBooks\Inventory\Inventory Control December 08.xls~RF1531b1d8.TMP///D:\QuickBooks\Inventory\Inventory Control December 08','Renamed','Dec 12 2008 3:26PM' UNION ALL
SELECT '41113','D:\Users\mcole\WDI COLLECTIONS\report 11-24.xls~RF33ee51e2.TMP///D:\Users\mcole\WDI COLLECTIONS\report 11-24.xls','Renamed','Dec 12 2008 3:33PM' UNION ALL
SELECT '41122','D:\MTR\11-15-2008\08-11-15_WDI--LIST1\~$-08260.doc','Created','Dec 12 2008 3:35PM' UNION ALL
SELECT '41123','D:\MTR\11-15-2008\08-11-15_WDI--LIST1\~$-08260.doc','Changed','Dec 12 2008 3:35PM' UNION ALL
SELECT '41125','D:\MTR\11-15-2008\08-11-15_WDI--LIST1\~$-09773.doc','Created','Dec 12 2008 3:35PM' UNION ALL
SELECT '41126','D:\MTR\11-15-2008\08-11-15_WDI--LIST1\~$-09773.doc','Changed','Dec 12 2008 3:35PM' UNION ALL
SELECT '41128','D:\MTR\11-15-2008\08-11-15_WDI--LIST1\~$-09776.doc','Created','Dec 12 2008 3:35PM' UNION ALL
SELECT '41129','D:\MTR\11-15-2008\08-11-15_WDI--LIST1\~$-09776.doc','Changed','Dec 12 2008 3:35PM' UNION ALL
SELECT '41135','D:\Users\mburkhalter\Marisa\time.xls','Changed','Dec 12 2008 3:38PM' UNION ALL
SELECT '41137','D:\Accounting\BalanceSheetComparison\2008\WDI-11-30-08.xls','Changed','Dec 12 2008 3:39PM' UNION ALL
SELECT '41150','D:\Accounting\BalanceSheetComparison\2008\WDI-11-30-08.xls','Changed','Dec 12 2008 3:40PM' UNION ALL
SELECT '41155','D:\Accounting\BalanceSheetComparison\2008\WDI-11-30-08.xls~RF4fb0843.TMP///D:\Accounting\BalanceSheetComparison\2008\WDI-11-30-0','Renamed','Dec 12 2008 3:40PM' UNION ALL
SELECT '41271','D:\MTR\11-15-2008\08-11-15_WDI--LIST1\~$-43829.doc','Created','Dec 12 2008 3:45PM' UNION ALL
SELECT '41272','D:\MTR\11-15-2008\08-11-15_WDI--LIST1\~$-43829.doc','Changed','Dec 12 2008 3:45PM' UNION ALL
SELECT '41274','D:\MTR\11-15-2008\08-11-15_WDI--LIST1\~$-46051.doc','Created','Dec 12 2008 3:45PM' UNION ALL
SELECT '41275','D:\MTR\11-15-2008\08-11-15_WDI--LIST1\~$-46051.doc','Changed','Dec 12 2008 3:45PM' UNION ALL
SELECT '41305','D:\Users\mburkhalter\Marisa\time.xls','Changed','Dec 12 2008 3:48PM' UNION ALL
SELECT '41310','D:\Users\mburkhalter\Marisa\time.xls~RF502bf2d.TMP///D:\Users\mburkhalter\Marisa\time.xls','Renamed','Dec 12 2008 3:48PM' UNION ALL
SELECT '41385','D:\Accounting\BalanceSheetComparison\2008\WDI-11-30-08.xls~RF5044253.TMP///D:\Accounting\BalanceSheetComparison\2008\WDI-11-30-0','Renamed','Dec 12 2008 3:50PM' UNION ALL
SELECT '41407','D:\Accounting\BalanceSheetComparison\2008\WDI-11-30-08.xls~RF504f69f.TMP///D:\Accounting\BalanceSheetComparison\2008\WDI-11-30-0','Renamed','Dec 12 2008 3:51PM' UNION ALL
SELECT '41426','D:\Accounting\BalanceSheetComparison\2008\WDI-11-30-08.xls~RF5051293.TMP///D:\Accounting\BalanceSheetComparison\2008\WDI-11-30-0','Renamed','Dec 12 2008 3:51PM' UNION ALL
SELECT '41467','D:\Accounting\BalanceSheetComparison\2008\WDI-11-30-08.xls~RF50689b2.TMP///D:\Accounting\BalanceSheetComparison\2008\WDI-11-30-0','Renamed','Dec 12 2008 3:52PM' UNION ALL
SELECT '41584','D:\Accounting\BalanceSheetComparison\2008\WDI-11-30-08.xls~RF507c772.TMP///D:\Accounting\BalanceSheetComparison\2008\WDI-11-30-0','Renamed','Dec 12 2008 3:54PM' UNION ALL
SELECT '41630','D:\Accounting\BalanceSheetComparison\2008\WDI-10-31-08.xls','Changed','Dec 12 2008 3:54PM' UNION ALL
SELECT '41631','D:\Accounting\BalanceSheetComparison\2008\WDI-10-31-08.xls','Changed','Dec 12 2008 3:54PM' UNION ALL
SELECT '41642','D:\Accounting\BalanceSheetComparison\2008\WDI-11-30-08.xls','Changed','Dec 12 2008 3:54PM' UNION ALL
SELECT '41643','D:\Accounting\BalanceSheetComparison\2008\WDI-11-30-08.xls','Changed','Dec 12 2008 3:54PM' UNION ALL
SELECT '41644','D:\Accounting\BalanceSheetComparison\2008\WDI-11-30-08.xls','Changed','Dec 12 2008 3:54PM' UNION ALL
SELECT '41661','D:\Accounting\BalanceSheetComparison\2008\WDI-11-30-08.xls','Changed','Dec 12 2008 3:55PM' UNION ALL
SELECT '41666','D:\Accounting\BalanceSheetComparison\2008\WDI-11-30-08.xls~RF508ef58.TMP///D:\Accounting\BalanceSheetComparison\2008\WDI-11-30-0','Renamed','Dec 12 2008 3:55PM' UNION ALL
SELECT '41688','D:\Accounting\BalanceSheetComparison\2008\WDI-11-30-08.xls~RF5097ea8.TMP///D:\Accounting\BalanceSheetComparison\2008\WDI-11-30-0','Renamed','Dec 12 2008 3:56PM' UNION ALL
SELECT '41691','D:\MTR\11-15-2008\08-11-15_WDI--LIST1\~$-A5P22.doc','Created','Dec 12 2008 3:56PM' UNION ALL
SELECT '41692','D:\MTR\11-15-2008\08-11-15_WDI--LIST1\~$-A5P22.doc','Changed','Dec 12 2008 3:56PM' UNION ALL
SELECT '41765','D:\Accounting\BalanceSheetComparison\2008\WDI-11-30-08.xls~RF50cdab4.TMP///D:\Accounting\BalanceSheetComparison\2008\WDI-11-30-0','Renamed','Dec 12 2008 3:59PM' UNION ALL
SELECT '41786','D:\Accounting\BalanceSheetComparison\2008\WDI-11-30-08.xls~RF50d5080.TMP///D:\Accounting\BalanceSheetComparison\2008\WDI-11-30-0','Renamed','Dec 12 2008 4:00PM' UNION ALL
SELECT '41825','D:\Accounting\BalanceSheetComparison\2008\WDI-11-30-08.xls~RF50ed7db.TMP///D:\Accounting\BalanceSheetComparison\2008\WDI-11-30-0','Renamed','Dec 12 2008 4:01PM' UNION ALL
SELECT '41844','D:\Accounting\BalanceSheetComparison\2008\WDI-11-30-08.xls~RF50f5d09.TMP///D:\Accounting\BalanceSheetComparison\2008\WDI-11-30-0','Renamed','Dec 12 2008 4:02PM' UNION ALL
SELECT '41864','D:\Accounting\BalanceSheetComparison\2008\WDI-11-30-08.xls~RF510753f.TMP///D:\Accounting\BalanceSheetComparison\2008\WDI-11-30-0','Renamed','Dec 12 2008 4:03PM' UNION ALL
SELECT '41884','D:\Accounting\BalanceSheetComparison\2008\WDI-11-30-08.xls~RF5113091.TMP///D:\Accounting\BalanceSheetComparison\2008\WDI-11-30-0','Renamed','Dec 12 2008 4:04PM' UNION ALL
SELECT '41909','D:\Accounting\BalanceSheetComparison\2008\WDI-11-30-08.xls~RF511dc22.TMP///D:\Accounting\BalanceSheetComparison\2008\WDI-11-30-0','Renamed','Dec 12 2008 4:05PM' UNION ALL
SELECT '41928','D:\Accounting\BalanceSheetComparison\2008\WDI-11-30-08.xls~RF512644e.TMP///D:\Accounting\BalanceSheetComparison\2008\WDI-11-30-0','Renamed','Dec 12 2008 4:05PM' UNION ALL
SELECT '41936','D:\MTR\11-15-2008\08-11-15_WDI--LIST1\~$-10200.doc','Created','Dec 12 2008 4:06PM' UNION ALL
SELECT '41937','D:\MTR\11-15-2008\08-11-15_WDI--LIST1\~$-10200.doc','Changed','Dec 12 2008 4:06PM' UNION ALL
SELECT '41939','D:\MTR\11-15-2008\08-11-15_WDI--LIST1\~$-10250.doc','Created','Dec 12 2008 4:06PM' UNION ALL
SELECT '41940','D:\MTR\11-15-2008\08-11-15_WDI--LIST1\~$-10250.doc','Changed','Dec 12 2008 4:06PM' UNION ALL
SELECT '41942','D:\MTR\11-15-2008\08-11-15_WDI--LIST1\~$-12700-01.doc','Created','Dec 12 2008 4:06PM' UNION ALL
SELECT '41943','D:\MTR\11-15-2008\08-11-15_WDI--LIST1\~$-12700-01.doc','Changed','Dec 12 2008 4:06PM' UNION ALL
SELECT '41945','D:\MTR\11-15-2008\08-11-15_WDI--LIST1\~$-12700-02.doc','Created','Dec 12 2008 4:06PM' UNION ALL
SELECT '41946','D:\MTR\11-15-2008\08-11-15_WDI--LIST1\~$-12700-02.doc','Changed','Dec 12 2008 4:06PM' UNION ALL
SELECT '41948','D:\MTR\11-15-2008\08-11-15_WDI--LIST1\~$-22270-01.doc','Created','Dec 12 2008 4:07PM' UNION ALL
SELECT '41949','D:\MTR\11-15-2008\08-11-15_WDI--LIST1\~$-22270-01.doc','Changed','Dec 12 2008 4:07PM' UNION ALL
SELECT '41952','D:\Accounting\BalanceSheetComparison\2008\WDI-11-30-08.xls','Changed','Dec 12 2008 4:07PM' UNION ALL
SELECT '41953','D:\Accounting\BalanceSheetComparison\2008\WDI-11-30-08.xls','Changed','Dec 12 2008 4:07PM' UNION ALL
SELECT '41954','D:\Accounting\BalanceSheetComparison\2008\WDI-11-30-08.xls','Changed','Dec 12 2008 4:07PM' UNION ALL
SELECT '41967','D:\Accounting\BalanceSheetComparison\2008\WDI-11-30-08.xls','Changed','Dec 12 2008 4:07PM' UNION ALL
SELECT '41972','D:\Accounting\BalanceSheetComparison\2008\WDI-11-30-08.xls~RF5144b8c.TMP///D:\Accounting\BalanceSheetComparison\2008\WDI-11-30-0','Renamed','Dec 12 2008 4:07PM' UNION ALL
SELECT '41976','D:\Accounting\BalanceSheetComparison\2008\WDI-11-30-08.xls','Changed','Dec 12 2008 4:08PM' UNION ALL
SELECT '41977','D:\Accounting\BalanceSheetComparison\2008\WDI-11-30-08.xls','Changed','Dec 12 2008 4:08PM' UNION ALL
SELECT '41978','D:\Accounting\BalanceSheetComparison\2008\WDI-11-30-08.xls','Changed','Dec 12 2008 4:08PM' UNION ALL
SELECT '41991','D:\Accounting\BalanceSheetComparison\2008\WDI-11-30-08.xls','Changed','Dec 12 2008 4:08PM' UNION ALL
SELECT '41996','D:\Accounting\BalanceSheetComparison\2008\WDI-11-30-08.xls~RF5154a8d.TMP///D:\Accounting\BalanceSheetComparison\2008\WDI-11-30-0','Renamed','Dec 12 2008 4:08PM' UNION ALL
SELECT '42000','D:\Accounting\BalanceSheetComparison\2008\WDI-11-30-08.xls','Changed','Dec 12 2008 4:09PM' UNION ALL
SELECT '42001','D:\Accounting\BalanceSheetComparison\2008\WDI-11-30-08.xls','Changed','Dec 12 2008 4:09PM' UNION ALL
SELECT '42002','D:\Accounting\BalanceSheetComparison\2008\WDI-11-30-08.xls','Changed','Dec 12 2008 4:09PM' UNION ALL
SELECT '42015','D:\Accounting\BalanceSheetComparison\2008\WDI-11-30-08.xls','Changed','Dec 12 2008 4:09PM' UNION ALL
SELECT '42020','D:\Accounting\BalanceSheetComparison\2008\WDI-11-30-08.xls~RF5161c45.TMP///D:\Accounting\BalanceSheetComparison\2008\WDI-11-30-0','Renamed','Dec 12 2008 4:09PM' UNION ALL
SELECT '42024','D:\Accounting\BalanceSheetComparison\2008\WDI-11-30-08.xls','Changed','Dec 12 2008 4:10PM' UNION ALL
SELECT '42025','D:\Accounting\BalanceSheetComparison\2008\WDI-11-30-08.xls','Changed','Dec 12 2008 4:10PM' UNION ALL
SELECT '42029','D:\Accounting\BalanceSheetComparison\2008\WDI-11-30-08.xls','Changed','Dec 12 2008 4:10PM' UNION ALL
SELECT '42030','D:\Accounting\BalanceSheetComparison\2008\WDI-11-30-08.xls','Changed','Dec 12 2008 4:10PM' UNION ALL
SELECT '42031','D:\Accounting\BalanceSheetComparison\2008\WDI-11-30-08.xls','Changed','Dec 12 2008 4:10PM' UNION ALL
SELECT '42045','D:\Accounting\BalanceSheetComparison\2008\WDI-11-30-08.xls','Changed','Dec 12 2008 4:11PM' UNION ALL
SELECT '42050','D:\Accounting\BalanceSheetComparison\2008\WDI-11-30-08.xls~RF517a352.TMP///D:\Accounting\BalanceSheetComparison\2008\WDI-11-30-0','Renamed','Dec 12 2008 4:11PM' UNION ALL
SELECT '42053','D:\Human Resources\Trackers - 2008.xls','Changed','Dec 12 2008 4:14PM' UNION ALL
SELECT '42059','D:\Accounting\Comerica BBC\BBR 11-30-08\11-30-08 Inventory Report.xls','Created','Dec 12 2008 4:16PM' UNION ALL
SELECT '42060','D:\Accounting\Comerica BBC\BBR 11-30-08\11-30-08 Inventory Report.xls','Deleted','Dec 12 2008 4:16PM' UNION ALL
SELECT '42092','D:\Human Resources\Trackers - 2008.xls','Changed','Dec 12 2008 4:16PM' UNION ALL
SELECT '42098','D:\Human Resources\Trackers - 2008.xls~RF564a19fa.TMP///D:\Human Resources\Trackers - 2008.xls','Renamed','Dec 12 2008 4:16PM' UNION ALL
SELECT '42139','D:\Human Resources\Trackers - 2008.xls~RF564aafe1.TMP///D:\Human Resources\Trackers - 2008.xls','Renamed','Dec 12 2008 4:16PM' UNION ALL
SELECT '42155','D:\MTR\11-15-2008\08-11-15_WDI--LIST1\~$-22270-02.doc','Created','Dec 12 2008 4:17PM' UNION ALL
SELECT '42156','D:\MTR\11-15-2008\08-11-15_WDI--LIST1\~$-22270-02.doc','Changed','Dec 12 2008 4:17PM' UNION ALL
SELECT '42174','D:\Users\mburkhalter\Marisa\time.xls','Changed','Dec 12 2008 4:18PM' UNION ALL
SELECT '42192','D:\Users\mburkhalter\Marisa\time.xls','Changed','Dec 12 2008 4:18PM' UNION ALL
SELECT '42198','D:\Users\mburkhalter\Marisa\time.xls~RF51e049f.TMP///D:\Users\mburkhalter\Marisa\time.xls','Renamed','Dec 12 2008 4:18PM' UNION ALL
SELECT '42220','D:\Accounting\BalanceSheetComparison\2008\WDI-11-30-08.xls~RF51e8fc8.TMP///D:\Accounting\BalanceSheetComparison\2008\WDI-11-30-0','Renamed','Dec 12 2008 4:19PM' UNION ALL
SELECT '42247','D:\Accounting\BalanceSheetComparison\2008\WDI-11-30-08.xls~RF51f8b10.TMP///D:\Accounting\BalanceSheetComparison\2008\WDI-11-30-0','Renamed','Dec 12 2008 4:20PM' UNION ALL
SELECT '42273','D:\Human Resources\Trackers - 2008.xls~RF564fcb31.TMP///D:\Human Resources\Trackers - 2008.xls','Renamed','Dec 12 2008 4:22PM' UNION ALL
SELECT '42299','D:\Human Resources\Trackers - 2008.xls~RF5650464d.TMP///D:\Human Resources\Trackers - 2008.xls','Renamed','Dec 12 2008 4:22PM' UNION ALL
SELECT '42341','D:\Accounting\BalanceSheetComparison\2008\WDI-11-30-08.xls~RF5232abd.TMP///D:\Accounting\BalanceSheetComparison\2008\WDI-11-30-0','Renamed','Dec 12 2008 4:24PM' UNION ALL
SELECT '42347','D:\Accounting\BalanceSheetComparison\2008\WDI-11-30-08.xls','Changed','Dec 12 2008 4:24PM' UNION ALL
SELECT '42348','D:\Accounting\BalanceSheetComparison\2008\WDI-11-30-08.xls','Changed','Dec 12 2008 4:24PM' UNION ALL
SELECT '42349','D:\Accounting\BalanceSheetComparison\2008\WDI-11-30-08.xls','Changed','Dec 12 2008 4:24PM' UNION ALL
SELECT '42444','D:\Accounting\BalanceSheetComparison\2008\WDI-11-30-08.xls','Changed','Dec 12 2008 4:25PM' UNION ALL
SELECT '42451','D:\Accounting\BalanceSheetComparison\2008\WDI-11-30-08.xls~RF524cc57.TMP///D:\Accounting\BalanceSheetComparison\2008\WDI-11-30-0','Renamed','Dec 12 2008 4:25PM' UNION ALL
SELECT '42486','D:\Accounting\BalanceSheetComparison\2008\WDI-11-30-08.xls~RF524f03b.TMP///D:\Accounting\BalanceSheetComparison\2008\WDI-11-30-0','Renamed','Dec 12 2008 4:26PM' UNION ALL
SELECT '42512','D:\Accounting\BalanceSheetComparison\2008\WDI-11-30-08.xls','Changed','Dec 12 2008 4:26PM' UNION ALL
SELECT '42513','D:\Accounting\BalanceSheetComparison\2008\WDI-11-30-08.xls','Changed','Dec 12 2008 4:26PM' UNION ALL
SELECT '42516','D:\Accounting\BalanceSheetComparison\2008\WDI-11-30-08.xls','Changed','Dec 12 2008 4:26PM' UNION ALL
SELECT '42531','D:\QuickBooks\COLLECTION\Statements\12-8-08 -JENNY.xls','Changed','Dec 12 2008 4:26PM' UNION ALL
SELECT '42536','D:\QuickBooks\COLLECTION\Statements\12-8-08 -JENNY.xls~RF167c2b87.TMP///D:\QuickBooks\COLLECTION\Statements\12-8-08 -JENNY.xls','Renamed','Dec 12 2008 4:26PM' UNION ALL
SELECT '42564','D:\MTR\11-15-2008\08-11-15_WDI--LIST1\~$-31115-01.doc','Created','Dec 12 2008 4:27PM' UNION ALL
SELECT '42565','D:\MTR\11-15-2008\08-11-15_WDI--LIST1\~$-31115-01.doc','Changed','Dec 12 2008 4:27PM' UNION ALL
SELECT '42579','D:\Accounting\BalanceSheetComparison\2008\WDI-11-30-08.xls','Changed','Dec 12 2008 4:27PM' UNION ALL
SELECT '42584','D:\Accounting\BalanceSheetComparison\2008\WDI-11-30-08.xls~RF5266aa6.TMP///D:\Accounting\BalanceSheetComparison\2008\WDI-11-30-0','Renamed','Dec 12 2008 4:27PM' UNION ALL
SELECT '42588','D:\MTR\11-15-2008\08-11-15_WDI--LIST1\~$-31115-02.doc','Created','Dec 12 2008 4:27PM' UNION ALL
SELECT '42589','D:\MTR\11-15-2008\08-11-15_WDI--LIST1\~$-31115-02.doc','Changed','Dec 12 2008 4:27PM' UNION ALL
SELECT '42591','D:\MTR\11-15-2008\08-11-15_WDI--LIST1\~$-31117-01.doc','Created','Dec 12 2008 4:27PM' UNION ALL
SELECT '42592','D:\MTR\11-15-2008\08-11-15_WDI--LIST1\~$-31117-01.doc','Changed','Dec 12 2008 4:27PM' UNION ALL
SELECT '42594','D:\MTR\11-15-2008\08-11-15_WDI--LIST1\~$-31117-02.doc','Created','Dec 12 2008 4:27PM' UNION ALL
SELECT '42595','D:\MTR\11-15-2008\08-11-15_WDI--LIST1\~$-31117-02.doc','Changed','Dec 12 2008 4:27PM' UNION ALL
SELECT '42597','D:\Users\mburkhalter\Marisa\time.xls','Changed','Dec 12 2008 4:28PM' UNION ALL
SELECT '44292','D:\MTR\11-15-2008\08-11-15_WDI--LIST1\~$-15015.doc','Created','Dec 12 2008 4:38PM' UNION ALL
SELECT '44293','D:\MTR\11-15-2008\08-11-15_WDI--LIST1\~$-15015.doc','Changed','Dec 12 2008 4:38PM' UNION ALL
SELECT '44502','D:\Human Resources\Personnel\Employee list 2.xls','Changed','Dec 12 2008 4:45PM' UNION ALL
SELECT '44510','D:\MTR\11-15-2008\08-11-15_WDI--LIST1\~$-25025.doc','Created','Dec 12 2008 4:48PM' UNION ALL
SELECT '44511','D:\MTR\11-15-2008\08-11-15_WDI--LIST1\~$-25025.doc','Changed','Dec 12 2008 4:48PM' UNION ALL
SELECT '44513','D:\Human Resources\Personnel\Employee list 2.xls','Changed','Dec 12 2008 4:49PM' UNION ALL
SELECT '44520','D:\Manufacturing\WDI Mfg. Production 2008\Open WO.xls','Deleted','Dec 12 2008 4:49PM' UNION ALL
SELECT '44524','D:\Manufacturing\WDI Mfg. Production 2008\Open WO.xls','Created','Dec 12 2008 4:49PM' UNION ALL
SELECT '48448','D:\Warehouse\Tomball Warehouse\Cons. Inventory.xls','Deleted','Dec 12 2008 4:55PM' UNION ALL
SELECT '48452','D:\Warehouse\Tomball Warehouse\Cons. Inventory.xls','Created','Dec 12 2008 4:55PM' UNION ALL
SELECT '48456','D:\Warehouse\Tomball Warehouse\EAL.xls','Deleted','Dec 12 2008 4:56PM' UNION ALL
SELECT '48460','D:\Warehouse\Tomball Warehouse\EAL.xls','Created','Dec 12 2008 4:56PM' UNION ALL
SELECT '48465','D:\Warehouse\Tomball Warehouse\PDL.xls','Deleted','Dec 12 2008 4:56PM' UNION ALL
SELECT '48469','D:\Warehouse\Tomball Warehouse\PDL.xls','Created','Dec 12 2008 4:56PM' UNION ALL
SELECT '48487','D:\Users\wsun\2008\hvc\MIP Invoice# 0214.xls','Created','Dec 12 2008 4:57PM' UNION ALL
SELECT '48488','D:\Users\wsun\2008\hvc\MIP Invoice# 0214.xls','Deleted','Dec 12 2008 4:57PM' UNION ALL
SELECT '49490','D:\MTR\11-15-2008\08-11-15_WDI--LIST1\~$-35025.doc','Created','Dec 12 2008 4:59PM' UNION ALL
SELECT '49491','D:\MTR\11-15-2008\08-11-15_WDI--LIST1\~$-35025.doc','Changed','Dec 12 2008 4:59PM' UNION ALL
SELECT '49971','D:\Profiles\dbowen\Desktop\To Do 12-15.doc','Created','Dec 12 2008 5:03PM' UNION ALL
SELECT '49973','D:\Profiles\dbowen\Desktop\Slow Moving Items out of Tomball Warehouse.xls','Created','Dec 12 2008 5:03PM' UNION ALL
SELECT '49977','D:\Profiles\dbowen\Desktop\Q4 - End of Year WDI Count Sheet.xls','Created','Dec 12 2008 5:03PM' UNION ALL
SELECT '49981','D:\Profiles\dbowen\Desktop\2008 Year End Physical Count Procedures- rev1.doc','Created','Dec 12 2008 5:03PM' UNION ALL
SELECT '49983','D:\Profiles\dbowen\Desktop\Q4- End of Year Count Sheets WDI and HVC.xls','Created','Dec 12 2008 5:03PM' UNION ALL
SELECT '49986','D:\Profiles\dbowen\Desktop\Q4- End of Year HVC Count Sheet.xls','Created','Dec 12 2008 5:03PM' UNION ALL
SELECT '49990','D:\Profiles\dbowen\Desktop\MinMax.xls','Deleted','Dec 12 2008 5:03PM' UNION ALL
SELECT '49994','D:\Profiles\dbowen\Desktop\MinMax.xls','Created','Dec 12 2008 5:03PM' UNION ALL
SELECT '49996','D:\Profiles\dbowen\Desktop\2008 On-Hand vs. Sold10-31.xls','Deleted','Dec 12 2008 5:03PM' UNION ALL
SELECT '50000','D:\Profiles\dbowen\Desktop\2008 On-Hand vs. Sold10-31.xls','Created','Dec 12 2008 5:03PM' UNION ALL
SELECT '50010','D:\Profiles\dbowen\Desktop\HVC PARTS LIST.xls','Deleted','Dec 12 2008 5:03PM' UNION ALL
SELECT '50014','D:\Profiles\dbowen\Desktop\HVC PARTS LIST.xls','Created','Dec 12 2008 5:03PM' UNION ALL
SELECT '50172','D:\QuickBooks\Inventory\Inventory Control December 08.xls~RF158a84db.TMP///D:\QuickBooks\Inventory\Inventory Control December 08','Renamed','Dec 12 2008 5:03PM' UNION ALL
SELECT '52213','D:\MTR\11-15-2008\08-11-15_WDI--LIST1\~$-51024.doc','Created','Dec 12 2008 5:09PM' UNION ALL
SELECT '52214','D:\MTR\11-15-2008\08-11-15_WDI--LIST1\~$-51024.doc','Changed','Dec 12 2008 5:09PM' UNION ALL
SELECT '52220','D:\Warehouse\TOMBALL BACKORDER REPORT\Tomball Backorder Report.xls','Deleted','Dec 12 2008 5:09PM' UNION ALL
SELECT '52224','D:\Warehouse\TOMBALL BACKORDER REPORT\Tomball Backorder Report.xls','Created','Dec 12 2008 5:09PM' UNION ALL
SELECT '52229','D:\Warehouse\TOMBALL BACKORDER REPORT\Tomball Backorder Report.xls','Deleted','Dec 12 2008 5:09PM' UNION ALL
SELECT '52233','D:\Warehouse\TOMBALL BACKORDER REPORT\Tomball Backorder Report.xls','Created','Dec 12 2008 5:09PM' UNION ALL
SELECT '52246','D:\MTR\11-15-2008\08-11-15_WDI--LIST1\~$-70524.doc','Created','Dec 12 2008 5:20PM' UNION ALL
SELECT '52247','D:\MTR\11-15-2008\08-11-15_WDI--LIST1\~$-70524.doc','Changed','Dec 12 2008 5:20PM' UNION ALL
SELECT '52506','D:\MTR\11-15-2008\08-11-15_WDI--LIST1\~$-71024.doc','Created','Dec 12 2008 5:30PM' UNION ALL
SELECT '52507','D:\MTR\11-15-2008\08-11-15_WDI--LIST1\~$-71024.doc','Changed','Dec 12 2008 5:30PM' UNION ALL
SELECT '52524','D:\Manufacturing\QUALITY SYSTEM WDI MANUFACTURING\Quality Forms 20070305\NCR TBL 11-19-2007.xls','Deleted','Dec 12 2008 5:32PM' UNION ALL
SELECT '52528','D:\Manufacturing\QUALITY SYSTEM WDI MANUFACTURING\Quality Forms 20070305\NCR TBL 11-19-2007.xls','Created','Dec 12 2008 5:32PM' UNION ALL
SELECT '52544','D:\Manufacturing\QUALITY SYSTEM WDI MANUFACTURING\Quality Forms 20070305\NCR TBL 11-19-2007.xls','Deleted','Dec 12 2008 5:33PM' UNION ALL
SELECT '52548','D:\Manufacturing\QUALITY SYSTEM WDI MANUFACTURING\Quality Forms 20070305\NCR TBL 11-19-2007.xls','Created','Dec 12 2008 5:33PM' UNION ALL
SELECT '52594','D:\Warehouse\TOMBALL BACKORDER REPORT\Tomball Backorder Report.xls','Deleted','Dec 12 2008 5:37PM' UNION ALL
SELECT '52598','D:\Warehouse\TOMBALL BACKORDER REPORT\Tomball Backorder Report.xls','Created','Dec 12 2008 5:37PM' UNION ALL
SELECT '52603','D:\Warehouse\TOMBALL BACKORDER REPORT\Tomball Backorder Report.xls','Deleted','Dec 12 2008 5:37PM' UNION ALL
SELECT '52607','D:\Warehouse\TOMBALL BACKORDER REPORT\Tomball Backorder Report.xls','Created','Dec 12 2008 5:37PM' UNION ALL
SELECT '52612','D:\Warehouse\TOMBALL BACKORDER REPORT\Tomball Backorder Report.xls','Deleted','Dec 12 2008 5:37PM' UNION ALL
SELECT '52616','D:\Warehouse\TOMBALL BACKORDER REPORT\Tomball Backorder Report.xls','Created','Dec 12 2008 5:37PM' UNION ALL
SELECT '52646','D:\Warehouse\TOMBALL BACKORDER REPORT\Tomball Backorder Report.xls','Deleted','Dec 12 2008 5:39PM' UNION ALL
SELECT '52650','D:\Warehouse\TOMBALL BACKORDER REPORT\Tomball Backorder Report.xls','Created','Dec 12 2008 5:39PM' UNION ALL
SELECT '52655','D:\Warehouse\TOMBALL BACKORDER REPORT\Tomball Backorder Report.xls','Deleted','Dec 12 2008 5:39PM' UNION ALL
SELECT '52659','D:\Warehouse\TOMBALL BACKORDER REPORT\Tomball Backorder Report.xls','Created','Dec 12 2008 5:39PM' UNION ALL
SELECT '52683','D:\MTR\11-15-2008\08-11-15_WDI--LIST1\~$-95885.doc','Created','Dec 12 2008 5:41PM' UNION ALL
SELECT '52684','D:\MTR\11-15-2008\08-11-15_WDI--LIST1\~$-95885.doc','Changed','Dec 12 2008 5:41PM' UNION ALL
SELECT '52738','D:\Warehouse\TOMBALL BACKORDER REPORT\Tomball Backorder Report.xls','Deleted','Dec 12 2008 5:44PM' UNION ALL
SELECT '52742','D:\Warehouse\TOMBALL BACKORDER REPORT\Tomball Backorder Report.xls','Created','Dec 12 2008 5:44PM' UNION ALL
SELECT '52747','D:\Warehouse\TOMBALL BACKORDER REPORT\Tomball Backorder Report.xls','Deleted','Dec 12 2008 5:47PM' UNION ALL
SELECT '52751','D:\Warehouse\TOMBALL BACKORDER REPORT\Tomball Backorder Report.xls','Created','Dec 12 2008 5:47PM' UNION ALL
SELECT '52784','D:\Warehouse\TOMBALL BACKORDER REPORT\Tomball Backorder Report.xls','Deleted','Dec 12 2008 5:49PM' UNION ALL
SELECT '52788','D:\Warehouse\TOMBALL BACKORDER REPORT\Tomball Backorder Report.xls','Created','Dec 12 2008 5:49PM' UNION ALL
SELECT '52847','D:\MTR\11-15-2008\08-11-15_WDI--LIST1\~$-95887.doc','Created','Dec 12 2008 5:51PM' UNION ALL
SELECT '52848','D:\MTR\11-15-2008\08-11-15_WDI--LIST1\~$-95887.doc','Changed','Dec 12 2008 5:51PM' UNION ALL
SELECT '52882','D:\Warehouse\TOMBALL BACKORDER REPORT\Tomball Backorder Report.xls','Deleted','Dec 12 2008 5:54PM' UNION ALL
SELECT '52886','D:\Warehouse\TOMBALL BACKORDER REPORT\Tomball Backorder Report.xls','Created','Dec 12 2008 5:54PM' UNION ALL
SELECT '52891','D:\Warehouse\TOMBALL BACKORDER REPORT\Tomball Backorder Report.xls','Deleted','Dec 12 2008 5:54PM' UNION ALL
SELECT '52895','D:\Warehouse\TOMBALL BACKORDER REPORT\Tomball Backorder Report.xls','Created','Dec 12 2008 5:54PM' UNION ALL
SELECT '52924','D:\Warehouse\TOMBALL BACKORDER REPORT\Tomball Backorder Report.xls','Deleted','Dec 12 2008 5:57PM' UNION ALL
SELECT '52928','D:\Warehouse\TOMBALL BACKORDER REPORT\Tomball Backorder Report.xls','Created','Dec 12 2008 5:57PM' UNION ALL
SELECT '52933','D:\Warehouse\TOMBALL BACKORDER REPORT\Tomball Backorder Report.xls','Deleted','Dec 12 2008 5:58PM' UNION ALL
SELECT '52937','D:\Warehouse\TOMBALL BACKORDER REPORT\Tomball Backorder Report.xls','Created','Dec 12 2008 5:58PM' UNION ALL
SELECT '52978','D:\MTR\11-15-2008\08-11-15_WDI--LIST1\~$-95888.doc','Created','Dec 12 2008 6:02PM' UNION ALL
SELECT '52979','D:\MTR\11-15-2008\08-11-15_WDI--LIST1\~$-95888.doc','Changed','Dec 12 2008 6:02PM' UNION ALL
SELECT '53008','D:\Warehouse\TOMBALL BACKORDER REPORT\Tomball Backorder Report.xls','Deleted','Dec 12 2008 6:10PM' UNION ALL
SELECT '53012','D:\Warehouse\TOMBALL BACKORDER REPORT\Tomball Backorder Report.xls','Created','Dec 12 2008 6:10PM' UNION ALL
SELECT '53033','D:\Users\chan\HR\~$fer Letter - Cindy Johnson.doc','Created','Dec 12 2008 6:10PM' UNION ALL
SELECT '53034','D:\Users\chan\HR\~$fer Letter - Cindy Johnson.doc','Changed','Dec 12 2008 6:10PM' UNION ALL
SELECT '53035','D:\Users\chan\HR\~$fer Letter - Cindy Johnson.doc','Changed','Dec 12 2008 6:10PM' UNION ALL
SELECT '53036','D:\Users\chan\HR\~$fer Letter - Cindy Johnson.doc','Changed','Dec 12 2008 6:10PM' UNION ALL
SELECT '53039','D:\Users\chan\HR\~$fer Letter - Cindy Johnson.doc','Deleted','Dec 12 2008 6:12PM' UNION ALL
SELECT '53044','D:\MTR\11-15-2008\08-11-15_WDI--LIST1\~$-96885.doc','Created','Dec 12 2008 6:12PM' UNION ALL
SELECT '53045','D:\MTR\11-15-2008\08-11-15_WDI--LIST1\~$-96885.doc','Changed','Dec 12 2008 6:12PM' UNION ALL
SELECT '53047','D:\Users\chan\HR\~$fer Letter - Cindy Johnson.doc','Created','Dec 12 2008 6:12PM' UNION ALL
SELECT '53048','D:\Users\chan\HR\~$fer Letter - Cindy Johnson.doc','Changed','Dec 12 2008 6:12PM' UNION ALL
SELECT '53049','D:\Users\chan\HR\~$fer Letter - Cindy Johnson.doc','Changed','Dec 12 2008 6:12PM' UNION ALL
SELECT '53050','D:\Users\chan\HR\~$fer Letter - Cindy Johnson.doc','Changed','Dec 12 2008 6:12PM' UNION ALL
SELECT '53073','D:\Users\chan\HR\~WRL2110.tmp///D:\Users\chan\HR\Offer Letter - Cindy Johnson.doc','Renamed','Dec 12 2008 6:12PM' UNION ALL
SELECT '53079','D:\Users\chan\HR\~$fer Letter - Cindy Johnson.doc','Deleted','Dec 12 2008 6:12PM' UNION ALL
SELECT '53081','D:\Users\chan\HR\~$fer Letter - Cindy Johnson.doc','Created','Dec 12 2008 6:13PM' UNION ALL
SELECT '53082','D:\Users\chan\HR\~$fer Letter - Cindy Johnson.doc','Changed','Dec 12 2008 6:13PM' UNION ALL
SELECT '53083','D:\Users\chan\HR\~$fer Letter - Cindy Johnson.doc','Changed','Dec 12 2008 6:13PM' UNION ALL
SELECT '53084','D:\Users\chan\HR\~$fer Letter - Cindy Johnson.doc','Changed','Dec 12 2008 6:13PM' UNION ALL
SELECT '53086','D:\Users\chan\HR\~$fer Letter - Cindy Johnson.doc','Deleted','Dec 12 2008 6:13PM' UNION ALL
SELECT '53088','D:\Users\chan\Comerica RLOC Reporting\11-30-08 Inventory Report.xls','Created','Dec 12 2008 6:14PM' UNION ALL
SELECT '53089','D:\Users\chan\Comerica RLOC Reporting\11-30-08 Inventory Report.xls','Deleted','Dec 12 2008 6:14PM' UNION ALL
SELECT '53937','D:\MTR\11-15-2008\08-11-15_WDI--LIST1\~$-96887.doc','Created','Dec 12 2008 6:33PM' UNION ALL
SELECT '53938','D:\MTR\11-15-2008\08-11-15_WDI--LIST1\~$-96887.doc','Changed','Dec 12 2008 6:33PM' UNION ALL
SELECT '53946','D:\MTR\11-15-2008\08-11-15_WDI--LIST1\~$-FC001 (1).doc','Created','Dec 12 2008 6:44PM' UNION ALL
SELECT '53947','D:\MTR\11-15-2008\08-11-15_WDI--LIST1\~$-FC001 (1).doc','Changed','Dec 12 2008 6:44PM' UNION ALL
SELECT '53952','D:\Users\chan\KANA\SDBT INVOICE 008126054266.doc','Created','Dec 12 2008 6:54PM' UNION ALL
SELECT '53975','D:\Users\chan\KANA\~WRL1724.tmp///D:\Users\chan\KANA\SDBT INVOICE 008126054266.doc','Renamed','Dec 12 2008 6:54PM' UNION ALL
SELECT '53977','D:\Users\chan\KANA\~$BT INVOICE 008126054266.doc','Created','Dec 12 2008 6:54PM' UNION ALL
SELECT '53978','D:\Users\chan\KANA\~$BT INVOICE 008126054266.doc','Changed','Dec 12 2008 6:54PM' UNION ALL
SELECT '53979','D:\Users\chan\KANA\~$BT INVOICE 008126054266.doc','Changed','Dec 12 2008 6:54PM' UNION ALL
SELECT '53980','D:\Users\chan\KANA\~$BT INVOICE 008126054266.doc','Changed','Dec 12 2008 6:54PM' UNION ALL
SELECT '53986','D:\Users\chan\KANA\~$BT INVOICE 008126054266.doc','Deleted','Dec 12 2008 6:54PM' UNION ALL
SELECT '53991','D:\MTR\11-15-2008\08-11-15_WDI--LIST1\~$-FC001 (2).doc','Created','Dec 12 2008 6:54PM' UNION ALL
SELECT '53992','D:\MTR\11-15-2008\08-11-15_WDI--LIST1\~$-FC001 (2).doc','Changed','Dec 12 2008 6:54PM' UNION ALL
SELECT '53994','D:\Users\chan\HVC Acquisition\Stock Purchase Agreement\HVC Disclosure Letter - 401K Plan.doc','Created','Dec 12 2008 6:58PM' UNION ALL
SELECT '54017','D:\Users\chan\HVC Acquisition\Stock Purchase Agreement\~WRL1038.tmp///D:\Users\chan\HVC Acquisition\Stock Purchase Agreement\HVC','Renamed','Dec 12 2008 6:58PM' UNION ALL
SELECT '54019','D:\Users\chan\HVC Acquisition\Stock Purchase Agreement\~$C Disclosure Letter - 401K Plan.doc','Created','Dec 12 2008 6:58PM' UNION ALL
SELECT '54020','D:\Users\chan\HVC Acquisition\Stock Purchase Agreement\~$C Disclosure Letter - 401K Plan.doc','Changed','Dec 12 2008 6:58PM' UNION ALL
SELECT '54021','D:\Users\chan\HVC Acquisition\Stock Purchase Agreement\~$C Disclosure Letter - 401K Plan.doc','Changed','Dec 12 2008 6:58PM' UNION ALL
SELECT '54022','D:\Users\chan\HVC Acquisition\Stock Purchase Agreement\~$C Disclosure Letter - 401K Plan.doc','Changed','Dec 12 2008 6:58PM' UNION ALL
SELECT '54026','D:\Users\chan\HVC Acquisition\Stock Purchase Agreement\~$C Disclosure Letter - 401K Plan.doc','Deleted','Dec 12 2008 6:58PM' UNION ALL
SELECT '54040','D:\MTR\11-15-2008\08-11-15_WDI--LIST1\~$-FC007.doc','Created','Dec 12 2008 7:05PM' UNION ALL
SELECT '54041','D:\MTR\11-15-2008\08-11-15_WDI--LIST1\~$-FC007.doc','Changed','Dec 12 2008 7:05PM' UNION ALL
SELECT '54050','D:\MTR\11-15-2008\08-11-15_WDI--LIST1\~$-FC009.doc','Created','Dec 12 2008 7:15PM' UNION ALL
SELECT '54051','D:\MTR\11-15-2008\08-11-15_WDI--LIST1\~$-FC009.doc','Changed','Dec 12 2008 7:15PM' UNION ALL
SELECT '54059','D:\MTR\11-15-2008\08-11-15_WDI--LIST1\~$-JM107.doc','Created','Dec 12 2008 7:26PM' UNION ALL
SELECT '54060','D:\MTR\11-15-2008\08-11-15_WDI--LIST1\~$-JM107.doc','Changed','Dec 12 2008 7:26PM' UNION ALL
SELECT '54068','D:\MTR\11-15-2008\08-11-15_WDI--LIST1\~$-JM109.doc','Created','Dec 12 2008 7:36PM' UNION ALL
SELECT '54069','D:\MTR\11-15-2008\08-11-15_WDI--LIST1\~$-JM109.doc','Changed','Dec 12 2008 7:36PM' UNION ALL
SELECT '54077','D:\MTR\11-15-2008\08-11-15_WDI--LIST1\~$008071-21.doc','Created','Dec 12 2008 7:47PM' UNION ALL
SELECT '54078','D:\MTR\11-15-2008\08-11-15_WDI--LIST1\~$008071-21.doc','Changed','Dec 12 2008 7:47PM' UNION ALL
SELECT '56563','D:\MTR\11-15-2008\08-11-15_WDI--LIST1\~$008071-23.doc','Created','Dec 12 2008 8:08PM' UNION ALL
SELECT '56564','D:\MTR\11-15-2008\08-11-15_WDI--LIST1\~$008071-23.doc','Changed','Dec 12 2008 8:08PM' UNION ALL
SELECT '56581','D:\MTR\11-15-2008\08-11-15_WDI--LIST2\~$-00003.doc','Created','Dec 12 2008 8:29PM' UNION ALL
SELECT '56582','D:\MTR\11-15-2008\08-11-15_WDI--LIST2\~$-00003.doc','Changed','Dec 12 2008 8:29PM' UNION ALL
SELECT '56584','D:\MTR\11-15-2008\08-11-15_WDI--LIST2\~$-23989A.doc','Created','Dec 12 2008 8:29PM' UNION ALL
SELECT '56585','D:\MTR\11-15-2008\08-11-15_WDI--LIST2\~$-23989A.doc','Changed','Dec 12 2008 8:29PM' UNION ALL
SELECT '56587','D:\MTR\11-15-2008\08-11-15_WDI--LIST2\~$-24063.doc','Created','Dec 12 2008 8:29PM' UNION ALL
SELECT '56588','D:\MTR\11-15-2008\08-11-15_WDI--LIST2\~$-24063.doc','Changed','Dec 12 2008 8:29PM' UNION ALL
SELECT '56590','D:\MTR\11-15-2008\08-11-15_WDI--LIST2\~$-95885.doc','Created','Dec 12 2008 8:29PM' UNION ALL
SELECT '56591','D:\MTR\11-15-2008\08-11-15_WDI--LIST2\~$-95885.doc','Changed','Dec 12 2008 8:29PM' UNION ALL
SELECT '56599','D:\MTR\11-15-2008\08-11-15_WDI--LIST2\~$-95888.doc','Created','Dec 12 2008 8:39PM' UNION ALL
SELECT '56600','D:\MTR\11-15-2008\08-11-15_WDI--LIST2\~$-95888.doc','Changed','Dec 12 2008 8:39PM' UNION ALL
--===== Set the identity insert back to normal
SET IDENTITY_INSERT #file_info OFF
SET IDENTITY_INSERT #file_modify OFF
December 29, 2009 at 1:57 pm
It looks like you have not tested to run the query you posted.
I tried and found few errors. Firstly, the tables do not have Identity Columns so Set Identitiy Insert OFF is failing and also at the end of the first Insert statement, there is a UNION ALL and when corrected these 2 errors it still cannot insert into the 2nd table getting error
Msg 205, Level 16, State 1, Line 357
All queries combined using a UNION, INTERSECT or EXCEPT operator must have an equal number of expressions in their target lists.
Correct that and repost it.
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
December 29, 2009 at 2:07 pm
Bru Medishetty (12/29/2009)
It looks like you have not tested to run the query you posted.I tried and found few errors. Firstly, the tables do not have Identity Columns so Set Identitiy Insert OFF is failing and also at the end of the first Insert statement, there is a UNION ALL and when corrected these 2 errors it still cannot insert into the 2nd table getting error
Msg 205, Level 16, State 1, Line 357
All queries combined using a UNION, INTERSECT or EXCEPT operator must have an equal number of expressions in their target lists.
Correct that and repost it.
The second batch of inserts also has 'UNION ALL' on the last line
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
December 29, 2009 at 2:25 pm
Ok maybe I should go about this a different way, because I guess I am not clearly explaining what I need to get done.
An alternative to what I explained before would be to take the table below (which contains and the start and stop times that a file is being accessed by a particular user) and reformat it in a view so that I can get the start time and stop time in a single row.
CREATE TABLE #file_info (
[id] [bigint] NOT NULL ,
[fi_id] [bigint] NOT NULL ,
[fi_num_locks] [bigint] NOT NULL ,
[fi_pathname] [varchar] (500) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[fi_permission] [varchar] (500) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[fi_username] [varchar] (500) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[action] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[dttm] [datetime] NOT NULL ,
CONSTRAINT [PK_file_info] PRIMARY KEY CLUSTERED
([id]) ON [PRIMARY] ) ON [PRIMARY]
December 29, 2009 at 3:41 pm
Jonathan Turlington (12/29/2009)
Ok maybe I should go about this a different way, because I guess I am not clearly explaining what I need to get done.An alternative to what I explained before would be to take the table below (which contains and the start and stop times that a file is being accessed by a particular user) and reformat it in a view so that I can get the start time and stop time in a single row.
CREATE TABLE #file_info (
[id] [bigint] NOT NULL ,
[fi_id] [bigint] NOT NULL ,
[fi_num_locks] [bigint] NOT NULL ,
[fi_pathname] [varchar] (500) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[fi_permission] [varchar] (500) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[fi_username] [varchar] (500) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[action] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[dttm] [datetime] NOT NULL ,
CONSTRAINT [PK_file_info] PRIMARY KEY CLUSTERED
([id]) ON [PRIMARY] ) ON [PRIMARY]
You can self-join on the table:
SELECT {columns}
FROM #file_info f1
LEFT JOIN #file_info f2 ON f2.fi_id = f1.fi_id AND f2.action = 'STOP'
WHERE f1.action = 'START';
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
December 30, 2009 at 7:13 am
Jonathan Turlington (12/29/2009)
Ok maybe I should go about this a different way, because I guess I am not clearly explaining what I need to get done.An alternative to what I explained before would be to take the table below (which contains and the start and stop times that a file is being accessed by a particular user) and reformat it in a view so that I can get the start time and stop time in a single row.
CREATE TABLE #file_info (
[id] [bigint] NOT NULL ,
[fi_id] [bigint] NOT NULL ,
[fi_num_locks] [bigint] NOT NULL ,
[fi_pathname] [varchar] (500) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[fi_permission] [varchar] (500) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[fi_username] [varchar] (500) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[action] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[dttm] [datetime] NOT NULL ,
CONSTRAINT [PK_file_info] PRIMARY KEY CLUSTERED
([id]) ON [PRIMARY] ) ON [PRIMARY]
If that is all you need to do, then have a look at this post from last week, the OP needed to do the same thing. Let us know if you still have questions. One thing to note, you can not include the table's identity column, since all non-aggregated columns will need to be included in the GROUP BY, and once you bring in the identity, you lose the desired effect.
http://www.sqlservercentral.com/Forums/Topic834780-8-2.aspx#bm836377
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
December 30, 2009 at 7:37 am
Jonathan, to elaborate on my last post, here is what I'm talking about...
SELECT
fi_id = MAX(fi.fi_id),
fi.fi_pathname,
fi.fi_username,
fi.fi_permission,
fi.fi_num_locks,
Start = MAX(CASE WHEN fi.action = 'Start' THEN fi.dttm ELSE NULL END),
Stop = MAX(CASE WHEN fi.action = 'Stop' THEN fi.dttm ELSE NULL END)
FROM #file_info fi
GROUP BY fi.fi_pathname,fi.fi_username,fi.fi_permission,fi.fi_num_locks
ORDER BY fi_id
That seems to work. However, it turns out the column fi_num_locks also has multiple values for some of the records. So, in order to display only one line for each fi_id, you can not include it in the query. I'm not sure what that is, but if you need to see it, then understand that every fi_id that has multiple fi_num_lock values will appear multiple times. You can see which ones they are by running this...
SELECT
fi_id
FROM
(
SELECT
fi_id = MAX(fi.fi_id),
fi.fi_pathname,
fi.fi_username,
fi.fi_permission,
fi.fi_num_locks,
Start = MAX(CASE WHEN fi.action = 'Start' THEN fi.dttm ELSE NULL END),
Stop = MAX(CASE WHEN fi.action = 'Stop' THEN fi.dttm ELSE NULL END)
FROM #file_info fi
GROUP BY fi.fi_pathname,fi.fi_username,fi.fi_permission,fi.fi_num_locks
--ORDER BY fi_id
) t1
GROUP BY fi_id
HAVING COUNT(fi_id) > 1
Now, take fi_id 166748 for example. If you go back and re-run the first query, you will see two instances of that record, one with fi_num_locks = 0 and one with fi_num_locks = 3.
fi_idfi_pathnamefi_usernamefi_permissionfi_num_locksStartStop
166748D:\MTR\11-15-2008\08-11-15_WDI--LIST1\2008-11-15 PACKING LIST-WDI.xlsWSUN3502008-12-12 08:20:00.000NULL
166748D:\MTR\11-15-2008\08-11-15_WDI--LIST1\2008-11-15 PACKING LIST-WDI.xlsWSUN353NULL2008-12-12 08:21:00.000
Just some things to think about.
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply