Join Based On DateTime Range

Question

Post reply

Join Based On DateTime Range

Jonathan Turlington

Old Hand

Points: 360
More actions
December 29, 2009 at 10:02 am

#71890

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.

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply

Bru Medishetty SSC-Insane Points: 23606 More actions · Answer 1

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]

Bru Medishetty

Blog -- LearnSQLWithBru

Join on Facebook Page Facebook.comLearnSQLWithBru

Twitter -- BruMedishetty

Jonathan Turlington Old Hand Points: 360 More actions · Answer 2

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]

--===== 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]

--===== 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

Bru Medishetty SSC-Insane Points: 23606 More actions · Answer 3

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.

Bru Medishetty

Blog -- LearnSQLWithBru

Join on Facebook Page Facebook.comLearnSQLWithBru

Twitter -- BruMedishetty

Greg Snidow SSCoach Points: 16108 More actions · Answer 4

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.

Jonathan Turlington Old Hand Points: 360 More actions · Answer 5

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]

Jeffrey Williams SSC Guru Points: 90303 More actions · Answer 6

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

Greg Snidow SSCoach Points: 16108 More actions · Answer 7

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.

Greg Snidow SSCoach Points: 16108 More actions · Answer 8

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.