Join Based On DateTime Range

  • 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.

  • 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

  • I do apologize for my hasty post.

    I am trying to find the #file_info.[fi_username] that caused the #file_modify.[ChangeType] from the data contained in the #file_info

    It may be very general and may not be exact but I think it's a good place to start. I apologize for the excessive data, I just felt it would be necessary to make an accurate query.

    --===== If the test tables already exist, drop them

    IF OBJECT_ID('TempDB..#file_info','U') IS NOT NULL

    DROP TABLE #file_info

    IF OBJECT_ID('TempDB..#file_modify','U') IS NOT NULL

    DROP TABLE #file_modify

    --===== Create the test table for opening and closings(START and STOP) performed on the file with

    CREATE TABLE #file_info (

    [id] [bigint] NOT NULL ,

    [fi_id] [bigint] NOT NULL ,

    [fi_num_locks] [bigint] NOT NULL ,

    [fi_pathname] [varchar] (500) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,

    [fi_permission] [varchar] (500) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,

    [fi_username] [varchar] (500) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,

    [action] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,

    [dttm] [datetime] NOT NULL ,

    CONSTRAINT [PK_file_info] PRIMARY KEY CLUSTERED

    (

    [id]

    ) ON [PRIMARY]

    ) ON [PRIMARY]

    --===== Create the test table for actions performed on the file with

    CREATE TABLE #file_modify(

    [id] [bigint] NOT NULL ,

    [FullPath] [varchar] (5000) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,

    [ChangeType] [varchar] (500) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,

    [dttm] [datetime] NOT NULL ,

    CONSTRAINT [PK_file_modify] PRIMARY KEY CLUSTERED

    (

    [id]

    ) ON [PRIMARY]

    ) ON [PRIMARY]

    --===== All Inserts into the IDENTITY column

    SET IDENTITY_INSERT #file_info ON

    SET IDENTITY_INSERT #file_modify ON

    --===== Insert the test data into the test tables

    INSERT INTO #file_info([id], [fi_id], [fi_num_locks], [fi_pathname], [fi_permission], [fi_username], [action], [dttm])

    SELECT '53852','163536','0','D:\Users\rbutler\Cover Letter-Resume-07.doc','1','RBUTLER','START','Dec 12 2008 8:00AM' UNION ALL

    SELECT '53853','163537','0','D:\Users\rbutler\Cover Letter-Resume-07.doc','1','RBUTLER','START','Dec 12 2008 8:00AM' UNION ALL

    SELECT '53854','163536','0','D:\Users\rbutler\Cover Letter-Resume-07.doc','1','RBUTLER','STOP','Dec 12 2008 8:00AM' UNION ALL

    SELECT '53855','163537','0','D:\Users\rbutler\Cover Letter-Resume-07.doc','1','RBUTLER','STOP','Dec 12 2008 8:00AM' UNION ALL

    SELECT '53861','163541','0','D:\Users\rbutler\Cust Action Report.doc','1','RBUTLER','START','Dec 12 2008 8:00AM' UNION ALL

    SELECT '53863','163541','0','D:\Users\rbutler\Cust Action Report.doc','1','RBUTLER','STOP','Dec 12 2008 8:00AM' UNION ALL

    SELECT '54057','166447','0','D:\QuickBooks\Inventory\Inventory Control December 08.xls','33','WSUN','START','Dec 12 2008 8:14AM' UNION ALL

    SELECT '54058','166449','0','D:\QuickBooks\Inventory\Inventory Control December 08.xls','35','WSUN','START','Dec 12 2008 8:14AM' UNION ALL

    SELECT '54059','166447','0','D:\QuickBooks\Inventory\Inventory Control December 08.xls','33','WSUN','STOP','Dec 12 2008 8:14AM' UNION ALL

    SELECT '54060','166451','0','D:\QuickBooks\Inventory\Inventory Control December 08.xls','0','WSUN','START','Dec 12 2008 8:14AM' UNION ALL

    SELECT '54064','166451','0','D:\QuickBooks\Inventory\Inventory Control December 08.xls','0','WSUN','STOP','Dec 12 2008 8:14AM' UNION ALL

    SELECT '54394','166746','0','D:\MTR\11-15-2008\08-11-15_WDI--LIST1\2008-11-15 PACKING LIST-WDI.xls','1','WSUN','START','Dec 12 2008 8:20AM' UNION ALL

    SELECT '54395','166748','0','D:\MTR\11-15-2008\08-11-15_WDI--LIST1\2008-11-15 PACKING LIST-WDI.xls','35','WSUN','START','Dec 12 2008 8:20AM' UNION ALL

    SELECT '54396','166746','0','D:\MTR\11-15-2008\08-11-15_WDI--LIST1\2008-11-15 PACKING LIST-WDI.xls','1','WSUN','STOP','Dec 12 2008 8:20AM' UNION ALL

    SELECT '54400','166748','3','D:\MTR\11-15-2008\08-11-15_WDI--LIST1\2008-11-15 PACKING LIST-WDI.xls','35','WSUN','STOP','Dec 12 2008 8:21AM' UNION ALL

    SELECT '54401','166757','0','D:\MTR\11-15-2008\08-11-15_WDI--LIST1\2008-11-15 PACKING LIST-WDI.xls','1','WSUN','START','Dec 12 2008 8:21AM' UNION ALL

    SELECT '54412','166757','0','D:\MTR\11-15-2008\08-11-15_WDI--LIST1\2008-11-15 PACKING LIST-WDI.xls','1','WSUN','STOP','Dec 12 2008 8:21AM' UNION ALL

    SELECT '55510','167193','0','D:\QuickBooks\Inventory\Inventory Control December 08.xls','33','WSUN','START','Dec 12 2008 8:31AM' UNION ALL

    SELECT '55511','167196','0','D:\QuickBooks\Inventory\Inventory Control December 08.xls','32','WSUN','START','Dec 12 2008 8:31AM' UNION ALL

    SELECT '55512','166449','0','D:\QuickBooks\Inventory\Inventory Control December 08.xls','35','WSUN','STOP','Dec 12 2008 8:31AM' UNION ALL

    SELECT '55513','167193','0','D:\QuickBooks\Inventory\Inventory Control December 08.xls','33','WSUN','STOP','Dec 12 2008 8:31AM' UNION ALL

    SELECT '55514','167200','0','D:\QuickBooks\Inventory\Inventory Control December 08.xls','0','WSUN','START','Dec 12 2008 8:31AM' UNION ALL

    SELECT '55516','167196','0','D:\QuickBooks\Inventory\Inventory Control December 08.xls','32','WSUN','STOP','Dec 12 2008 8:31AM' UNION ALL

    SELECT '55517','167201','0','D:\QuickBooks\Inventory\Inventory Control December 08.xls','33','WSUN','START','Dec 12 2008 8:31AM' UNION ALL

    SELECT '55518','167200','0','D:\QuickBooks\Inventory\Inventory Control December 08.xls','0','WSUN','STOP','Dec 12 2008 8:31AM' UNION ALL

    SELECT '55519','167203','0','D:\QuickBooks\Inventory\Inventory Control December 08.xls','33','WSUN','START','Dec 12 2008 8:31AM' UNION ALL

    SELECT '55520','167201','0','D:\QuickBooks\Inventory\Inventory Control December 08.xls','33','WSUN','STOP','Dec 12 2008 8:31AM' UNION ALL

    SELECT '55521','167205','0','D:\QuickBooks\Inventory\Inventory Control December 08.xls','17','WSUN','START','Dec 12 2008 8:31AM' UNION ALL

    SELECT '55523','167203','0','D:\QuickBooks\Inventory\Inventory Control December 08.xls','33','WSUN','STOP','Dec 12 2008 8:31AM' UNION ALL

    SELECT '55524','167205','0','D:\QuickBooks\Inventory\Inventory Control December 08.xls','17','WSUN','STOP','Dec 12 2008 8:31AM' UNION ALL

    SELECT '55526','167216','0','D:\QuickBooks\Inventory\Inventory Control December 08.xls','33','WSUN','START','Dec 12 2008 8:31AM' UNION ALL

    SELECT '55527','167218','0','D:\QuickBooks\Inventory\Inventory Control December 08.xls','35','WSUN','START','Dec 12 2008 8:31AM' UNION ALL

    SELECT '55528','167216','0','D:\QuickBooks\Inventory\Inventory Control December 08.xls','33','WSUN','STOP','Dec 12 2008 8:31AM' UNION ALL

    SELECT '55712','167394','0','D:\QuickBooks\WDI FORMS\Credit Card - Employee Forms\Expense Report Form - BLANK.xls','1','MCOLE','START','Dec 12 2008 8:35AM' UNION ALL

    SELECT '55713','167406','0','D:\QuickBooks\WDI FORMS\Credit Card - Employee Forms\Expense Report Form - BLANK.xls','1','MCOLE','START','Dec 12 2008 8:35AM' UNION ALL

    SELECT '55714','167394','0','D:\QuickBooks\WDI FORMS\Credit Card - Employee Forms\Expense Report Form - BLANK.xls','1','MCOLE','STOP','Dec 12 2008 8:35AM' UNION ALL

    SELECT '55715','167416','0','D:\QuickBooks\WDI FORMS\Credit Card - Employee Forms\Credit Card Agreement.doc','1','MCOLE','START','Dec 12 2008 8:35AM' UNION ALL

    SELECT '55716','167422','0','D:\QuickBooks\WDI FORMS\Credit Card - Employee Forms\Credit Card Agreement.doc','1','MCOLE','START','Dec 12 2008 8:35AM' UNION ALL

    SELECT '55717','167416','0','D:\QuickBooks\WDI FORMS\Credit Card - Employee Forms\Credit Card Agreement.doc','1','MCOLE','STOP','Dec 12 2008 8:35AM' UNION ALL

    SELECT '55718','167432','0','D:\QuickBooks\WDI FORMS\Credit Card - Employee Forms\Credit Card Documentation Requirements.doc','1','MCOLE','START','Dec 12 2008 8:35AM' UNION ALL

    SELECT '55719','167438','0','D:\QuickBooks\WDI FORMS\Credit Card - Employee Forms\Credit Card Documentation Requirements.doc','1','MCOLE','START','Dec 12 2008 8:35AM' UNION ALL

    SELECT '55720','167432','0','D:\QuickBooks\WDI FORMS\Credit Card - Employee Forms\Credit Card Documentation Requirements.doc','1','MCOLE','STOP','Dec 12 2008 8:35AM' UNION ALL

    SELECT '55721','167454','0','D:\QuickBooks\WDI FORMS\Credit Card - Employee Forms\Credit Card expense reports.doc','1','MCOLE','START','Dec 12 2008 8:35AM' UNION ALL

    SELECT '55722','167456','0','D:\QuickBooks\WDI FORMS\Credit Card - Employee Forms\Credit Card Documentation Requirements.doc','0','MCOLE','START','Dec 12 2008 8:35AM' UNION ALL

    SELECT '55723','167460','0','D:\QuickBooks\WDI FORMS\Credit Card - Employee Forms\Credit Card expense reports.doc','0','MCOLE','START','Dec 12 2008 8:35AM' UNION ALL

    SELECT '55732','167406','0','D:\QuickBooks\WDI FORMS\Credit Card - Employee Forms\Expense Report Form - BLANK.xls','1','MCOLE','STOP','Dec 12 2008 8:35AM' UNION ALL

    SELECT '55733','167422','0','D:\QuickBooks\WDI FORMS\Credit Card - Employee Forms\Credit Card Agreement.doc','1','MCOLE','STOP','Dec 12 2008 8:35AM' UNION ALL

    SELECT '55734','167438','0','D:\QuickBooks\WDI FORMS\Credit Card - Employee Forms\Credit Card Documentation Requirements.doc','1','MCOLE','STOP','Dec 12 2008 8:35AM' UNION ALL

    SELECT '55735','167454','0','D:\QuickBooks\WDI FORMS\Credit Card - Employee Forms\Credit Card expense reports.doc','1','MCOLE','STOP','Dec 12 2008 8:35AM' UNION ALL

    SELECT '55736','167456','0','D:\QuickBooks\WDI FORMS\Credit Card - Employee Forms\Credit Card Documentation Requirements.doc','0','MCOLE','STOP','Dec 12 2008 8:35AM' UNION ALL

    SELECT '55737','167460','0','D:\QuickBooks\WDI FORMS\Credit Card - Employee Forms\Credit Card expense reports.doc','0','MCOLE','STOP','Dec 12 2008 8:35AM' UNION ALL

    SELECT '57461','168727','0','D:\Users\Wsun\Xunlei\ENGote.xls','35','WSUN','START','Dec 12 2008 9:20AM' UNION ALL

    SELECT '57462','168728','0','D:\Users\Wsun\Xunlei\ENGote.xls','0','WSUN','START','Dec 12 2008 9:20AM' UNION ALL

    SELECT '57472','168728','0','D:\Users\Wsun\Xunlei\ENGote.xls','0','WSUN','STOP','Dec 12 2008 9:20AM' UNION ALL

    SELECT '59258','169992','3','D:\Users\mcole\invoice.xls','35','MCOLE','START','Dec 12 2008 9:49AM' UNION ALL

    SELECT '59265','169992','3','D:\Users\mcole\invoice.xls','35','MCOLE','STOP','Dec 12 2008 9:49AM' UNION ALL

    SELECT '59285','170017','0','D:\Users\mcole\invoice.xls','1','MCOLE','START','Dec 12 2008 9:49AM' UNION ALL

    SELECT '59287','170017','0','D:\Users\mcole\invoice.xls','1','MCOLE','STOP','Dec 12 2008 9:49AM' UNION ALL

    SELECT '59321','170077','0','D:\QuickBooks\Inventory\Inventory Control December 08.xls','33','WSUN','START','Dec 12 2008 9:51AM' UNION ALL

    SELECT '59322','167218','0','D:\QuickBooks\Inventory\Inventory Control December 08.xls','35','WSUN','STOP','Dec 12 2008 9:51AM' UNION ALL

    SELECT '59325','170081','0','D:\QuickBooks\Inventory\Inventory Control December 08.xls','17','WSUN','START','Dec 12 2008 9:51AM' UNION ALL

    SELECT '59327','170077','0','D:\QuickBooks\Inventory\Inventory Control December 08.xls','33','WSUN','STOP','Dec 12 2008 9:51AM' UNION ALL

    SELECT '59329','170089','0','D:\QuickBooks\Inventory\Inventory Control December 08.xls','33','WSUN','START','Dec 12 2008 9:51AM' UNION ALL

    SELECT '59331','170092','0','D:\QuickBooks\Inventory\Inventory Control December 08.xls','33','WSUN','START','Dec 12 2008 9:51AM' UNION ALL

    SELECT '59332','170081','0','D:\QuickBooks\Inventory\Inventory Control December 08.xls','17','WSUN','STOP','Dec 12 2008 9:51AM' UNION ALL

    SELECT '59334','170089','0','D:\QuickBooks\Inventory\Inventory Control December 08.xls','33','WSUN','STOP','Dec 12 2008 9:51AM' UNION ALL

    SELECT '59335','170094','0','D:\QuickBooks\Inventory\Inventory Control December 08.xls','35','WSUN','START','Dec 12 2008 9:51AM' UNION ALL

    SELECT '59340','170092','0','D:\QuickBooks\Inventory\Inventory Control December 08.xls','33','WSUN','STOP','Dec 12 2008 9:51AM' UNION ALL

    SELECT '60755','170906','0','D:\Human Resources\Payroll tracker.xls','35','SROANE','START','Dec 12 2008 10:25AM' UNION ALL

    SELECT '60756','170907','0','D:\Human Resources\Payroll tracker.xls','0','SROANE','START','Dec 12 2008 10:25AM' UNION ALL

    SELECT '60769','170907','0','D:\Human Resources\Payroll tracker.xls','0','SROANE','STOP','Dec 12 2008 10:25AM' UNION ALL

    SELECT '61674','171265','0','D:\Human Resources\Payroll tracker.xls','35','SROANE','START','Dec 12 2008 10:25AM' UNION ALL

    SELECT '61675','170906','0','D:\Human Resources\Payroll tracker.xls','35','SROANE','STOP','Dec 12 2008 10:25AM' UNION ALL

    SELECT '61677','171265','3','D:\Human Resources\Payroll tracker.xls','35','SROANE','STOP','Dec 12 2008 10:25AM' UNION ALL

    SELECT '61778','171302','0','D:\QuickBooks\Inventory\Inventory Control November 08.xls','33','WSUN','START','Dec 12 2008 10:30AM' UNION ALL

    SELECT '61779','171304','0','D:\QuickBooks\Inventory\Inventory Control November 08.xls','35','WSUN','START','Dec 12 2008 10:30AM' UNION ALL

    SELECT '61780','171302','0','D:\QuickBooks\Inventory\Inventory Control November 08.xls','33','WSUN','STOP','Dec 12 2008 10:30AM' UNION ALL

    SELECT '61781','171306','0','D:\QuickBooks\Inventory\Inventory Control November 08.xls','0','WSUN','START','Dec 12 2008 10:30AM' UNION ALL

    SELECT '61784','171306','0','D:\QuickBooks\Inventory\Inventory Control November 08.xls','0','WSUN','STOP','Dec 12 2008 10:30AM' UNION ALL

    SELECT '61807','171340','0','D:\QuickBooks\Inventory\Inventory Control November 08.xls','33','WSUN','START','Dec 12 2008 10:31AM' UNION ALL

    SELECT '61808','171342','0','D:\QuickBooks\Inventory\Inventory Control November 08.xls','33','WSUN','START','Dec 12 2008 10:31AM' UNION ALL

    SELECT '61809','171304','0','D:\QuickBooks\Inventory\Inventory Control November 08.xls','35','WSUN','STOP','Dec 12 2008 10:31AM' UNION ALL

    SELECT '61810','171340','0','D:\QuickBooks\Inventory\Inventory Control November 08.xls','33','WSUN','STOP','Dec 12 2008 10:31AM' UNION ALL

    SELECT '61813','171342','0','D:\QuickBooks\Inventory\Inventory Control November 08.xls','33','WSUN','STOP','Dec 12 2008 10:31AM' UNION ALL

    SELECT '61814','171349','0','D:\QuickBooks\Inventory\Inventory Control November 08.xls','33','WSUN','START','Dec 12 2008 10:31AM' UNION ALL

    SELECT '61818','171351','0','D:\QuickBooks\Inventory\Inventory Control November 08.xls','33','WSUN','START','Dec 12 2008 10:31AM' UNION ALL

    SELECT '61819','171349','0','D:\QuickBooks\Inventory\Inventory Control November 08.xls','33','WSUN','STOP','Dec 12 2008 10:31AM' UNION ALL

    SELECT '61820','171353','0','D:\QuickBooks\Inventory\Inventory Control November 08.xls','17','WSUN','START','Dec 12 2008 10:31AM' UNION ALL

    SELECT '61822','171351','0','D:\QuickBooks\Inventory\Inventory Control November 08.xls','33','WSUN','STOP','Dec 12 2008 10:31AM' UNION ALL

    SELECT '61824','171361','0','D:\QuickBooks\Inventory\Inventory Control November 08.xls','33','WSUN','START','Dec 12 2008 10:31AM' UNION ALL

    SELECT '61826','171364','0','D:\QuickBooks\Inventory\Inventory Control November 08.xls','33','WSUN','START','Dec 12 2008 10:31AM' UNION ALL

    SELECT '61827','171353','0','D:\QuickBooks\Inventory\Inventory Control November 08.xls','17','WSUN','STOP','Dec 12 2008 10:31AM' UNION ALL

    SELECT '61829','171361','0','D:\QuickBooks\Inventory\Inventory Control November 08.xls','33','WSUN','STOP','Dec 12 2008 10:31AM' UNION ALL

    SELECT '61830','171366','0','D:\QuickBooks\Inventory\Inventory Control November 08.xls','35','WSUN','START','Dec 12 2008 10:31AM' UNION ALL

    SELECT '61831','171364','0','D:\QuickBooks\Inventory\Inventory Control November 08.xls','33','WSUN','STOP','Dec 12 2008 10:31AM' UNION ALL

    SELECT '61861','171392','0','D:\QuickBooks\Inventory\Inventory Control November 08.xls','0','WSUN','START','Dec 12 2008 10:31AM' UNION ALL

    SELECT '61866','171366','0','D:\QuickBooks\Inventory\Inventory Control November 08.xls','35','WSUN','STOP','Dec 12 2008 10:32AM' UNION ALL

    SELECT '61867','171392','0','D:\QuickBooks\Inventory\Inventory Control November 08.xls','0','WSUN','STOP','Dec 12 2008 10:32AM' UNION ALL

    SELECT '63229','168727','0','D:\Users\Wsun\Xunlei\ENGote.xls','35','WSUN','STOP','Dec 12 2008 11:01AM' UNION ALL

    SELECT '63230','172341','3','D:\Users\Wsun\Xunlei\ENGote.xls','35','WSUN','START','Dec 12 2008 11:01AM' UNION ALL

    SELECT '63538','172341','3','D:\Users\Wsun\Xunlei\ENGote.xls','35','WSUN','STOP','Dec 12 2008 11:07AM' UNION ALL

    SELECT '63539','172518','0','D:\Users\Wsun\Xunlei\ENGote.xls','17','WSUN','START','Dec 12 2008 11:07AM' UNION ALL

    SELECT '63541','172525','0','D:\Users\Wsun\Xunlei\ENGote.xls','35','WSUN','START','Dec 12 2008 11:07AM' UNION ALL

    SELECT '63542','172518','0','D:\Users\Wsun\Xunlei\ENGote.xls','17','WSUN','STOP','Dec 12 2008 11:07AM' UNION ALL

    SELECT '63544','172525','3','D:\Users\Wsun\Xunlei\ENGote.xls','35','WSUN','STOP','Dec 12 2008 11:07AM' UNION ALL

    SELECT '63551','172534','0','D:\Users\Wsun\Xunlei\ENGote.xls','0','WSUN','START','Dec 12 2008 11:07AM' UNION ALL

    SELECT '63552','172534','0','D:\Users\Wsun\Xunlei\ENGote.xls','0','WSUN','STOP','Dec 12 2008 11:07AM' UNION ALL

    SELECT '63698','172633','0','D:\Human Resources\401K\401K Introductory letter.doc','35','SROANE','START','Dec 12 2008 11:17AM' UNION ALL

    SELECT '63700','172635','0','D:\Human Resources\401K\401K Introductory letter.doc','0','SROANE','START','Dec 12 2008 11:17AM' UNION ALL

    SELECT '63706','172635','0','D:\Human Resources\401K\401K Introductory letter.doc','0','SROANE','STOP','Dec 12 2008 11:17AM' UNION ALL

    SELECT '63714','172643','0','D:\Human Resources\401K\401K Introductory letter.doc','0','SROANE','START','Dec 12 2008 11:18AM' UNION ALL

    SELECT '63717','172633','0','D:\Human Resources\401K\401K Introductory letter.doc','35','SROANE','STOP','Dec 12 2008 11:18AM' UNION ALL

    SELECT '63718','172643','0','D:\Human Resources\401K\401K Introductory letter.doc','0','SROANE','STOP','Dec 12 2008 11:18AM' UNION ALL

    SELECT '63827','172726','0','D:\Human Resources\Trackers - 2008.xls','35','SROANE','START','Dec 12 2008 11:22AM' UNION ALL

    SELECT '63828','172727','0','D:\Human Resources\Trackers - 2008.xls','0','SROANE','START','Dec 12 2008 11:22AM' UNION ALL

    SELECT '63841','172727','0','D:\Human Resources\Trackers - 2008.xls','0','SROANE','STOP','Dec 12 2008 11:22AM' UNION ALL

    SELECT '63844','172726','0','D:\Human Resources\Trackers - 2008.xls','35','SROANE','STOP','Dec 12 2008 11:22AM' UNION ALL

    SELECT '63846','172740','3','D:\Human Resources\Trackers - 2008.xls','35','SROANE','START','Dec 12 2008 11:22AM' UNION ALL

    SELECT '64038','172740','3','D:\Human Resources\Trackers - 2008.xls','35','SROANE','STOP','Dec 12 2008 11:24AM' UNION ALL

    SELECT '70732','176439','0','D:\Users\mcole\WDI COLLECTIONS\report 11-24.xls','1','MCOLE','START','Dec 12 2008 1:31PM' UNION ALL

    SELECT '70734','176441','0','D:\Users\mcole\WDI COLLECTIONS\report 11-24.xls','35','MCOLE','START','Dec 12 2008 1:31PM' UNION ALL

    SELECT '70735','176439','0','D:\Users\mcole\WDI COLLECTIONS\report 11-24.xls','1','MCOLE','STOP','Dec 12 2008 1:31PM' UNION ALL

    SELECT '70736','176442','0','D:\Users\mcole\WDI COLLECTIONS\report 11-24.xls','0','MCOLE','START','Dec 12 2008 1:31PM' UNION ALL

    SELECT '70742','176441','0','D:\Users\mcole\WDI COLLECTIONS\report 11-24.xls','35','MCOLE','STOP','Dec 12 2008 1:31PM' UNION ALL

    SELECT '70743','176442','0','D:\Users\mcole\WDI COLLECTIONS\report 11-24.xls','0','MCOLE','STOP','Dec 12 2008 1:31PM' UNION ALL

    SELECT '70744','176447','0','D:\Users\mcole\WDI COLLECTIONS\report 11-24.xls','1','MCOLE','START','Dec 12 2008 1:31PM' UNION ALL

    SELECT '70746','176449','0','D:\Users\mcole\WDI COLLECTIONS\report 11-24.xls','35','MCOLE','START','Dec 12 2008 1:31PM' UNION ALL

    SELECT '70747','176447','0','D:\Users\mcole\WDI COLLECTIONS\report 11-24.xls','1','MCOLE','STOP','Dec 12 2008 1:31PM' UNION ALL

    SELECT '70748','176450','0','D:\Users\mcole\WDI COLLECTIONS\report 11-24.xls','0','MCOLE','START','Dec 12 2008 1:31PM' UNION ALL

    SELECT '70757','176450','0','D:\Users\mcole\WDI COLLECTIONS\report 11-24.xls','0','MCOLE','STOP','Dec 12 2008 1:31PM' UNION ALL

    SELECT '70809','176628','0','D:\QuickBooks\COLLECTION\Weatherford\WEATHERFORD ACCOUNT STATUS.xls','1','JFRANK','START','Dec 12 2008 1:36PM' UNION ALL

    SELECT '70810','176630','0','D:\QuickBooks\COLLECTION\Weatherford\WEATHERFORD ACCOUNT STATUS.xls','33','JFRANK','START','Dec 12 2008 1:36PM' UNION ALL

    SELECT '70811','176628','0','D:\QuickBooks\COLLECTION\Weatherford\WEATHERFORD ACCOUNT STATUS.xls','1','JFRANK','STOP','Dec 12 2008 1:36PM' UNION ALL

    SELECT '70812','176632','0','D:\QuickBooks\COLLECTION\Weatherford\WEATHERFORD ACCOUNT STATUS.xls','35','JFRANK','START','Dec 12 2008 1:36PM' UNION ALL

    SELECT '70813','176630','0','D:\QuickBooks\COLLECTION\Weatherford\WEATHERFORD ACCOUNT STATUS.xls','33','JFRANK','STOP','Dec 12 2008 1:36PM' UNION ALL

    SELECT '70814','176634','0','D:\QuickBooks\COLLECTION\Weatherford\WEATHERFORD ACCOUNT STATUS.xls','0','JFRANK','START','Dec 12 2008 1:36PM' UNION ALL

    SELECT '70817','176632','0','D:\QuickBooks\COLLECTION\Weatherford\WEATHERFORD ACCOUNT STATUS.xls','35','JFRANK','STOP','Dec 12 2008 1:36PM' UNION ALL

    SELECT '70818','176634','0','D:\QuickBooks\COLLECTION\Weatherford\WEATHERFORD ACCOUNT STATUS.xls','0','JFRANK','STOP','Dec 12 2008 1:36PM' UNION ALL

    SELECT '70830','176655','0','D:\QuickBooks\COLLECTION\Statements\12-8-08 -JENNY.xls','33','JFRANK','START','Dec 12 2008 1:37PM' UNION ALL

    SELECT '70831','176657','0','D:\QuickBooks\COLLECTION\Statements\12-8-08 -JENNY.xls','35','JFRANK','START','Dec 12 2008 1:37PM' UNION ALL

    SELECT '70832','176655','0','D:\QuickBooks\COLLECTION\Statements\12-8-08 -JENNY.xls','33','JFRANK','STOP','Dec 12 2008 1:37PM' UNION ALL

    SELECT '70833','176659','0','D:\QuickBooks\COLLECTION\Statements\12-8-08 -JENNY.xls','0','JFRANK','START','Dec 12 2008 1:37PM' UNION ALL

    SELECT '70836','176666','0','D:\QuickBooks\COLLECTION\Statements\12-8-08 -JENNY.xls','33','JFRANK','START','Dec 12 2008 1:37PM' UNION ALL

    SELECT '70837','176657','0','D:\QuickBooks\COLLECTION\Statements\12-8-08 -JENNY.xls','35','JFRANK','STOP','Dec 12 2008 1:37PM' UNION ALL

    SELECT '70838','176659','0','D:\QuickBooks\COLLECTION\Statements\12-8-08 -JENNY.xls','0','JFRANK','STOP','Dec 12 2008 1:37PM' UNION ALL

    SELECT '70839','176666','0','D:\QuickBooks\COLLECTION\Statements\12-8-08 -JENNY.xls','33','JFRANK','STOP','Dec 12 2008 1:37PM' UNION ALL

    SELECT '70855','176680','0','D:\QuickBooks\COLLECTION\Statements\12-8-08 -JENNY.xls','1','JFRANK','START','Dec 12 2008 1:38PM' UNION ALL

    SELECT '70856','176684','0','D:\QuickBooks\COLLECTION\Statements\12-8-08 -JENNY.xls','35','JFRANK','START','Dec 12 2008 1:38PM' UNION ALL

    SELECT '70857','176680','0','D:\QuickBooks\COLLECTION\Statements\12-8-08 -JENNY.xls','1','JFRANK','STOP','Dec 12 2008 1:38PM' UNION ALL

    SELECT '70858','176686','0','D:\QuickBooks\COLLECTION\Statements\12-8-08 -JENNY.xls','0','JFRANK','START','Dec 12 2008 1:38PM' UNION ALL

    SELECT '70862','176686','0','D:\QuickBooks\COLLECTION\Statements\12-8-08 -JENNY.xls','0','JFRANK','STOP','Dec 12 2008 1:38PM' UNION ALL

    SELECT '71116','176911','0','D:\Human Resources\Personnel\Offer Letters\Offer Letter - Cindy Johnson.doc','35','SROANE','START','Dec 12 2008 1:48PM' UNION ALL

    SELECT '71118','176913','0','D:\Human Resources\Personnel\Offer Letters\Offer Letter - Cindy Johnson.doc','0','SROANE','START','Dec 12 2008 1:48PM' UNION ALL

    SELECT '71126','176913','0','D:\Human Resources\Personnel\Offer Letters\Offer Letter - Cindy Johnson.doc','0','SROANE','STOP','Dec 12 2008 1:48PM' UNION ALL

    SELECT '72812','177669','0','D:\Human Resources\Personnel\Offer Letters\Offer Letter - Cindy Johnson.doc','17','SROANE','START','Dec 12 2008 1:57PM' UNION ALL

    SELECT '72814','176911','0','D:\Human Resources\Personnel\Offer Letters\Offer Letter - Cindy Johnson.doc','35','SROANE','STOP','Dec 12 2008 1:57PM' UNION ALL

    SELECT '72816','177675','0','D:\Human Resources\Personnel\Offer Letters\Offer Letter - Cindy Johnson.doc','35','SROANE','START','Dec 12 2008 1:57PM' UNION ALL

    SELECT '72818','177680','0','D:\Human Resources\Personnel\Offer Letters\Offer Letter - Cindy Johnson.doc','0','SROANE','START','Dec 12 2008 1:57PM' UNION ALL

    SELECT '72819','177669','0','D:\Human Resources\Personnel\Offer Letters\Offer Letter - Cindy Johnson.doc','17','SROANE','STOP','Dec 12 2008 1:57PM' UNION ALL

    SELECT '72825','177686','0','D:\Human Resources\Personnel\Offer Letters\Offer Letter - Jamie Bednar.doc','35','SROANE','START','Dec 12 2008 1:57PM' UNION ALL

    SELECT '72826','177688','0','D:\Human Resources\Personnel\Offer Letters\Offer Letter - Jamie Bednar.doc','0','SROANE','START','Dec 12 2008 1:57PM' UNION ALL

    SELECT '72832','177680','0','D:\Human Resources\Personnel\Offer Letters\Offer Letter - Cindy Johnson.doc','0','SROANE','STOP','Dec 12 2008 1:57PM' UNION ALL

    SELECT '72833','177688','0','D:\Human Resources\Personnel\Offer Letters\Offer Letter - Jamie Bednar.doc','0','SROANE','STOP','Dec 12 2008 1:57PM' UNION ALL

    SELECT '72840','177707','0','D:\Human Resources\Personnel\Offer Letters\Offer Letter - Jamie Bednar.doc','35','SROANE','START','Dec 12 2008 1:58PM' UNION ALL

    SELECT '72841','177686','0','D:\Human Resources\Personnel\Offer Letters\Offer Letter - Jamie Bednar.doc','35','SROANE','STOP','Dec 12 2008 1:58PM' UNION ALL

    SELECT '72848','177707','3','D:\Human Resources\Personnel\Offer Letters\Offer Letter - Jamie Bednar.doc','35','SROANE','STOP','Dec 12 2008 1:58PM' UNION ALL

    SELECT '72849','177675','3','D:\Human Resources\Personnel\Offer Letters\Offer Letter - Cindy Johnson.doc','35','SROANE','STOP','Dec 12 2008 1:58PM' UNION ALL

    SELECT '72858','177734','0','D:\Human Resources\Personnel\Offer Letters\Offer Letter - Cindy Johnson.doc','1','SROANE','START','Dec 12 2008 1:58PM' UNION ALL

    SELECT '72859','177735','0','D:\Human Resources\Personnel\Offer Letters\Offer Letter - Cindy Johnson.doc','0','SROANE','START','Dec 12 2008 1:58PM' UNION ALL

    SELECT '72867','177745','0','D:\Human Resources\Personnel\Offer Letters\Offer Letter - Jamie Bednar.doc','1','SROANE','START','Dec 12 2008 1:58PM' UNION ALL

    SELECT '72869','177746','0','D:\Human Resources\Personnel\Offer Letters\Offer Letter - Jamie Bednar.doc','0','SROANE','START','Dec 12 2008 1:58PM' UNION ALL

    SELECT '72883','177734','0','D:\Human Resources\Personnel\Offer Letters\Offer Letter - Cindy Johnson.doc','1','SROANE','STOP','Dec 12 2008 1:58PM' UNION ALL

    SELECT '72884','177735','0','D:\Human Resources\Personnel\Offer Letters\Offer Letter - Cindy Johnson.doc','0','SROANE','STOP','Dec 12 2008 1:58PM' UNION ALL

    SELECT '72885','177745','0','D:\Human Resources\Personnel\Offer Letters\Offer Letter - Jamie Bednar.doc','1','SROANE','STOP','Dec 12 2008 1:58PM' UNION ALL

    SELECT '72886','177746','0','D:\Human Resources\Personnel\Offer Letters\Offer Letter - Jamie Bednar.doc','0','SROANE','STOP','Dec 12 2008 1:58PM' UNION ALL

    SELECT '73164','178567','0','D:\Users\Wsun\Inventory\2008\11-30-08 Inventory Summary.xls','35','WSUN','START','Dec 12 2008 2:12PM' UNION ALL

    SELECT '73200','178775','0','D:\Users\mcole\WDI COLLECTIONS\report 11-24.xls','35','MCOLE','START','Dec 12 2008 2:16PM' UNION ALL

    SELECT '73201','176449','0','D:\Users\mcole\WDI COLLECTIONS\report 11-24.xls','35','MCOLE','STOP','Dec 12 2008 2:16PM' UNION ALL

    SELECT '73228','178966','0','D:\Users\Wsun\Inventory\2008\11-30-08 Inventory Summary.xls','35','WSUN','START','Dec 12 2008 2:17PM' UNION ALL

    SELECT '73229','178567','3','D:\Users\Wsun\Inventory\2008\11-30-08 Inventory Summary.xls','35','WSUN','STOP','Dec 12 2008 2:17PM' UNION ALL

    SELECT '73271','178995','0','D:\Human Resources\Personnel\Employee list 2.xls','1','TKISS','START','Dec 12 2008 2:19PM' UNION ALL

    SELECT '73272','178996','0','D:\Human Resources\Personnel\Employee list 2.xls','0','TKISS','START','Dec 12 2008 2:19PM' UNION ALL

    SELECT '73275','179000','0','D:\Human Resources\Personnel\Employee list 2.xls','35','TKISS','START','Dec 12 2008 2:19PM' UNION ALL

    SELECT '73276','178995','0','D:\Human Resources\Personnel\Employee list 2.xls','1','TKISS','STOP','Dec 12 2008 2:19PM' UNION ALL

    SELECT '73277','178996','0','D:\Human Resources\Personnel\Employee list 2.xls','0','TKISS','STOP','Dec 12 2008 2:19PM' UNION ALL

    SELECT '73278','179001','0','D:\Human Resources\Personnel\Employee list 2.xls','0','TKISS','START','Dec 12 2008 2:19PM' UNION ALL

    SELECT '73279','179001','0','D:\Human Resources\Personnel\Employee list 2.xls','0','TKISS','STOP','Dec 12 2008 2:19PM' UNION ALL

    SELECT '73282','179000','3','D:\Human Resources\Personnel\Employee list 2.xls','35','TKISS','STOP','Dec 12 2008 2:20PM' UNION ALL

    SELECT '73283','179007','0','D:\Human Resources\Personnel\Employee list 2.xls','1','TKISS','START','Dec 12 2008 2:20PM' UNION ALL

    SELECT '73286','179021','0','D:\Human Resources\Personnel\Employee list.xls','1','TKISS','START','Dec 12 2008 2:20PM' UNION ALL

    SELECT '73287','179022','0','D:\Human Resources\Personnel\Employee list.xls','0','TKISS','START','Dec 12 2008 2:20PM' UNION ALL

    SELECT '73288','179024','0','D:\Human Resources\Personnel\Employee list.xls','1','TKISS','START','Dec 12 2008 2:20PM' UNION ALL

    SELECT '73289','179021','0','D:\Human Resources\Personnel\Employee list.xls','1','TKISS','STOP','Dec 12 2008 2:20PM' UNION ALL

    SELECT '73290','179022','0','D:\Human Resources\Personnel\Employee list.xls','0','TKISS','STOP','Dec 12 2008 2:20PM' UNION ALL

    SELECT '73293','179007','0','D:\Human Resources\Personnel\Employee list 2.xls','1','TKISS','STOP','Dec 12 2008 2:20PM' UNION ALL

    SELECT '73294','179024','0','D:\Human Resources\Personnel\Employee list.xls','1','TKISS','STOP','Dec 12 2008 2:20PM' UNION ALL

    SELECT '73335','179064','0','D:\Users\Wsun\Inventory\2008\11-30-08 Inventory Summary.xls','35','WSUN','START','Dec 12 2008 2:23PM' UNION ALL

    SELECT '73336','178966','3','D:\Users\Wsun\Inventory\2008\11-30-08 Inventory Summary.xls','35','WSUN','STOP','Dec 12 2008 2:23PM' UNION ALL

    SELECT '73338','179065','0','D:\Human Resources\Payroll\salaried employees 9-1.xls','1','TKISS','START','Dec 12 2008 2:23PM' UNION ALL

    SELECT '73339','179066','0','D:\Human Resources\Payroll\salaried employees 9-1.xls','0','TKISS','START','Dec 12 2008 2:23PM' UNION ALL

    SELECT '73342','179070','0','D:\Human Resources\Payroll\salaried employees 9-1.xls','35','TKISS','START','Dec 12 2008 2:23PM' UNION ALL

    SELECT '73343','179065','0','D:\Human Resources\Payroll\salaried employees 9-1.xls','1','TKISS','STOP','Dec 12 2008 2:23PM' UNION ALL

    SELECT '73344','179066','0','D:\Human Resources\Payroll\salaried employees 9-1.xls','0','TKISS','STOP','Dec 12 2008 2:23PM' UNION ALL

    SELECT '73345','179071','0','D:\Human Resources\Payroll\salaried employees 9-1.xls','0','TKISS','START','Dec 12 2008 2:23PM' UNION ALL

    SELECT '73347','179073','2','D:\Human Resources\Payroll\salaried employees 9-1.xls','1','TKISS','START','Dec 12 2008 2:23PM' UNION ALL

    SELECT '73348','179071','0','D:\Human Resources\Payroll\salaried employees 9-1.xls','0','TKISS','STOP','Dec 12 2008 2:23PM' UNION ALL

    SELECT '73349','179073','2','D:\Human Resources\Payroll\salaried employees 9-1.xls','1','TKISS','STOP','Dec 12 2008 2:23PM' UNION ALL

    SELECT '73352','179070','3','D:\Human Resources\Payroll\salaried employees 9-1.xls','35','TKISS','STOP','Dec 12 2008 2:23PM' UNION ALL

    SELECT '73353','179077','0','D:\Human Resources\Payroll\salaried employees 9-1.xls','1','TKISS','START','Dec 12 2008 2:23PM' UNION ALL

    SELECT '73356','179077','0','D:\Human Resources\Payroll\salaried employees 9-1.xls','1','TKISS','STOP','Dec 12 2008 2:23PM' UNION ALL

    SELECT '74462','180060','0','D:\Users\wsun\Inventory\2008\10-31-08 Inventory Summary.xls','35','WSUN','START','Dec 12 2008 2:38PM' UNION ALL

    SELECT '74464','180061','0','D:\Users\wsun\Inventory\2008\10-31-08 Inventory Summary.xls','0','WSUN','START','Dec 12 2008 2:38PM' UNION ALL

    SELECT '74466','180061','0','D:\Users\wsun\Inventory\2008\10-31-08 Inventory Summary.xls','0','WSUN','STOP','Dec 12 2008 2:38PM' UNION ALL

    SELECT '74522','180060','0','D:\Users\wsun\Inventory\2008\10-31-08 Inventory Summary.xls','35','WSUN','STOP','Dec 12 2008 2:44PM' UNION ALL

    SELECT '74526','180210','0','D:\Users\wsun\Inventory\2008\10-31-08 Inventory Report.xls','35','WSUN','START','Dec 12 2008 2:44PM' UNION ALL

    SELECT '74528','180211','0','D:\Users\wsun\Inventory\2008\10-31-08 Inventory Report.xls','0','WSUN','START','Dec 12 2008 2:44PM' UNION ALL

    SELECT '74532','180211','0','D:\Users\wsun\Inventory\2008\10-31-08 Inventory Report.xls','0','WSUN','STOP','Dec 12 2008 2:44PM' UNION ALL

    SELECT '74537','180210','0','D:\Users\wsun\Inventory\2008\10-31-08 Inventory Report.xls','35','WSUN','STOP','Dec 12 2008 2:45PM' UNION ALL

    SELECT '74539','180234','3','D:\Users\wsun\Inventory\2008\10-31-08 Inventory Report.xls','35','WSUN','START','Dec 12 2008 2:45PM' UNION ALL

    SELECT '74542','179064','3','D:\Users\Wsun\Inventory\2008\11-30-08 Inventory Summary.xls','35','WSUN','STOP','Dec 12 2008 2:45PM' UNION ALL

    SELECT '74544','180245','3','D:\Users\Wsun\Inventory\2008\11-30-08 Inventory Summary.xls','35','WSUN','START','Dec 12 2008 2:45PM' UNION ALL

    SELECT '74615','180234','3','D:\Users\wsun\Inventory\2008\10-31-08 Inventory Report.xls','35','WSUN','STOP','Dec 12 2008 2:53PM' UNION ALL

    SELECT '74617','180245','3','D:\Users\Wsun\Inventory\2008\11-30-08 Inventory Summary.xls','35','WSUN','STOP','Dec 12 2008 2:53PM' UNION ALL

    SELECT '74619','182729','3','D:\Users\Wsun\Inventory\2008\11-30-08 Inventory Summary.xls','35','WSUN','START','Dec 12 2008 2:53PM' UNION ALL

    SELECT '74628','182729','3','D:\Users\Wsun\Inventory\2008\11-30-08 Inventory Summary.xls','35','WSUN','STOP','Dec 12 2008 2:53PM' UNION ALL

    SELECT '74630','182739','3','D:\Users\Wsun\Inventory\2008\11-30-08 Inventory Report.xls','35','WSUN','START','Dec 12 2008 2:53PM' UNION ALL

    SELECT '74633','182739','3','D:\Users\Wsun\Inventory\2008\11-30-08 Inventory Report.xls','35','WSUN','STOP','Dec 12 2008 2:53PM' UNION ALL

    SELECT '75690','183205','0','D:\QuickBooks\COLLECTION\Statements\12-8-08 -JENNY.xls','33','JFRANK','START','Dec 12 2008 2:57PM' UNION ALL

    SELECT '75691','183205','0','D:\QuickBooks\COLLECTION\Statements\12-8-08 -JENNY.xls','33','JFRANK','STOP','Dec 12 2008 2:57PM' UNION ALL

    SELECT '75692','183214','1','D:\QuickBooks\COLLECTION\Statements\12-8-08 -JENNY.xls','1','JFRANK','START','Dec 12 2008 2:57PM' UNION ALL

    SELECT '75693','183217','2','D:\QuickBooks\COLLECTION\Statements\12-8-08 -JENNY.xls','1','JFRANK','START','Dec 12 2008 2:57PM' UNION ALL

    SELECT '75694','183214','1','D:\QuickBooks\COLLECTION\Statements\12-8-08 -JENNY.xls','1','JFRANK','STOP','Dec 12 2008 2:57PM' UNION ALL

    SELECT '75695','183217','2','D:\QuickBooks\COLLECTION\Statements\12-8-08 -JENNY.xls','1','JFRANK','STOP','Dec 12 2008 2:57PM' UNION ALL

    SELECT '75944','183509','0','D:\Human Resources\Insurance Forms\Notice to Remove Dependent.doc','1','SROANE','START','Dec 12 2008 3:09PM' UNION ALL

    SELECT '75945','183510','0','D:\Human Resources\Insurance Forms\Notice to Remove Dependent.doc','0','SROANE','START','Dec 12 2008 3:09PM' UNION ALL

    SELECT '75949','183509','0','D:\Human Resources\Insurance Forms\Notice to Remove Dependent.doc','1','SROANE','STOP','Dec 12 2008 3:09PM' UNION ALL

    SELECT '75950','183510','0','D:\Human Resources\Insurance Forms\Notice to Remove Dependent.doc','0','SROANE','STOP','Dec 12 2008 3:09PM' UNION ALL

    SELECT '75960','183527','0','D:\Human Resources\Insurance Forms\Notice to Remove Dependent.doc','1','SROANE','START','Dec 12 2008 3:10PM' UNION ALL

    SELECT '75961','183530','0','D:\Human Resources\Insurance Forms\Notice to Remove Dependent.doc','35','SROANE','START','Dec 12 2008 3:10PM' UNION ALL

    SELECT '75963','183527','0','D:\Human Resources\Insurance Forms\Notice to Remove Dependent.doc','1','SROANE','STOP','Dec 12 2008 3:10PM' UNION ALL

    SELECT '75965','183541','0','D:\Human Resources\Insurance Forms\Notice to Remove Dependent.doc','35','SROANE','START','Dec 12 2008 3:10PM' UNION ALL

    SELECT '75966','183545','0','D:\Human Resources\Insurance Forms\Notice to Remove Dependent.doc','0','SROANE','START','Dec 12 2008 3:10PM' UNION ALL

    SELECT '75967','183530','0','D:\Human Resources\Insurance Forms\Notice to Remove Dependent.doc','35','SROANE','STOP','Dec 12 2008 3:10PM' UNION ALL

    SELECT '75970','183541','3','D:\Human Resources\Insurance Forms\Notice to Remove Dependent.doc','35','SROANE','STOP','Dec 12 2008 3:10PM' UNION ALL

    SELECT '75975','183545','0','D:\Human Resources\Insurance Forms\Notice to Remove Dependent.doc','0','SROANE','STOP','Dec 12 2008 3:10PM' UNION ALL

    SELECT '75987','183561','0','D:\Human Resources\Insurance Forms\Notice to Remove Dependent.doc','35','SROANE','START','Dec 12 2008 3:11PM' UNION ALL

    SELECT '75989','183563','0','D:\Human Resources\Insurance Forms\Notice to Remove Dependent.doc','0','SROANE','START','Dec 12 2008 3:11PM' UNION ALL

    SELECT '75992','183563','0','D:\Human Resources\Insurance Forms\Notice to Remove Dependent.doc','0','SROANE','STOP','Dec 12 2008 3:11PM' UNION ALL

    SELECT '75996','183579','3','D:\Human Resources\Insurance Forms\Notice to Remove Dependent.doc','35','SROANE','START','Dec 12 2008 3:11PM' UNION ALL

    SELECT '75997','183561','0','D:\Human Resources\Insurance Forms\Notice to Remove Dependent.doc','35','SROANE','STOP','Dec 12 2008 3:11PM' UNION ALL

    SELECT '75999','183589','0','D:\Human Resources\Insurance Forms\Notice to Remove Dependent.doc','0','SROANE','START','Dec 12 2008 3:11PM' UNION ALL

    SELECT '76001','183579','3','D:\Human Resources\Insurance Forms\Notice to Remove Dependent.doc','35','SROANE','STOP','Dec 12 2008 3:11PM' UNION ALL

    SELECT '76002','183589','0','D:\Human Resources\Insurance Forms\Notice to Remove Dependent.doc','0','SROANE','STOP','Dec 12 2008 3:11PM' UNION ALL

    SELECT '76200','183745','0','D:\QuickBooks\Inventory\Inventory Control December 08.xls','33','WSUN','START','Dec 12 2008 3:26PM' UNION ALL

    SELECT '76201','170094','0','D:\QuickBooks\Inventory\Inventory Control December 08.xls','35','WSUN','STOP','Dec 12 2008 3:26PM' UNION ALL

    SELECT '76204','183749','0','D:\QuickBooks\Inventory\Inventory Control December 08.xls','17','WSUN','START','Dec 12 2008 3:26PM' UNION ALL

    SELECT '76206','183745','0','D:\QuickBooks\Inventory\Inventory Control December 08.xls','33','WSUN','STOP','Dec 12 2008 3:26PM' UNION ALL

    SELECT '76208','183757','0','D:\QuickBooks\Inventory\Inventory Control December 08.xls','33','WSUN','START','Dec 12 2008 3:26PM' UNION ALL

    SELECT '76210','183760','0','D:\QuickBooks\Inventory\Inventory Control December 08.xls','33','WSUN','START','Dec 12 2008 3:26PM' UNION ALL

    SELECT '76211','183749','0','D:\QuickBooks\Inventory\Inventory Control December 08.xls','17','WSUN','STOP','Dec 12 2008 3:26PM' UNION ALL

    SELECT '76213','183757','0','D:\QuickBooks\Inventory\Inventory Control December 08.xls','33','WSUN','STOP','Dec 12 2008 3:26PM' UNION ALL

    SELECT '76214','183762','0','D:\QuickBooks\Inventory\Inventory Control December 08.xls','35','WSUN','START','Dec 12 2008 3:26PM' UNION ALL

    SELECT '76215','183760','0','D:\QuickBooks\Inventory\Inventory Control December 08.xls','33','WSUN','STOP','Dec 12 2008 3:26PM' UNION ALL

    SELECT '77142','184160','0','D:\Users\Wsun\Inventory\2008\11-30-08 Inventory Report.xls','1','WSUN','START','Dec 12 2008 3:27PM' UNION ALL

    SELECT '77277','184160','0','D:\Users\Wsun\Inventory\2008\11-30-08 Inventory Report.xls','1','WSUN','STOP','Dec 12 2008 3:27PM' UNION ALL

    SELECT '77289','184160','0','D:\Users\Wsun\Inventory\2008\11-30-08 Inventory Report.xls','1','WSUN','STOP','Dec 12 2008 3:27PM' UNION ALL

    SELECT '77358','184232','0','D:\Users\mcole\WDI COLLECTIONS\report 11-24.xls','35','MCOLE','START','Dec 12 2008 3:33PM' UNION ALL

    SELECT '77359','178775','3','D:\Users\mcole\WDI COLLECTIONS\report 11-24.xls','35','MCOLE','STOP','Dec 12 2008 3:33PM' UNION ALL

    SELECT '77362','184232','3','D:\Users\mcole\WDI COLLECTIONS\report 11-24.xls','35','MCOLE','STOP','Dec 12 2008 3:33PM' UNION ALL

    SELECT '79065','185657','0','D:\Human Resources\Trackers - 2008.xls','35','SROANE','START','Dec 12 2008 4:14PM' UNION ALL

    SELECT '79066','185658','0','D:\Human Resources\Trackers - 2008.xls','0','SROANE','START','Dec 12 2008 4:14PM' UNION ALL

    SELECT '79069','185658','0','D:\Human Resources\Trackers - 2008.xls','0','SROANE','STOP','Dec 12 2008 4:14PM' UNION ALL

    SELECT '79095','185714','0','D:\Human Resources\Trackers - 2008.xls','35','SROANE','START','Dec 12 2008 4:16PM' UNION ALL

    SELECT '79096','185657','0','D:\Human Resources\Trackers - 2008.xls','35','SROANE','STOP','Dec 12 2008 4:16PM' UNION ALL

    SELECT '79107','185725','0','D:\Human Resources\Trackers - 2008.xls','17','SROANE','START','Dec 12 2008 4:16PM' UNION ALL

    SELECT '79109','185714','3','D:\Human Resources\Trackers - 2008.xls','35','SROANE','STOP','Dec 12 2008 4:16PM' UNION ALL

    SELECT '79111','185732','3','D:\Human Resources\Trackers - 2008.xls','35','SROANE','START','Dec 12 2008 4:16PM' UNION ALL

    SELECT '79112','185725','0','D:\Human Resources\Trackers - 2008.xls','17','SROANE','STOP','Dec 12 2008 4:16PM' UNION ALL

    SELECT '79192','185732','3','D:\Human Resources\Trackers - 2008.xls','35','SROANE','STOP','Dec 12 2008 4:22PM' UNION ALL

    SELECT '79194','185832','3','D:\Human Resources\Trackers - 2008.xls','35','SROANE','START','Dec 12 2008 4:22PM' UNION ALL

    SELECT '79201','185835','0','D:\Human Resources\Trackers - 2008.xls','17','SROANE','START','Dec 12 2008 4:22PM' UNION ALL

    SELECT '79203','185832','3','D:\Human Resources\Trackers - 2008.xls','35','SROANE','STOP','Dec 12 2008 4:22PM' UNION ALL

    SELECT '79205','185842','3','D:\Human Resources\Trackers - 2008.xls','35','SROANE','START','Dec 12 2008 4:22PM' UNION ALL

    SELECT '79206','185835','0','D:\Human Resources\Trackers - 2008.xls','17','SROANE','STOP','Dec 12 2008 4:22PM' UNION ALL

    SELECT '79316','186001','0','D:\QuickBooks\COLLECTION\Statements\12-8-08 -JENNY.xls','33','JFRANK','START','Dec 12 2008 4:26PM' UNION ALL

    SELECT '79317','176684','3','D:\QuickBooks\COLLECTION\Statements\12-8-08 -JENNY.xls','35','JFRANK','STOP','Dec 12 2008 4:26PM' UNION ALL

    SELECT '79319','186001','0','D:\QuickBooks\COLLECTION\Statements\12-8-08 -JENNY.xls','33','JFRANK','STOP','Dec 12 2008 4:26PM' UNION ALL

    SELECT '79320','186009','0','D:\QuickBooks\COLLECTION\Statements\12-8-08 -JENNY.xls','17','JFRANK','START','Dec 12 2008 4:26PM' UNION ALL

    SELECT '79322','186020','0','D:\QuickBooks\COLLECTION\Statements\12-8-08 -JENNY.xls','33','JFRANK','START','Dec 12 2008 4:26PM' UNION ALL

    SELECT '79323','186009','0','D:\QuickBooks\COLLECTION\Statements\12-8-08 -JENNY.xls','17','JFRANK','STOP','Dec 12 2008 4:26PM' UNION ALL

    SELECT '79325','186022','0','D:\QuickBooks\COLLECTION\Statements\12-8-08 -JENNY.xls','35','JFRANK','START','Dec 12 2008 4:26PM' UNION ALL

    SELECT '79326','186020','0','D:\QuickBooks\COLLECTION\Statements\12-8-08 -JENNY.xls','33','JFRANK','STOP','Dec 12 2008 4:26PM' UNION ALL

    SELECT '79328','186022','0','D:\QuickBooks\COLLECTION\Statements\12-8-08 -JENNY.xls','35','JFRANK','STOP','Dec 12 2008 4:26PM' UNION ALL

    SELECT '80600','189526','0','D:\Human Resources\Personnel\Employee list 2.xls','35','SROANE','START','Dec 12 2008 4:45PM' UNION ALL

    SELECT '80602','189527','0','D:\Human Resources\Personnel\Employee list 2.xls','0','SROANE','START','Dec 12 2008 4:45PM' UNION ALL

    SELECT '80609','189527','0','D:\Human Resources\Personnel\Employee list 2.xls','0','SROANE','STOP','Dec 12 2008 4:45PM' UNION ALL

    SELECT '80625','189526','0','D:\Human Resources\Personnel\Employee list 2.xls','35','SROANE','STOP','Dec 12 2008 4:49PM' UNION ALL

    SELECT '80626','185842','3','D:\Human Resources\Trackers - 2008.xls','35','SROANE','STOP','Dec 12 2008 4:49PM' UNION ALL

    SELECT '81101','201196','3','D:\Users\Wsun\2008\hvc\MIP Invoice# 0214.xls','35','WSUN','START','Dec 12 2008 4:57PM' UNION ALL

    SELECT '81110','201196','3','D:\Users\Wsun\2008\hvc\MIP Invoice# 0214.xls','35','WSUN','STOP','Dec 12 2008 4:57PM' UNION ALL

    SELECT '81247','203686','0','D:\QuickBooks\Inventory\Inventory Control December 08.xls','33','WSUN','START','Dec 12 2008 5:03PM' UNION ALL

    SELECT '81248','183762','0','D:\QuickBooks\Inventory\Inventory Control December 08.xls','35','WSUN','STOP','Dec 12 2008 5:03PM' UNION ALL

    SELECT '81251','203690','0','D:\QuickBooks\Inventory\Inventory Control December 08.xls','17','WSUN','START','Dec 12 2008 5:03PM' UNION ALL

    SELECT '81252','203686','0','D:\QuickBooks\Inventory\Inventory Control December 08.xls','33','WSUN','STOP','Dec 12 2008 5:03PM' UNION ALL

    SELECT '81254','203701','0','D:\QuickBooks\Inventory\Inventory Control December 08.xls','33','WSUN','START','Dec 12 2008 5:03PM' UNION ALL

    SELECT '81255','203690','0','D:\QuickBooks\Inventory\Inventory Control December 08.xls','17','WSUN','STOP','Dec 12 2008 5:03PM' UNION ALL

    SELECT '81257','203703','0','D:\QuickBooks\Inventory\Inventory Control December 08.xls','35','WSUN','START','Dec 12 2008 5:03PM' UNION ALL

    SELECT '81258','203701','0','D:\QuickBooks\Inventory\Inventory Control December 08.xls','33','WSUN','STOP','Dec 12 2008 5:03PM' UNION ALL

    SELECT '81259','203705','0','D:\QuickBooks\Inventory\Inventory Control December 08.xls','0','WSUN','START','Dec 12 2008 5:03PM' UNION ALL

    SELECT '81262','203703','0','D:\QuickBooks\Inventory\Inventory Control December 08.xls','35','WSUN','STOP','Dec 12 2008 5:03PM' UNION ALL

    SELECT '81263','203705','0','D:\QuickBooks\Inventory\Inventory Control December 08.xls','0','WSUN','STOP','Dec 12 2008 5:03PM' UNION ALL

    INSERT INTO #file_modify([id], [FullPath], [ChangeType], [dttm])

    SELECT '29248','D:\Users\eburnett\aaquality wdi rev102606\aaawdi manufacturing qms\REVISIONS\WORKINGeed maintaince.DOC','Created','Dec 12 2008 8:12AM' UNION ALL

    SELECT '29254','D:\Users\eburnett\aaquality wdi rev102606\aaawdi manufacturing qms\REVISIONS\WORKINGeed maintaince JD.DOC///D:\Users\eburnett\','Renamed','Dec 12 2008 8:12AM' UNION ALL

    SELECT '29297','D:\QuickBooks\Inventory\Inventory Control December 08.xls','Changed','Dec 12 2008 8:14AM' UNION ALL

    SELECT '29301','D:\Users\rhernandez\EALT3.xls','Created','Dec 12 2008 8:14AM' UNION ALL

    SELECT '29303','D:\Warehouse\Tomball Warehouse\EAL.xls','Deleted','Dec 12 2008 8:14AM' UNION ALL

    SELECT '29307','D:\Warehouse\Tomball Warehouse\EAL.xls','Created','Dec 12 2008 8:14AM' UNION ALL

    SELECT '29312','D:\Warehouse\TOMBALL BACKORDER REPORT\Tomball Backorder Report.xls','Deleted','Dec 12 2008 8:14AM' UNION ALL

    SELECT '29316','D:\Warehouse\TOMBALL BACKORDER REPORT\Tomball Backorder Report.xls','Created','Dec 12 2008 8:14AM' UNION ALL

    SELECT '29496','D:\Users\eburnett\aaquality wdi rev102606\aaawdi manufacturing qms\REVISIONS\COMPLETE READY\WDIMQP 6202 REV C JD MANUFACTURING ','Created','Dec 12 2008 8:16AM' UNION ALL

    SELECT '29500','D:\Users\eburnett\aaquality wdi rev102606\aaawdi manufacturing qms\REVISIONS\COMPLETE READY\WDIMQP 6202 REV C JD MANUFACTURING ','Deleted','Dec 12 2008 8:16AM' UNION ALL

    SELECT '29504','D:\Users\eburnett\aaquality wdi rev102606\aaawdi manufacturing qms\REVISIONS\COMPLETE READY\WDIMQP 6202 REV C JD MANUFACTURING ','Created','Dec 12 2008 8:16AM' UNION ALL

    SELECT '29534','D:\Users\eburnett\aaquality wdi rev102606\aaawdi manufacturing qms\REVISIONS\WORKING\WDIMQP 6202 REV B JD MANUFACTURING PLANT M','Deleted','Dec 12 2008 8:17AM' UNION ALL

    SELECT '29535','D:\Users\eburnett\aaquality wdi rev102606\aaawdi manufacturing qms\REVISIONS\OBOSOLETE\WDIMQP 6202 REV B JD MANUFACTURING PLANT','Created','Dec 12 2008 8:17AM' UNION ALL

    SELECT '29656','D:\Users\eburnett\aaquality wdi rev102606\aaawdi manufacturing qms\REVISIONS\COMPLETE READY\WDIMQP 6210 REV C JD MANUAL MILL OPE','Created','Dec 12 2008 8:18AM' UNION ALL

    SELECT '29659','D:\Users\eburnett\aaquality wdi rev102606\aaawdi manufacturing qms\REVISIONS\COMPLETE READY\WDIMQP 6210 REV C JD MANUAL MILL OPE','Deleted','Dec 12 2008 8:18AM' UNION ALL

    SELECT '29663','D:\Users\eburnett\aaquality wdi rev102606\aaawdi manufacturing qms\REVISIONS\COMPLETE READY\WDIMQP 6210 REV C JD MANUAL MILL OPE','Created','Dec 12 2008 8:18AM' UNION ALL

    SELECT '29664','D:\Users\eburnett\aaquality wdi rev102606\aaawdi manufacturing qms\REVISIONS\WORKING\WDIMQP 6210 REV B JD MANUAL MILL OPERATOR.D','Deleted','Dec 12 2008 8:19AM' UNION ALL

    SELECT '29665','D:\Users\eburnett\aaquality wdi rev102606\aaawdi manufacturing qms\REVISIONS\OBOSOLETE\WDIMQP 6210 REV B JD MANUAL MILL OPERATOR','Created','Dec 12 2008 8:19AM' UNION ALL

    SELECT '29685','D:\Users\eburnett\aaquality wdi rev102606\aaawdi manufacturing qms\REVISIONS\COMPLETE READY\WDIMQP 6209 REV C JD LATHE OPERATOR.','Created','Dec 12 2008 8:19AM' UNION ALL

    SELECT '29690','D:\Users\eburnett\aaquality wdi rev102606\aaawdi manufacturing qms\REVISIONS\COMPLETE READY\WDIMQP 6209 REV C JD LATHE OPERATOR.','Deleted','Dec 12 2008 8:20AM' UNION ALL

    SELECT '29694','D:\Users\eburnett\aaquality wdi rev102606\aaawdi manufacturing qms\REVISIONS\COMPLETE READY\WDIMQP 6209 REV C JD LATHE OPERATOR.','Created','Dec 12 2008 8:20AM' UNION ALL

    SELECT '29701','D:\Users\eburnett\aaquality wdi rev102606\aaawdi manufacturing qms\REVISIONS\COMPLETE READY\WDIMQP 6211 REV C JD CNC OPERATOR.DO','Created','Dec 12 2008 8:20AM' UNION ALL

    SELECT '29702','D:\MTR\11-15-2008\08-11-15_WDI--LIST1\2008-11-15 PACKING LIST-WDI.xls','Changed','Dec 12 2008 8:20AM' UNION ALL

    SELECT '29703','D:\MTR\11-15-2008\08-11-15_WDI--LIST1\2008-11-15 PACKING LIST-WDI.xls','Changed','Dec 12 2008 8:21AM' UNION ALL

    SELECT '29706','D:\Users\eburnett\aaquality wdi rev102606\aaawdi manufacturing qms\REVISIONS\COMPLETE READY\WDIMQP 6211 REV C JD CNC OPERATOR.DO','Deleted','Dec 12 2008 8:21AM' UNION ALL

    SELECT '29710','D:\Users\eburnett\aaquality wdi rev102606\aaawdi manufacturing qms\REVISIONS\COMPLETE READY\WDIMQP 6211 REV C JD CNC OPERATOR.DO','Created','Dec 12 2008 8:21AM' UNION ALL

    SELECT '29714','D:\Users\eburnett\aaquality wdi rev102606\aaawdi manufacturing qms\REVISIONS\COMPLETE READY\WDIMQP 6211 REV C JD CNC OPERATOR.DO','Deleted','Dec 12 2008 8:21AM' UNION ALL

    SELECT '29718','D:\Users\eburnett\aaquality wdi rev102606\aaawdi manufacturing qms\REVISIONS\COMPLETE READY\WDIMQP 6211 REV C JD CNC OPERATOR.DO','Created','Dec 12 2008 8:21AM' UNION ALL

    SELECT '29724','D:\Users\eburnett\aaquality wdi rev102606\aaawdi manufacturing qms\REVISIONS\COMPLETE READY\WDIMQP 6220 REV A JD ASSEMBLER.doc','Created','Dec 12 2008 8:22AM' UNION ALL

    SELECT '29797','D:\Users\eburnett\aaquality wdi rev102606\aaawdi manufacturing qms\REVISIONS\COMPLETE READY\WDIMQP 6222 REV A JD CNC MACHNIST.DO','Created','Dec 12 2008 8:23AM' UNION ALL

    SELECT '29855','D:\Users\eburnett\aaquality wdi rev102606\aaawdi manufacturing qms\REVISIONS\WORKING\WDIMQP 6222 REV NC JD CNC MACHNIST.DOC','Deleted','Dec 12 2008 8:23AM' UNION ALL

    SELECT '29856','D:\Users\eburnett\aaquality wdi rev102606\aaawdi manufacturing qms\REVISIONS\OBOSOLETE\WDIMQP 6222 REV NC JD CNC MACHNIST.DOC','Created','Dec 12 2008 8:23AM' UNION ALL

    SELECT '29896','D:\Users\eburnett\aaquality wdi rev102606\aaawdi manufacturing qms\REVISIONS\WORKING\WDIMQP 6220 REV NC JD ASSEMBLER.doc','Deleted','Dec 12 2008 8:23AM' UNION ALL

    SELECT '29897','D:\Users\eburnett\aaquality wdi rev102606\aaawdi manufacturing qms\REVISIONS\OBOSOLETE\WDIMQP 6220 REV NC JD ASSEMBLER.doc','Created','Dec 12 2008 8:23AM' UNION ALL

    SELECT '29910','D:\Users\eburnett\aaquality wdi rev102606\aaawdi manufacturing qms\REVISIONS\WORKING\WDIMQP 6211 REV B JD CNC OPERATOR.DOC','Deleted','Dec 12 2008 8:23AM' UNION ALL

    SELECT '29911','D:\Users\eburnett\aaquality wdi rev102606\aaawdi manufacturing qms\REVISIONS\OBOSOLETE\WDIMQP 6211 REV B JD CNC OPERATOR.DOC','Created','Dec 12 2008 8:23AM' UNION ALL

    SELECT '29912','D:\Users\eburnett\aaquality wdi rev102606\aaawdi manufacturing qms\REVISIONS\WORKING\WDIMQP 6209 REV B JD LATHE OPERATOR.DOC','Deleted','Dec 12 2008 8:23AM' UNION ALL

    SELECT '29913','D:\Users\eburnett\aaquality wdi rev102606\aaawdi manufacturing qms\REVISIONS\OBOSOLETE\WDIMQP 6209 REV B JD LATHE OPERATOR.DOC','Created','Dec 12 2008 8:23AM' UNION ALL

    SELECT '30113','D:\Users\eburnett\aaquality wdi rev102606\aaawdi manufacturing qms\REVISIONS\COMPLETE READY\WDIMQP 6221 REV A JD SAW OPTERATOR.d','Created','Dec 12 2008 8:26AM' UNION ALL

    SELECT '30114','D:\Users\eburnett\aaquality wdi rev102606\aaawdi manufacturing qms\REVISIONS\WORKING\WDIMQP 6221 REV NC JD SAW OPTERATOR.doc','Deleted','Dec 12 2008 8:26AM' UNION ALL

    SELECT '30115','D:\Users\eburnett\aaquality wdi rev102606\aaawdi manufacturing qms\REVISIONS\OBOSOLETE\WDIMQP 6221 REV NC JD SAW OPTERATOR.doc','Created','Dec 12 2008 8:26AM' UNION ALL

    SELECT '30118','D:\Users\eburnett\aaquality wdi rev102606\aaawdi manufacturing qms\REVISIONS\WORKING\Manufacturing President JD Pending.DOC','Created','Dec 12 2008 8:27AM' UNION ALL

    SELECT '30199','D:\QuickBooks\Inventory\Inventory Control December 08.xls','Changed','Dec 12 2008 8:31AM' UNION ALL

    SELECT '30204','D:\QuickBooks\Inventory\Inventory Control December 08.xls~RF13b60213.TMP///D:\QuickBooks\Inventory\Inventory Control December 08','Renamed','Dec 12 2008 8:31AM' UNION ALL

    SELECT '30451','D:\Users\dbowen\Copy of Expense Report Form - BLANK.xls','Created','Dec 12 2008 8:37AM' UNION ALL

    SELECT '30452','D:\Users\dbowen\Copy of Expense Report Form - BLANK.xls','Deleted','Dec 12 2008 8:37AM' UNION ALL

    SELECT '30456','D:\Users\dbowen\Copy of Expense Report Form - BLANK.xls','Created','Dec 12 2008 8:37AM' UNION ALL

    SELECT '32284','D:\Warehouse\Tomball Warehouse\Cons. Inventory.xls','Deleted','Dec 12 2008 9:08AM' UNION ALL

    SELECT '32288','D:\Warehouse\Tomball Warehouse\Cons. Inventory.xls','Created','Dec 12 2008 9:08AM' UNION ALL

    SELECT '33401','D:\Users\wsun\Xunlei\ENGote.xls','Changed','Dec 12 2008 9:20AM' UNION ALL

    SELECT '34136','D:\Accounting\BalanceSheetComparison\2008\Canada-10-31-08.xls','Changed','Dec 12 2008 9:33AM' UNION ALL

    SELECT '34137','D:\Accounting\BalanceSheetComparison\2008\Canada-10-31-08.xls','Changed','Dec 12 2008 9:33AM' UNION ALL

    SELECT '34142','D:\Accounting\BalanceSheetComparison\2008\Canada-10-31-08.xls','Changed','Dec 12 2008 9:33AM' UNION ALL

    SELECT '34143','D:\Accounting\BalanceSheetComparison\2008\Canada-11-30-08.xls','Created','Dec 12 2008 9:33AM' UNION ALL

    SELECT '34144','D:\Accounting\BalanceSheetComparison\2008\Canada-11-30-08.xls','Deleted','Dec 12 2008 9:33AM' UNION ALL

    SELECT '34158','D:\Accounting\BalanceSheetComparison\2008\Canada-10-31-08.xls','Changed','Dec 12 2008 9:33AM' UNION ALL

    SELECT '34195','D:\Accounting\BalanceSheetComparison\2008\WDI-10-31-08.xls','Changed','Dec 12 2008 9:41AM' UNION ALL

    SELECT '34196','D:\Accounting\BalanceSheetComparison\2008\WDI-10-31-08.xls','Changed','Dec 12 2008 9:41AM' UNION ALL

    SELECT '34197','D:\Accounting\BalanceSheetComparison\2008\WDI-10-31-08.xls','Changed','Dec 12 2008 9:41AM' UNION ALL

    SELECT '34213','D:\Accounting\BalanceSheetComparison\2008\WDI-11-30-08.xls','Created','Dec 12 2008 9:42AM' UNION ALL

    SELECT '34214','D:\Accounting\BalanceSheetComparison\2008\WDI-11-30-08.xls','Deleted','Dec 12 2008 9:42AM' UNION ALL

    SELECT '34228','D:\Accounting\BalanceSheetComparison\2008\WDI-10-31-08.xls','Changed','Dec 12 2008 9:42AM' UNION ALL

    SELECT '34249','D:\Accounting\BalanceSheetComparison\2008\WDI-11-30-08.xls~RF3b3399f.TMP///D:\Accounting\BalanceSheetComparison\2008\WDI-11-30-0','Renamed','Dec 12 2008 9:42AM' UNION ALL

    SELECT '34269','D:\Accounting\BalanceSheetComparison\2008\Canada-11-30-08.xls~RF3b3705f.TMP///D:\Accounting\BalanceSheetComparison\2008\Canada-1','Renamed','Dec 12 2008 9:42AM' UNION ALL

    SELECT '34273','D:\Human Resources\Bonus Spreadsheet\2008 Xmas.xls','Changed','Dec 12 2008 9:43AM' UNION ALL

    SELECT '34274','D:\Users\mburkhalter\Marisa\time.xls','Changed','Dec 12 2008 9:43AM' UNION ALL

    SELECT '34275','D:\Human Resources\Bonus Spreadsheet\2008 Xmas.xls','Changed','Dec 12 2008 9:44AM' UNION ALL

    SELECT '34276','D:\Users\mburkhalter\AC-NOV.xls','Changed','Dec 12 2008 9:44AM' UNION ALL

    SELECT '34277','D:\Users\mburkhalter\AR-NOV.xls','Changed','Dec 12 2008 9:44AM' UNION ALL

    SELECT '34278','D:\Users\mburkhalter\MS-NOV.xls','Changed','Dec 12 2008 9:44AM' UNION ALL

    SELECT '34279','D:\Users\mburkhalter\NT-NOV.xls','Changed','Dec 12 2008 9:45AM' UNION ALL

    SELECT '34280','D:\Users\mburkhalter\PN-NOV.xls','Changed','Dec 12 2008 9:45AM' UNION ALL

    SELECT '34281','D:\Users\mburkhalter\RK-NOV.xls','Changed','Dec 12 2008 9:45AM' UNION ALL

    SELECT '34282','D:\Users\mburkhalter\ST-NOV.xls','Changed','Dec 12 2008 9:45AM' UNION ALL

    SELECT '34283','D:\Users\mburkhalter\TY-NOV.xls','Changed','Dec 12 2008 9:45AM' UNION ALL

    SELECT '34284','D:\Human Resources\HVC\Commissions\September sales commission.xls','Changed','Dec 12 2008 9:45AM' UNION ALL

    SELECT '34286','D:\MTR\10-24-08_WDI MTR\10-95885 2.doc','Deleted','Dec 12 2008 9:46AM' UNION ALL

    SELECT '34290','D:\MTR\10-24-08_WDI MTR\10-95885 2.doc','Created','Dec 12 2008 9:46AM' UNION ALL

    SELECT '34456','D:\Human Resources\HVC\Commissions\September sales commission.xls','Changed','Dec 12 2008 9:48AM' UNION ALL

    SELECT '34559','D:\Users\mburkhalter\TY-NOV.xls','Changed','Dec 12 2008 9:48AM' UNION ALL

    SELECT '34560','D:\Users\mburkhalter\ST-NOV.xls','Changed','Dec 12 2008 9:48AM' UNION ALL

    SELECT '34562','D:\Users\mburkhalter\RK-NOV.xls','Changed','Dec 12 2008 9:48AM' UNION ALL

    SELECT '34563','D:\Users\mburkhalter\PN-NOV.xls','Changed','Dec 12 2008 9:48AM' UNION ALL

    SELECT '34564','D:\Users\mburkhalter\NT-NOV.xls','Changed','Dec 12 2008 9:48AM' UNION ALL

    SELECT '34566','D:\Users\mburkhalter\MS-NOV.xls','Changed','Dec 12 2008 9:48AM' UNION ALL

    SELECT '34567','D:\Users\mburkhalter\AR-NOV.xls','Changed','Dec 12 2008 9:48AM' UNION ALL

    SELECT '34568','D:\Users\mburkhalter\AC-NOV.xls','Changed','Dec 12 2008 9:48AM' UNION ALL

    SELECT '34570','D:\Users\mcole\invoice.xls','Created','Dec 12 2008 9:49AM' UNION ALL

    SELECT '34571','D:\Users\mcole\invoice.xls','Deleted','Dec 12 2008 9:49AM' UNION ALL

    SELECT '34607','D:\Users\mburkhalter\Marisa\time.xls','Changed','Dec 12 2008 9:49AM' UNION ALL

    SELECT '34612','D:\Users\mburkhalter\Marisa\time.xls~RF3b9deac.TMP///D:\Users\mburkhalter\Marisa\time.xls','Renamed','Dec 12 2008 9:49AM' UNION ALL

    SELECT '34638','D:\Users\mburkhalter\Marisa\time.xls~RF3ba5ed9.TMP///D:\Users\mburkhalter\Marisa\time.xls','Renamed','Dec 12 2008 9:50AM' UNION ALL

    SELECT '34698','D:\QuickBooks\Inventory\Inventory Control December 08.xls~RF13fe663d.TMP///D:\QuickBooks\Inventory\Inventory Control December 08','Renamed','Dec 12 2008 9:51AM' UNION ALL

    SELECT '34900','D:\Manufacturing\Lisa M\Forms\Labels\File Lables.doc','Deleted','Dec 12 2008 10:06AM' UNION ALL

    SELECT '34904','D:\Manufacturing\Lisa M\Forms\Labels\File Lables.doc','Created','Dec 12 2008 10:06AM' UNION ALL

    SELECT '34906','D:\Accounting\BalanceSheetComparison\2008\Mfg-10-31-08.xls','Changed','Dec 12 2008 10:07AM' UNION ALL

    SELECT '34907','D:\Accounting\BalanceSheetComparison\2008\Mfg-10-31-08.xls','Changed','Dec 12 2008 10:07AM' UNION ALL

    SELECT '34908','D:\Accounting\BalanceSheetComparison\2008\Mfg-10-31-08.xls','Changed','Dec 12 2008 10:07AM' UNION ALL

    SELECT '34909','D:\Accounting\BalanceSheetComparison\2008\Mfg-11-30-08.xls','Created','Dec 12 2008 10:08AM' UNION ALL

    SELECT '34910','D:\Accounting\BalanceSheetComparison\2008\Mfg-11-30-08.xls','Deleted','Dec 12 2008 10:08AM' UNION ALL

    SELECT '34924','D:\Accounting\BalanceSheetComparison\2008\Mfg-10-31-08.xls','Changed','Dec 12 2008 10:08AM' UNION ALL

    SELECT '34942','D:\Accounting\BalanceSheetComparison\2008\Mfg-11-30-08.xls~RFf787a5db.TMP///D:\Accounting\BalanceSheetComparison\2008\Mfg-11-30-','Renamed','Dec 12 2008 10:08AM' UNION ALL

    SELECT '34965','D:\Accounting\BalanceSheetComparison\2008\Mfg-11-30-08.xls~RFf78954d4.TMP///D:\Accounting\BalanceSheetComparison\2008\Mfg-11-30-','Renamed','Dec 12 2008 10:10AM' UNION ALL

    SELECT '34987','D:\Accounting\BalanceSheetComparison\2008\Mfg-11-30-08.xls~RFf78af5b2.TMP///D:\Accounting\BalanceSheetComparison\2008\Mfg-11-30-','Renamed','Dec 12 2008 10:11AM' UNION ALL

    SELECT '35014','D:\Accounting\BalanceSheetComparison\2008\Mfg-11-30-08.xls~RFf78d7827.TMP///D:\Accounting\BalanceSheetComparison\2008\Mfg-11-30-','Renamed','Dec 12 2008 10:14AM' UNION ALL

    SELECT '35052','D:\Users\eburnett\aaquality wdi rev102606\aaawdi manufacturing qms\SECTION 6 MANF\WDIMQF 6014 REV A PERSONNENEL QUALIFICATION RE','Deleted','Dec 12 2008 10:22AM' UNION ALL

    SELECT '35056','D:\Users\eburnett\aaquality wdi rev102606\aaawdi manufacturing qms\SECTION 6 MANF\WDIMQF 6014 REV A PERSONNENEL QUALIFICATION RE','Created','Dec 12 2008 10:22AM' UNION ALL

    SELECT '35074','D:\Manufacturing\Lisa M\Credit Info\New Address.doc','Deleted','Dec 12 2008 10:23AM' UNION ALL

    SELECT '35078','D:\Manufacturing\Lisa M\Credit Info\New Address.doc','Created','Dec 12 2008 10:23AM' UNION ALL

    SELECT '35084','D:\Users\eburnett\aaquality wdi rev102606\aaawdi manufacturing qms\REVISIONS\WORKING\compantancy letter.doc','Deleted','Dec 12 2008 10:24AM' UNION ALL

    SELECT '35088','D:\Users\eburnett\aaquality wdi rev102606\aaawdi manufacturing qms\REVISIONS\WORKING\compantancy letter.doc','Created','Dec 12 2008 10:24AM' UNION ALL

    SELECT '35101','D:\Human Resources\Payroll tracker.xls','Changed','Dec 12 2008 10:25AM' UNION ALL

    SELECT '35115','D:\Human Resources\Payroll tracker.xls','Changed','Dec 12 2008 10:25AM' UNION ALL

    SELECT '35121','D:\Human Resources\Payroll tracker.xls~RF55096f96.TMP///D:\Human Resources\Payroll tracker.xls','Renamed','Dec 12 2008 10:25AM' UNION ALL

    SELECT '35186','D:\QuickBooks\Inventory\Inventory Control November 08.xls','Changed','Dec 12 2008 10:30AM' UNION ALL

    SELECT '35267','D:\QuickBooks\Inventory\Inventory Control November 08.xls','Changed','Dec 12 2008 10:31AM' UNION ALL

    SELECT '35272','D:\QuickBooks\Inventory\Inventory Control November 08.xls~RF142386b2.TMP///D:\QuickBooks\Inventory\Inventory Control November 08','Renamed','Dec 12 2008 10:31AM' UNION ALL

    SELECT '35295','D:\Users\mburkhalter\Marisa\time.xls','Changed','Dec 12 2008 10:34AM' UNION ALL

    SELECT '35296','D:\Accounting\BalanceSheetComparison\2008\Canada-11-30-08.xls','Changed','Dec 12 2008 10:34AM' UNION ALL

    SELECT '35440','D:\Manufacturing\Lisa M\Credit Info\CREDIT REFERENCES - MFG.doc','Deleted','Dec 12 2008 10:38AM' UNION ALL

    SELECT '35444','D:\Manufacturing\Lisa M\Credit Info\CREDIT REFERENCES - MFG.doc','Created','Dec 12 2008 10:38AM' UNION ALL

    SELECT '35448','D:\Manufacturing\Lisa M\Credit Info\CREDIT REFERENCES - MFG.doc','Deleted','Dec 12 2008 10:38AM' UNION ALL

    SELECT '35452','D:\Manufacturing\Lisa M\Credit Info\CREDIT REFERENCES - MFG.doc','Created','Dec 12 2008 10:38AM' UNION ALL

    SELECT '35467','D:\Manufacturing\Lisa M\Credit Info\WDI vs WDI Mfg.doc','Deleted','Dec 12 2008 10:39AM' UNION ALL

    SELECT '35471','D:\Manufacturing\Lisa M\Credit Info\WDI vs WDI Mfg.doc','Created','Dec 12 2008 10:39AM' UNION ALL

    SELECT '35485','D:\Users\eburnett\aaquality wdi rev102606\aaawdi manufacturing qms\SECTION 5 MANF\Management Review\MR 121008 WORKING.DOC','Deleted','Dec 12 2008 10:40AM' UNION ALL

    SELECT '35489','D:\Users\eburnett\aaquality wdi rev102606\aaawdi manufacturing qms\SECTION 5 MANF\Management Review\MR 121008 WORKING.DOC','Created','Dec 12 2008 10:40AM' UNION ALL

    SELECT '35510','D:\Users\mburkhalter\Marisa\time.xls','Changed','Dec 12 2008 10:41AM' UNION ALL

    SELECT '35566','D:\Accounting\BalanceSheetComparison\2008\Canada-11-30-08.xls','Changed','Dec 12 2008 10:43AM' UNION ALL

    SELECT '35571','D:\Accounting\BalanceSheetComparison\2008\Canada-11-30-08.xls~RF3eb833b.TMP///D:\Accounting\BalanceSheetComparison\2008\Canada-1','Renamed','Dec 12 2008 10:43AM' UNION ALL

    SELECT '35575','D:\Accounting\BalanceSheetComparison\2008\Canada-10-31-08.xls','Changed','Dec 12 2008 10:43AM' UNION ALL

    SELECT '35576','D:\Accounting\BalanceSheetComparison\2008\Canada-10-31-08.xls','Changed','Dec 12 2008 10:43AM' UNION ALL

    SELECT '35580','D:\Users\eburnett\aaquality wdi rev102606\aaawdi manufacturing qms\SECTION 5 MANF\Management Review\MR 121008 WORKING.DOC','Deleted','Dec 12 2008 10:44AM' UNION ALL

    SELECT '35584','D:\Users\eburnett\aaquality wdi rev102606\aaawdi manufacturing qms\SECTION 5 MANF\Management Review\MR 121008 WORKING.DOC','Created','Dec 12 2008 10:44AM' UNION ALL

    SELECT '35585','D:\Accounting\BalanceSheetComparison\2008\Canada-11-30-08.xls','Changed','Dec 12 2008 10:44AM' UNION ALL

    SELECT '35586','D:\Accounting\BalanceSheetComparison\2008\Canada-11-30-08.xls','Changed','Dec 12 2008 10:44AM' UNION ALL

    SELECT '35591','D:\Accounting\BalanceSheetComparison\2008\Canada-11-30-08.xls','Changed','Dec 12 2008 10:44AM' UNION ALL

    SELECT '35604','D:\Accounting\BalanceSheetComparison\2008\Canada-11-30-08.xls','Changed','Dec 12 2008 10:44AM' UNION ALL

    SELECT '35609','D:\Accounting\BalanceSheetComparison\2008\Canada-11-30-08.xls~RF3ec6a01.TMP///D:\Accounting\BalanceSheetComparison\2008\Canada-1','Renamed','Dec 12 2008 10:44AM' UNION ALL

    SELECT '35613','D:\Accounting\BalanceSheetComparison\2008\Canada-11-30-08.xls','Changed','Dec 12 2008 10:44AM' UNION ALL

    SELECT '35614','D:\Accounting\BalanceSheetComparison\2008\Canada-11-30-08.xls','Changed','Dec 12 2008 10:44AM' UNION ALL

    SELECT '35619','D:\Accounting\BalanceSheetComparison\2008\Canada-11-30-08.xls','Changed','Dec 12 2008 10:44AM' UNION ALL

    SELECT '35632','D:\Accounting\BalanceSheetComparison\2008\Canada-11-30-08.xls','Changed','Dec 12 2008 10:45AM' UNION ALL

    SELECT '35637','D:\Accounting\BalanceSheetComparison\2008\Canada-11-30-08.xls~RF3ed39d4.TMP///D:\Accounting\BalanceSheetComparison\2008\Canada-1','Renamed','Dec 12 2008 10:45AM' UNION ALL

    SELECT '35641','D:\Accounting\BalanceSheetComparison\2008\Canada-11-30-08.xls','Changed','Dec 12 2008 10:46AM' UNION ALL

    SELECT '35642','D:\Accounting\BalanceSheetComparison\2008\Canada-11-30-08.xls','Changed','Dec 12 2008 10:46AM' UNION ALL

    SELECT '35647','D:\Accounting\BalanceSheetComparison\2008\Canada-11-30-08.xls','Changed','Dec 12 2008 10:46AM' UNION ALL

    SELECT '35690','D:\Accounting\BalanceSheetComparison\2008\Canada-11-30-08.xls','Changed','Dec 12 2008 10:47AM' UNION ALL

    SELECT '35695','D:\Accounting\BalanceSheetComparison\2008\Canada-11-30-08.xls~RF3ef3ce7.TMP///D:\Accounting\BalanceSheetComparison\2008\Canada-1','Renamed','Dec 12 2008 10:47AM' UNION ALL

    SELECT '35715','D:\Accounting\BalanceSheetComparison\2008\Canada-11-30-08.xls~RF3ef5fa2.TMP///D:\Accounting\BalanceSheetComparison\2008\Canada-1','Renamed','Dec 12 2008 10:48AM' UNION ALL

    SELECT '35720','D:\Accounting\BalanceSheetComparison\2008\Canada-11-30-08.xls','Changed','Dec 12 2008 10:48AM' UNION ALL

    SELECT '35721','D:\Accounting\BalanceSheetComparison\2008\Canada-11-30-08.xls','Changed','Dec 12 2008 10:48AM' UNION ALL

    SELECT '35726','D:\Accounting\BalanceSheetComparison\2008\Canada-11-30-08.xls','Changed','Dec 12 2008 10:48AM' UNION ALL

    SELECT '35796','D:\Accounting\BalanceSheetComparison\2008\Canada-11-30-08.xls','Changed','Dec 12 2008 10:51AM' UNION ALL

    SELECT '35801','D:\Accounting\BalanceSheetComparison\2008\Canada-11-30-08.xls~RF3f21e06.TMP///D:\Accounting\BalanceSheetComparison\2008\Canada-1','Renamed','Dec 12 2008 10:51AM' UNION ALL

    SELECT '36487','D:\Users\wsun\Xunlei\ENGote.xls','Changed','Dec 12 2008 11:01AM' UNION ALL

    SELECT '36492','D:\Users\wsun\Xunlei\ENGote.xls~RF143f5af7.TMP///D:\Users\wsun\Xunlei\ENGote.xls','Renamed','Dec 12 2008 11:01AM' UNION ALL

    SELECT '36559','D:\Users\wsun\Xunlei\ENGote.xls~RF14445e3a.TMP///D:\Users\wsun\Xunlei\ENGote.xls','Renamed','Dec 12 2008 11:07AM' UNION ALL

    SELECT '36702','D:\Human Resources\401K\~$1K Introductory letter.doc','Created','Dec 12 2008 11:17AM' UNION ALL

    SELECT '36703','D:\Human Resources\401K\~$1K Introductory letter.doc','Changed','Dec 12 2008 11:17AM' UNION ALL

    SELECT '36704','D:\Human Resources\401K\~$1K Introductory letter.doc','Changed','Dec 12 2008 11:17AM' UNION ALL

    SELECT '36705','D:\Human Resources\401K\~$1K Introductory letter.doc','Changed','Dec 12 2008 11:17AM' UNION ALL

    SELECT '36708','D:\Human Resources\401K\~$1K Introductory letter.doc','Deleted','Dec 12 2008 11:18AM' UNION ALL

    SELECT '36722','D:\Manufacturing\INVENTORY CREDIT\1407.DOC','Created','Dec 12 2008 11:21AM' UNION ALL

    SELECT '36736','D:\Human Resources\Trackers - 2008.xls','Changed','Dec 12 2008 11:22AM' UNION ALL

    SELECT '36750','D:\Human Resources\Trackers - 2008.xls','Changed','Dec 12 2008 11:22AM' UNION ALL

    SELECT '36756','D:\Human Resources\Trackers - 2008.xls~RF553cf8c3.TMP///D:\Human Resources\Trackers - 2008.xls','Renamed','Dec 12 2008 11:22AM' UNION ALL

    SELECT '36764','D:\Manufacturing\INVENTORY CREDIT\1411.DOC','Created','Dec 12 2008 11:22AM' UNION ALL

    SELECT '36807','D:\Manufacturing\WDI Mfg. Production 2008\Open WO.xls','Deleted','Dec 12 2008 11:26AM' UNION ALL

    SELECT '36811','D:\Manufacturing\WDI Mfg. Production 2008\Open WO.xls','Created','Dec 12 2008 11:26AM' UNION ALL

    SELECT '36815','D:\Manufacturing\WDI Mfg. Production 2008\Open WO.xls','Deleted','Dec 12 2008 11:26AM' UNION ALL

    SELECT '36819','D:\Manufacturing\WDI Mfg. Production 2008\Open WO.xls','Created','Dec 12 2008 11:26AM' UNION ALL

    SELECT '36886','D:\Manufacturing\QUALITY SYSTEM WDI MANUFACTURING\WDI MANF QUALITY SYSTEM PROCEDURES REV F 06-01-08\SECTION 6000\WDIMQF 6012 RE','Deleted','Dec 12 2008 11:33AM' UNION ALL

    SELECT '36890','D:\Manufacturing\QUALITY SYSTEM WDI MANUFACTURING\WDI MANF QUALITY SYSTEM PROCEDURES REV F 06-01-08\SECTION 6000\WDIMQF 6012 RE','Created','Dec 12 2008 11:33AM' UNION ALL

    SELECT '36923','D:\Warehouse\TOMBALL BACKORDER REPORT\Tomball Backorder Report.xls','Deleted','Dec 12 2008 11:36AM' UNION ALL

    SELECT '36927','D:\Warehouse\TOMBALL BACKORDER REPORT\Tomball Backorder Report.xls','Created','Dec 12 2008 11:36AM' UNION ALL

    SELECT '36931','D:\Manufacturing\WDI Mfg. Production 2008\Open WO.xls','Deleted','Dec 12 2008 11:36AM' UNION ALL

    SELECT '36935','D:\Manufacturing\WDI Mfg. Production 2008\Open WO.xls','Created','Dec 12 2008 11:36AM' UNION ALL

    SELECT '37664','D:\Warehouse\Tomball Warehouse\Cons. Inventory.xls','Deleted','Dec 12 2008 11:46AM' UNION ALL

    SELECT '37668','D:\Warehouse\Tomball Warehouse\Cons. Inventory.xls','Created','Dec 12 2008 11:46AM' UNION ALL

    SELECT '37970','D:\Warehouse\Tomball Warehouse\Cons. Inventory.xls','Deleted','Dec 12 2008 11:50AM' UNION ALL

    SELECT '37974','D:\Warehouse\Tomball Warehouse\Cons. Inventory.xls','Created','Dec 12 2008 11:50AM' UNION ALL

    SELECT '37976','D:\Warehouse\Tomball Warehouse\EAL.xls','Deleted','Dec 12 2008 11:50AM' UNION ALL

    SELECT '37983','D:\Warehouse\Tomball Warehouse\EAL.xls','Created','Dec 12 2008 11:50AM' UNION ALL

    SELECT '37987','D:\Warehouse\Tomball Warehouse\PDL.xls','Deleted','Dec 12 2008 11:50AM' UNION ALL

    SELECT '37991','D:\Warehouse\Tomball Warehouse\PDL.xls','Created','Dec 12 2008 11:50AM' UNION ALL

    SELECT '38015','D:\Users\chan\HR\Offer Letter - Cindy Johnson.doc','Created','Dec 12 2008 12:01PM' UNION ALL

    SELECT '38038','D:\Users\chan\HR\~WRL3168.tmp///D:\Users\chan\HR\Offer Letter - Cindy Johnson.doc','Renamed','Dec 12 2008 12:01PM' UNION ALL

    SELECT '38040','D:\Users\chan\HR\~$fer Letter - Cindy Johnson.doc','Created','Dec 12 2008 12:01PM' UNION ALL

    SELECT '38041','D:\Users\chan\HR\~$fer Letter - Cindy Johnson.doc','Changed','Dec 12 2008 12:01PM' UNION ALL

    SELECT '38042','D:\Users\chan\HR\~$fer Letter - Cindy Johnson.doc','Changed','Dec 12 2008 12:01PM' UNION ALL

    SELECT '38043','D:\Users\chan\HR\~$fer Letter - Cindy Johnson.doc','Changed','Dec 12 2008 12:01PM' UNION ALL

    SELECT '38048','D:\Users\chan\HR\~$fer Letter - Cindy Johnson.doc','Deleted','Dec 12 2008 12:01PM' UNION ALL

    SELECT '38333','D:\Manufacturing\WDI Mfg. Production 2008\Open WO.xls','Deleted','Dec 12 2008 1:24PM' UNION ALL

    SELECT '38337','D:\Manufacturing\WDI Mfg. Production 2008\Open WO.xls','Created','Dec 12 2008 1:24PM' UNION ALL

    SELECT '38341','D:\Manufacturing\WDI Mfg. Production 2008\Open WO.xls','Deleted','Dec 12 2008 1:24PM' UNION ALL

    SELECT '38345','D:\Manufacturing\WDI Mfg. Production 2008\Open WO.xls','Created','Dec 12 2008 1:24PM' UNION ALL

    SELECT '38515','D:\Users\mcole\WDI COLLECTIONS\report 11-24.xls','Changed','Dec 12 2008 1:31PM' UNION ALL

    SELECT '38516','D:\Users\mcole\WDI COLLECTIONS\report 11-24.xls','Changed','Dec 12 2008 1:31PM' UNION ALL

    SELECT '38518','D:\Users\mcole\WDI COLLECTIONS\report 11-24.xls','Changed','Dec 12 2008 1:31PM' UNION ALL

    SELECT '38550','D:\QuickBooks\COLLECTION\Weatherford\WEATHERFORD ACCOUNT STATUS.xls','Changed','Dec 12 2008 1:36PM' UNION ALL

    SELECT '38551','D:\QuickBooks\COLLECTION\Weatherford\WEATHERFORD ACCOUNT STATUS.xls','Changed','Dec 12 2008 1:36PM' UNION ALL

    SELECT '38552','D:\QuickBooks\COLLECTION\Statements\12-8-08 -JENNY.xls','Changed','Dec 12 2008 1:37PM' UNION ALL

    SELECT '38553','D:\QuickBooks\COLLECTION\Statements\12-8-08 -JENNY.xls','Changed','Dec 12 2008 1:37PM' UNION ALL

    SELECT '38554','D:\QuickBooks\COLLECTION\Statements\12-8-08 -JENNY.xls','Changed','Dec 12 2008 1:38PM' UNION ALL

    SELECT '38560','D:\Users\eburnett\aaquality wdi rev102606\aaawdi manufacturing qms\SECTION 5 MANF\WDIMAN 5000.4.2 LETTER OF COMMENT.doc','Deleted','Dec 12 2008 1:39PM' UNION ALL

    SELECT '38564','D:\Users\eburnett\aaquality wdi rev102606\aaawdi manufacturing qms\SECTION 5 MANF\WDIMAN 5000.4.2 LETTER OF COMMENT.doc','Created','Dec 12 2008 1:39PM' UNION ALL

    SELECT '38690','D:\Users\eburnett\aaquality wdi rev102606\aaawdi manufacturing qms\QM WDI MANF REV C\qp WDI Manufacturing.doc','Deleted','Dec 12 2008 1:45PM' UNION ALL

    SELECT '38694','D:\Users\eburnett\aaquality wdi rev102606\aaawdi manufacturing qms\QM WDI MANF REV C\qp WDI Manufacturing.doc','Created','Dec 12 2008 1:45PM' UNION ALL

    SELECT '38695','D:\Human Resources\Personnel\Offer Letters\~$fer Letter - Cindy Johnson.doc','Created','Dec 12 2008 1:48PM' UNION ALL

    SELECT '38696','D:\Human Resources\Personnel\Offer Letters\~$fer Letter - Cindy Johnson.doc','Changed','Dec 12 2008 1:48PM' UNION ALL

    SELECT '38697','D:\Human Resources\Personnel\Offer Letters\~$fer Letter - Cindy Johnson.doc','Changed','Dec 12 2008 1:48PM' UNION ALL

    SELECT '38698','D:\Human Resources\Personnel\Offer Letters\~$fer Letter - Cindy Johnson.doc','Changed','Dec 12 2008 1:48PM' UNION ALL

    SELECT '38703','D:\Users\eburnett\aaquality wdi rev102606\aaawdi manufacturing qms\QM WDI MANF REV C\II OF IV WDIMQMINDEX Manf rev c 060108.DOC','Deleted','Dec 12 2008 1:49PM' UNION ALL

    SELECT '38707','D:\Users\eburnett\aaquality wdi rev102606\aaawdi manufacturing qms\QM WDI MANF REV C\II OF IV WDIMQMINDEX Manf rev c 060108.DOC','Created','Dec 12 2008 1:49PM' UNION ALL

    SELECT '38714','D:\Users\eburnett\aaquality wdi rev102606\aaawdi manufacturing qms\QM WDI MANF REV C\III OF IV WDI MANAGEMENT POLICY STATEMENT R','Deleted','Dec 12 2008 1:50PM' UNION ALL

    SELECT '38718','D:\Users\eburnett\aaquality wdi rev102606\aaawdi manufacturing qms\QM WDI MANF REV C\III OF IV WDI MANAGEMENT POLICY STATEMENT R','Created','Dec 12 2008 1:50PM' UNION ALL

    SELECT '38720','D:\Users\eburnett\aaquality wdi rev102606\aaawdi manufacturing qms\REVISIONS\WORKING\WDIMQF 5000.1.3 attach Organizational Char','Created','Dec 12 2008 1:52PM' UNION ALL

    SELECT '38812','D:\Human Resources\Personnel\Offer Letters\~WRL1188.tmp///D:\Human Resources\Personnel\Offer Letters\Offer Letter - Cindy Johnso','Renamed','Dec 12 2008 1:57PM' UNION ALL

    SELECT '38817','D:\Human Resources\Personnel\Offer Letters\~$fer Letter - Jamie Bednar.doc','Created','Dec 12 2008 1:57PM' UNION ALL

    SELECT '38818','D:\Human Resources\Personnel\Offer Letters\~$fer Letter - Jamie Bednar.doc','Changed','Dec 12 2008 1:57PM' UNION ALL

    SELECT '38819','D:\Human Resources\Personnel\Offer Letters\~$fer Letter - Jamie Bednar.doc','Changed','Dec 12 2008 1:57PM' UNION ALL

    SELECT '38820','D:\Human Resources\Personnel\Offer Letters\~$fer Letter - Jamie Bednar.doc','Changed','Dec 12 2008 1:57PM' UNION ALL

    SELECT '38843','D:\Human Resources\Personnel\Offer Letters\~WRL1268.tmp///D:\Human Resources\Personnel\Offer Letters\Offer Letter - Jamie Bednar','Renamed','Dec 12 2008 1:58PM' UNION ALL

    SELECT '38848','D:\Human Resources\Personnel\Offer Letters\~$fer Letter - Jamie Bednar.doc','Deleted','Dec 12 2008 1:58PM' UNION ALL

    SELECT '38850','D:\Human Resources\Personnel\Offer Letters\~$fer Letter - Cindy Johnson.doc','Deleted','Dec 12 2008 1:58PM' UNION ALL

    SELECT '39079','D:\Manufacturing\QUALITY SYSTEM WDI MANUFACTURING\WDI MANF QUALITY SYSTEM PROCEDURES REV F 06-01-08\SECTION 6000\WDIMQF 6014 RE','Deleted','Dec 12 2008 2:08PM' UNION ALL

    SELECT '39083','D:\Manufacturing\QUALITY SYSTEM WDI MANUFACTURING\WDI MANF QUALITY SYSTEM PROCEDURES REV F 06-01-08\SECTION 6000\WDIMQF 6014 RE','Created','Dec 12 2008 2:08PM' UNION ALL

    SELECT '39087','D:\Users\wsun\Inventory\2008\11-30-08 Inventory Summary.xls','Created','Dec 12 2008 2:12PM' UNION ALL

    SELECT '39088','D:\Users\wsun\Inventory\2008\11-30-08 Inventory Summary.xls','Deleted','Dec 12 2008 2:12PM' UNION ALL

    SELECT '39153','D:\Users\mcole\WDI COLLECTIONS\report 11-24.xls','Changed','Dec 12 2008 2:16PM' UNION ALL

    SELECT '39158','D:\Users\mcole\WDI COLLECTIONS\report 11-24.xls~RF33a86484.TMP///D:\Users\mcole\WDI COLLECTIONS\report 11-24.xls','Renamed','Dec 12 2008 2:16PM' UNION ALL

    SELECT '39164','D:\Users\eburnett\aaquality wdi rev102606\aaawdi manufacturing qms\REVISIONS\WORKING\WDIMQF 5000.1.3 attach Organizational Char','Deleted','Dec 12 2008 2:16PM' UNION ALL

    SELECT '39168','D:\Users\eburnett\aaquality wdi rev102606\aaawdi manufacturing qms\REVISIONS\WORKING\WDIMQF 5000.1.3 attach Organizational Char','Created','Dec 12 2008 2:16PM' UNION ALL

    SELECT '39225','D:\Users\wsun\Inventory\2008\11-30-08 Inventory Summary.xls~RF14f2498b.TMP///D:\Users\wsun\Inventory\2008\11-30-08 Inventory Sum','Renamed','Dec 12 2008 2:17PM' UNION ALL

    SELECT '39230','D:\Users\eburnett\aaquality wdi rev102606\aaawdi manufacturing qms\REVISIONS\WORKING\WDIMQF 5000.1.3 attach Organizational Char','Deleted','Dec 12 2008 2:18PM' UNION ALL

    SELECT '39234','D:\Users\eburnett\aaquality wdi rev102606\aaawdi manufacturing qms\REVISIONS\WORKING\WDIMQF 5000.1.3 attach Organizational Char','Created','Dec 12 2008 2:18PM' UNION ALL

    SELECT '39243','D:\Human Resources\Personnel\Employee list 2.xls','Changed','Dec 12 2008 2:19PM' UNION ALL

    SELECT '39244','D:\Users\eburnett\aaquality wdi rev102606\aaawdi manufacturing qms\REVISIONS\WORKING\WDIMQF 5000.1.3 attach Organizational Char','Renamed','Dec 12 2008 2:19PM' UNION ALL

    SELECT '39246','D:\Human Resources\Personnel\Employee list 2.xls','Changed','Dec 12 2008 2:20PM' UNION ALL

    SELECT '39249','D:\Users\eburnett\aaquality wdi rev102606\aaawdi manufacturing qms\REVISIONS\WORKING\WDIMQF 5000.1.3 attach Organizational Char','Renamed','Dec 12 2008 2:20PM' UNION ALL

    SELECT '39251','D:\Users\eburnett\aaquality wdi rev102606\aaawdi manufacturing qms\REVISIONS\WORKING\WDIMQF 5000.1.3 attach Organizational Char','Deleted','Dec 12 2008 2:20PM' UNION ALL

    SELECT '39252','D:\Users\eburnett\aaquality wdi rev102606\aaawdi manufacturing qms\REVISIONS\COMPLETE READY\WDIMQF 5000.1.3 attach Organization','Created','Dec 12 2008 2:20PM' UNION ALL

    SELECT '39278','D:\Users\wsun\Inventory\2008\11-30-08 Inventory Summary.xls~RF14f77083.TMP///D:\Users\wsun\Inventory\2008\11-30-08 Inventory Sum','Renamed','Dec 12 2008 2:23PM' UNION ALL

    SELECT '39283','D:\Human Resources\Payroll\salaried employees 9-1.xls','Changed','Dec 12 2008 2:23PM' UNION ALL

    SELECT '39284','D:\Human Resources\Payroll\salaried employees 9-1.xls','Changed','Dec 12 2008 2:23PM' UNION ALL

    SELECT '39287','D:\Users\eburnett\aaquality wdi rev102606\aaawdi manufacturing qms\REVISIONS\COMPLETE READY\WDIMQF 5000.1.3 attach Organization','Deleted','Dec 12 2008 2:24PM' UNION ALL

    SELECT '39291','D:\Users\eburnett\aaquality wdi rev102606\aaawdi manufacturing qms\REVISIONS\COMPLETE READY\WDIMQF 5000.1.3 attach Organization','Created','Dec 12 2008 2:24PM' UNION ALL

    SELECT '39296','D:\Manufacturing\WDI Mfg. Production 2008\Open WO.xls','Deleted','Dec 12 2008 2:25PM' UNION ALL

    SELECT '39300','D:\Manufacturing\WDI Mfg. Production 2008\Open WO.xls','Created','Dec 12 2008 2:25PM' UNION ALL

    SELECT '39360','D:\Warehouse\Tomball Warehouse\Cons. Inventory.xls','Deleted','Dec 12 2008 2:34PM' UNION ALL

    SELECT '39364','D:\Warehouse\Tomball Warehouse\Cons. Inventory.xls','Created','Dec 12 2008 2:34PM' UNION ALL

    SELECT '39444','D:\Users\wsun\Inventory\2008\10-31-08 Inventory Summary.xls','Changed','Dec 12 2008 2:38PM' UNION ALL

    SELECT '39472','D:\Users\wsun\Inventory\2008\10-31-08 Inventory Summary.xls','Changed','Dec 12 2008 2:44PM' UNION ALL

    SELECT '39474','D:\Users\wsun\Inventory\2008\10-31-08 Inventory Report.xls','Changed','Dec 12 2008 2:44PM' UNION ALL

    SELECT '39489','D:\Users\wsun\Inventory\2008\10-31-08 Inventory Report.xls','Changed','Dec 12 2008 2:45PM' UNION ALL

    SELECT '39494','D:\Users\wsun\Inventory\2008\10-31-08 Inventory Report.xls~RF150c2b85.TMP///D:\Users\wsun\Inventory\2008\10-31-08 Inventory Repo','Renamed','Dec 12 2008 2:45PM' UNION ALL

    SELECT '39516','D:\Users\wsun\Inventory\2008\11-30-08 Inventory Summary.xls~RF150c3af6.TMP///D:\Users\wsun\Inventory\2008\11-30-08 Inventory Sum','Renamed','Dec 12 2008 2:45PM' UNION ALL

    SELECT '40631','D:\Users\wsun\Inventory\2008\11-30-08 Inventory Summary.xls~RF15134499.TMP///D:\Users\wsun\Inventory\2008\11-30-08 Inventory Sum','Renamed','Dec 12 2008 2:53PM' UNION ALL

    SELECT '40637','D:\Users\wsun\Inventory\2008\11-30-08 Inventory Report.xls','Created','Dec 12 2008 2:53PM' UNION ALL

    SELECT '40638','D:\Users\wsun\Inventory\2008\11-30-08 Inventory Report.xls','Deleted','Dec 12 2008 2:53PM' UNION ALL

    SELECT '40672','D:\Warehouse\Tomball Warehouse\Cons. Inventory.xls','Deleted','Dec 12 2008 2:56PM' UNION ALL

    SELECT '40676','D:\Warehouse\Tomball Warehouse\Cons. Inventory.xls','Created','Dec 12 2008 2:56PM' UNION ALL

    SELECT '40725','D:\MTR\11-15-2008\08-11-15_WDI--LIST1\~$-15120.doc','Created','Dec 12 2008 3:03PM' UNION ALL

    SELECT '40726','D:\MTR\11-15-2008\08-11-15_WDI--LIST1\~$-15120.doc','Changed','Dec 12 2008 3:03PM' UNION ALL

    SELECT '40753','D:\Manufacturing\WDI Mfg. Production 2008\Open WO.xls','Deleted','Dec 12 2008 3:05PM' UNION ALL

    SELECT '40757','D:\Manufacturing\WDI Mfg. Production 2008\Open WO.xls','Created','Dec 12 2008 3:05PM' UNION ALL

    SELECT '40771','D:\Human Resources\Insurance Forms\~$tice to Remove Dependent.doc','Created','Dec 12 2008 3:10PM' UNION ALL

    SELECT '40772','D:\Human Resources\Insurance Forms\~$tice to Remove Dependent.doc','Changed','Dec 12 2008 3:10PM' UNION ALL

    SELECT '40773','D:\Human Resources\Insurance Forms\~$tice to Remove Dependent.doc','Changed','Dec 12 2008 3:10PM' UNION ALL

    SELECT '40774','D:\Human Resources\Insurance Forms\~$tice to Remove Dependent.doc','Changed','Dec 12 2008 3:10PM' UNION ALL

    SELECT '40797','D:\Human Resources\Insurance Forms\~WRL2531.tmp///D:\Human Resources\Insurance Forms\Notice to Remove Dependent.doc','Renamed','Dec 12 2008 3:10PM' UNION ALL

    SELECT '40802','D:\Human Resources\Insurance Forms\~$tice to Remove Dependent.doc','Deleted','Dec 12 2008 3:10PM' UNION ALL

    SELECT '40807','D:\Human Resources\Insurance Forms\~$tice to Remove Dependent.doc','Created','Dec 12 2008 3:11PM' UNION ALL

    SELECT '40808','D:\Human Resources\Insurance Forms\~$tice to Remove Dependent.doc','Changed','Dec 12 2008 3:11PM' UNION ALL

    SELECT '40809','D:\Human Resources\Insurance Forms\~$tice to Remove Dependent.doc','Changed','Dec 12 2008 3:11PM' UNION ALL

    SELECT '40810','D:\Human Resources\Insurance Forms\~$tice to Remove Dependent.doc','Changed','Dec 12 2008 3:11PM' UNION ALL

    SELECT '40839','D:\Human Resources\Insurance Forms\~WRL2941.tmp///D:\Human Resources\Insurance Forms\Notice to Remove Dependent.doc','Renamed','Dec 12 2008 3:11PM' UNION ALL

    SELECT '40845','D:\Human Resources\Insurance Forms\~$tice to Remove Dependent.doc','Deleted','Dec 12 2008 3:11PM' UNION ALL

    SELECT '40913','D:\MTR\11-15-2008\08-11-15_WDI--LIST1\~$-28253.doc','Created','Dec 12 2008 3:13PM' UNION ALL

    SELECT '40914','D:\MTR\11-15-2008\08-11-15_WDI--LIST1\~$-28253.doc','Changed','Dec 12 2008 3:13PM' UNION ALL

    SELECT '40916','D:\MTR\11-15-2008\08-11-15_WDI--LIST1\~$-CA009.doc','Created','Dec 12 2008 3:13PM' UNION ALL

    SELECT '40917','D:\MTR\11-15-2008\08-11-15_WDI--LIST1\~$-CA009.doc','Changed','Dec 12 2008 3:13PM' UNION ALL

    SELECT '40919','D:\MTR\11-15-2008\08-11-15_WDI--LIST1\~$-10500.doc','Created','Dec 12 2008 3:13PM' UNION ALL

    SELECT '40920','D:\MTR\11-15-2008\08-11-15_WDI--LIST1\~$-10500.doc','Changed','Dec 12 2008 3:13PM' UNION ALL

    SELECT '40923','D:\MTR\11-15-2008\08-11-15_WDI--LIST1\~$-43336.doc','Created','Dec 12 2008 3:13PM' UNION ALL

    SELECT '40924','D:\MTR\11-15-2008\08-11-15_WDI--LIST1\~$-43336.doc','Changed','Dec 12 2008 3:13PM' UNION ALL

    SELECT '40927','D:\MTR\11-15-2008\08-11-15_WDI--LIST1\~$-43338.doc','Created','Dec 12 2008 3:13PM' UNION ALL

    SELECT '40928','D:\MTR\11-15-2008\08-11-15_WDI--LIST1\~$-43338.doc','Changed','Dec 12 2008 3:13PM' UNION ALL

    SELECT '40932','D:\MTR\11-15-2008\08-11-15_WDI--LIST1\~$-89012.doc','Created','Dec 12 2008 3:13PM' UNION ALL

    SELECT '40933','D:\MTR\11-15-2008\08-11-15_WDI--LIST1\~$-89012.doc','Changed','Dec 12 2008 3:13PM' UNION ALL

    SELECT '40936','D:\MTR\11-15-2008\08-11-15_WDI--LIST1\~$-89375.doc','Created','Dec 12 2008 3:14PM' UNION ALL

    SELECT '40937','D:\MTR\11-15-2008\08-11-15_WDI--LIST1\~$-89375.doc','Changed','Dec 12 2008 3:14PM' UNION ALL

    SELECT '40939','D:\MTR\11-15-2008\08-11-15_WDI--LIST1\~$-93012.doc','Created','Dec 12 2008 3:14PM' UNION ALL

    SELECT '40940','D:\MTR\11-15-2008\08-11-15_WDI--LIST1\~$-93012.doc','Changed','Dec 12 2008 3:14PM' UNION ALL

    SELECT '40942','D:\MTR\11-15-2008\08-11-15_WDI--LIST1\~$-23989A.doc','Created','Dec 12 2008 3:14PM' UNION ALL

    SELECT '40943','D:\MTR\11-15-2008\08-11-15_WDI--LIST1\~$-23989A.doc','Changed','Dec 12 2008 3:14PM' UNION ALL

    SELECT '40945','D:\MTR\11-15-2008\08-11-15_WDI--LIST1\~$-36483A.doc','Created','Dec 12 2008 3:14PM' UNION ALL

    SELECT '40946','D:\MTR\11-15-2008\08-11-15_WDI--LIST1\~$-36483A.doc','Changed','Dec 12 2008 3:14PM' UNION ALL

    SELECT '40958','D:\MTR\11-15-2008\08-11-15_WDI--LIST1\~$-88396A.doc','Created','Dec 12 2008 3:14PM' UNION ALL

    SELECT '40959','D:\MTR\11-15-2008\08-11-15_WDI--LIST1\~$-88396A.doc','Changed','Dec 12 2008 3:14PM' UNION ALL

    SELECT '40982','D:\Users\lmentzer\2008 Xmas list.xls','Created','Dec 12 2008 3:20PM' UNION ALL

    SELECT '41008','D:\MTR\11-15-2008\08-11-15_WDI--LIST1\~$-00001.doc','Created','Dec 12 2008 3:24PM' UNION ALL

    SELECT '41009','D:\MTR\11-15-2008\08-11-15_WDI--LIST1\~$-00001.doc','Changed','Dec 12 2008 3:24PM' UNION ALL

    SELECT '41090','D:\QuickBooks\Inventory\Inventory Control December 08.xls~RF1531b1d8.TMP///D:\QuickBooks\Inventory\Inventory Control December 08','Renamed','Dec 12 2008 3:26PM' UNION ALL

    SELECT '41113','D:\Users\mcole\WDI COLLECTIONS\report 11-24.xls~RF33ee51e2.TMP///D:\Users\mcole\WDI COLLECTIONS\report 11-24.xls','Renamed','Dec 12 2008 3:33PM' UNION ALL

    SELECT '41122','D:\MTR\11-15-2008\08-11-15_WDI--LIST1\~$-08260.doc','Created','Dec 12 2008 3:35PM' UNION ALL

    SELECT '41123','D:\MTR\11-15-2008\08-11-15_WDI--LIST1\~$-08260.doc','Changed','Dec 12 2008 3:35PM' UNION ALL

    SELECT '41125','D:\MTR\11-15-2008\08-11-15_WDI--LIST1\~$-09773.doc','Created','Dec 12 2008 3:35PM' UNION ALL

    SELECT '41126','D:\MTR\11-15-2008\08-11-15_WDI--LIST1\~$-09773.doc','Changed','Dec 12 2008 3:35PM' UNION ALL

    SELECT '41128','D:\MTR\11-15-2008\08-11-15_WDI--LIST1\~$-09776.doc','Created','Dec 12 2008 3:35PM' UNION ALL

    SELECT '41129','D:\MTR\11-15-2008\08-11-15_WDI--LIST1\~$-09776.doc','Changed','Dec 12 2008 3:35PM' UNION ALL

    SELECT '41135','D:\Users\mburkhalter\Marisa\time.xls','Changed','Dec 12 2008 3:38PM' UNION ALL

    SELECT '41137','D:\Accounting\BalanceSheetComparison\2008\WDI-11-30-08.xls','Changed','Dec 12 2008 3:39PM' UNION ALL

    SELECT '41150','D:\Accounting\BalanceSheetComparison\2008\WDI-11-30-08.xls','Changed','Dec 12 2008 3:40PM' UNION ALL

    SELECT '41155','D:\Accounting\BalanceSheetComparison\2008\WDI-11-30-08.xls~RF4fb0843.TMP///D:\Accounting\BalanceSheetComparison\2008\WDI-11-30-0','Renamed','Dec 12 2008 3:40PM' UNION ALL

    SELECT '41271','D:\MTR\11-15-2008\08-11-15_WDI--LIST1\~$-43829.doc','Created','Dec 12 2008 3:45PM' UNION ALL

    SELECT '41272','D:\MTR\11-15-2008\08-11-15_WDI--LIST1\~$-43829.doc','Changed','Dec 12 2008 3:45PM' UNION ALL

    SELECT '41274','D:\MTR\11-15-2008\08-11-15_WDI--LIST1\~$-46051.doc','Created','Dec 12 2008 3:45PM' UNION ALL

    SELECT '41275','D:\MTR\11-15-2008\08-11-15_WDI--LIST1\~$-46051.doc','Changed','Dec 12 2008 3:45PM' UNION ALL

    SELECT '41305','D:\Users\mburkhalter\Marisa\time.xls','Changed','Dec 12 2008 3:48PM' UNION ALL

    SELECT '41310','D:\Users\mburkhalter\Marisa\time.xls~RF502bf2d.TMP///D:\Users\mburkhalter\Marisa\time.xls','Renamed','Dec 12 2008 3:48PM' UNION ALL

    SELECT '41385','D:\Accounting\BalanceSheetComparison\2008\WDI-11-30-08.xls~RF5044253.TMP///D:\Accounting\BalanceSheetComparison\2008\WDI-11-30-0','Renamed','Dec 12 2008 3:50PM' UNION ALL

    SELECT '41407','D:\Accounting\BalanceSheetComparison\2008\WDI-11-30-08.xls~RF504f69f.TMP///D:\Accounting\BalanceSheetComparison\2008\WDI-11-30-0','Renamed','Dec 12 2008 3:51PM' UNION ALL

    SELECT '41426','D:\Accounting\BalanceSheetComparison\2008\WDI-11-30-08.xls~RF5051293.TMP///D:\Accounting\BalanceSheetComparison\2008\WDI-11-30-0','Renamed','Dec 12 2008 3:51PM' UNION ALL

    SELECT '41467','D:\Accounting\BalanceSheetComparison\2008\WDI-11-30-08.xls~RF50689b2.TMP///D:\Accounting\BalanceSheetComparison\2008\WDI-11-30-0','Renamed','Dec 12 2008 3:52PM' UNION ALL

    SELECT '41584','D:\Accounting\BalanceSheetComparison\2008\WDI-11-30-08.xls~RF507c772.TMP///D:\Accounting\BalanceSheetComparison\2008\WDI-11-30-0','Renamed','Dec 12 2008 3:54PM' UNION ALL

    SELECT '41630','D:\Accounting\BalanceSheetComparison\2008\WDI-10-31-08.xls','Changed','Dec 12 2008 3:54PM' UNION ALL

    SELECT '41631','D:\Accounting\BalanceSheetComparison\2008\WDI-10-31-08.xls','Changed','Dec 12 2008 3:54PM' UNION ALL

    SELECT '41642','D:\Accounting\BalanceSheetComparison\2008\WDI-11-30-08.xls','Changed','Dec 12 2008 3:54PM' UNION ALL

    SELECT '41643','D:\Accounting\BalanceSheetComparison\2008\WDI-11-30-08.xls','Changed','Dec 12 2008 3:54PM' UNION ALL

    SELECT '41644','D:\Accounting\BalanceSheetComparison\2008\WDI-11-30-08.xls','Changed','Dec 12 2008 3:54PM' UNION ALL

    SELECT '41661','D:\Accounting\BalanceSheetComparison\2008\WDI-11-30-08.xls','Changed','Dec 12 2008 3:55PM' UNION ALL

    SELECT '41666','D:\Accounting\BalanceSheetComparison\2008\WDI-11-30-08.xls~RF508ef58.TMP///D:\Accounting\BalanceSheetComparison\2008\WDI-11-30-0','Renamed','Dec 12 2008 3:55PM' UNION ALL

    SELECT '41688','D:\Accounting\BalanceSheetComparison\2008\WDI-11-30-08.xls~RF5097ea8.TMP///D:\Accounting\BalanceSheetComparison\2008\WDI-11-30-0','Renamed','Dec 12 2008 3:56PM' UNION ALL

    SELECT '41691','D:\MTR\11-15-2008\08-11-15_WDI--LIST1\~$-A5P22.doc','Created','Dec 12 2008 3:56PM' UNION ALL

    SELECT '41692','D:\MTR\11-15-2008\08-11-15_WDI--LIST1\~$-A5P22.doc','Changed','Dec 12 2008 3:56PM' UNION ALL

    SELECT '41765','D:\Accounting\BalanceSheetComparison\2008\WDI-11-30-08.xls~RF50cdab4.TMP///D:\Accounting\BalanceSheetComparison\2008\WDI-11-30-0','Renamed','Dec 12 2008 3:59PM' UNION ALL

    SELECT '41786','D:\Accounting\BalanceSheetComparison\2008\WDI-11-30-08.xls~RF50d5080.TMP///D:\Accounting\BalanceSheetComparison\2008\WDI-11-30-0','Renamed','Dec 12 2008 4:00PM' UNION ALL

    SELECT '41825','D:\Accounting\BalanceSheetComparison\2008\WDI-11-30-08.xls~RF50ed7db.TMP///D:\Accounting\BalanceSheetComparison\2008\WDI-11-30-0','Renamed','Dec 12 2008 4:01PM' UNION ALL

    SELECT '41844','D:\Accounting\BalanceSheetComparison\2008\WDI-11-30-08.xls~RF50f5d09.TMP///D:\Accounting\BalanceSheetComparison\2008\WDI-11-30-0','Renamed','Dec 12 2008 4:02PM' UNION ALL

    SELECT '41864','D:\Accounting\BalanceSheetComparison\2008\WDI-11-30-08.xls~RF510753f.TMP///D:\Accounting\BalanceSheetComparison\2008\WDI-11-30-0','Renamed','Dec 12 2008 4:03PM' UNION ALL

    SELECT '41884','D:\Accounting\BalanceSheetComparison\2008\WDI-11-30-08.xls~RF5113091.TMP///D:\Accounting\BalanceSheetComparison\2008\WDI-11-30-0','Renamed','Dec 12 2008 4:04PM' UNION ALL

    SELECT '41909','D:\Accounting\BalanceSheetComparison\2008\WDI-11-30-08.xls~RF511dc22.TMP///D:\Accounting\BalanceSheetComparison\2008\WDI-11-30-0','Renamed','Dec 12 2008 4:05PM' UNION ALL

    SELECT '41928','D:\Accounting\BalanceSheetComparison\2008\WDI-11-30-08.xls~RF512644e.TMP///D:\Accounting\BalanceSheetComparison\2008\WDI-11-30-0','Renamed','Dec 12 2008 4:05PM' UNION ALL

    SELECT '41936','D:\MTR\11-15-2008\08-11-15_WDI--LIST1\~$-10200.doc','Created','Dec 12 2008 4:06PM' UNION ALL

    SELECT '41937','D:\MTR\11-15-2008\08-11-15_WDI--LIST1\~$-10200.doc','Changed','Dec 12 2008 4:06PM' UNION ALL

    SELECT '41939','D:\MTR\11-15-2008\08-11-15_WDI--LIST1\~$-10250.doc','Created','Dec 12 2008 4:06PM' UNION ALL

    SELECT '41940','D:\MTR\11-15-2008\08-11-15_WDI--LIST1\~$-10250.doc','Changed','Dec 12 2008 4:06PM' UNION ALL

    SELECT '41942','D:\MTR\11-15-2008\08-11-15_WDI--LIST1\~$-12700-01.doc','Created','Dec 12 2008 4:06PM' UNION ALL

    SELECT '41943','D:\MTR\11-15-2008\08-11-15_WDI--LIST1\~$-12700-01.doc','Changed','Dec 12 2008 4:06PM' UNION ALL

    SELECT '41945','D:\MTR\11-15-2008\08-11-15_WDI--LIST1\~$-12700-02.doc','Created','Dec 12 2008 4:06PM' UNION ALL

    SELECT '41946','D:\MTR\11-15-2008\08-11-15_WDI--LIST1\~$-12700-02.doc','Changed','Dec 12 2008 4:06PM' UNION ALL

    SELECT '41948','D:\MTR\11-15-2008\08-11-15_WDI--LIST1\~$-22270-01.doc','Created','Dec 12 2008 4:07PM' UNION ALL

    SELECT '41949','D:\MTR\11-15-2008\08-11-15_WDI--LIST1\~$-22270-01.doc','Changed','Dec 12 2008 4:07PM' UNION ALL

    SELECT '41952','D:\Accounting\BalanceSheetComparison\2008\WDI-11-30-08.xls','Changed','Dec 12 2008 4:07PM' UNION ALL

    SELECT '41953','D:\Accounting\BalanceSheetComparison\2008\WDI-11-30-08.xls','Changed','Dec 12 2008 4:07PM' UNION ALL

    SELECT '41954','D:\Accounting\BalanceSheetComparison\2008\WDI-11-30-08.xls','Changed','Dec 12 2008 4:07PM' UNION ALL

    SELECT '41967','D:\Accounting\BalanceSheetComparison\2008\WDI-11-30-08.xls','Changed','Dec 12 2008 4:07PM' UNION ALL

    SELECT '41972','D:\Accounting\BalanceSheetComparison\2008\WDI-11-30-08.xls~RF5144b8c.TMP///D:\Accounting\BalanceSheetComparison\2008\WDI-11-30-0','Renamed','Dec 12 2008 4:07PM' UNION ALL

    SELECT '41976','D:\Accounting\BalanceSheetComparison\2008\WDI-11-30-08.xls','Changed','Dec 12 2008 4:08PM' UNION ALL

    SELECT '41977','D:\Accounting\BalanceSheetComparison\2008\WDI-11-30-08.xls','Changed','Dec 12 2008 4:08PM' UNION ALL

    SELECT '41978','D:\Accounting\BalanceSheetComparison\2008\WDI-11-30-08.xls','Changed','Dec 12 2008 4:08PM' UNION ALL

    SELECT '41991','D:\Accounting\BalanceSheetComparison\2008\WDI-11-30-08.xls','Changed','Dec 12 2008 4:08PM' UNION ALL

    SELECT '41996','D:\Accounting\BalanceSheetComparison\2008\WDI-11-30-08.xls~RF5154a8d.TMP///D:\Accounting\BalanceSheetComparison\2008\WDI-11-30-0','Renamed','Dec 12 2008 4:08PM' UNION ALL

    SELECT '42000','D:\Accounting\BalanceSheetComparison\2008\WDI-11-30-08.xls','Changed','Dec 12 2008 4:09PM' UNION ALL

    SELECT '42001','D:\Accounting\BalanceSheetComparison\2008\WDI-11-30-08.xls','Changed','Dec 12 2008 4:09PM' UNION ALL

    SELECT '42002','D:\Accounting\BalanceSheetComparison\2008\WDI-11-30-08.xls','Changed','Dec 12 2008 4:09PM' UNION ALL

    SELECT '42015','D:\Accounting\BalanceSheetComparison\2008\WDI-11-30-08.xls','Changed','Dec 12 2008 4:09PM' UNION ALL

    SELECT '42020','D:\Accounting\BalanceSheetComparison\2008\WDI-11-30-08.xls~RF5161c45.TMP///D:\Accounting\BalanceSheetComparison\2008\WDI-11-30-0','Renamed','Dec 12 2008 4:09PM' UNION ALL

    SELECT '42024','D:\Accounting\BalanceSheetComparison\2008\WDI-11-30-08.xls','Changed','Dec 12 2008 4:10PM' UNION ALL

    SELECT '42025','D:\Accounting\BalanceSheetComparison\2008\WDI-11-30-08.xls','Changed','Dec 12 2008 4:10PM' UNION ALL

    SELECT '42029','D:\Accounting\BalanceSheetComparison\2008\WDI-11-30-08.xls','Changed','Dec 12 2008 4:10PM' UNION ALL

    SELECT '42030','D:\Accounting\BalanceSheetComparison\2008\WDI-11-30-08.xls','Changed','Dec 12 2008 4:10PM' UNION ALL

    SELECT '42031','D:\Accounting\BalanceSheetComparison\2008\WDI-11-30-08.xls','Changed','Dec 12 2008 4:10PM' UNION ALL

    SELECT '42045','D:\Accounting\BalanceSheetComparison\2008\WDI-11-30-08.xls','Changed','Dec 12 2008 4:11PM' UNION ALL

    SELECT '42050','D:\Accounting\BalanceSheetComparison\2008\WDI-11-30-08.xls~RF517a352.TMP///D:\Accounting\BalanceSheetComparison\2008\WDI-11-30-0','Renamed','Dec 12 2008 4:11PM' UNION ALL

    SELECT '42053','D:\Human Resources\Trackers - 2008.xls','Changed','Dec 12 2008 4:14PM' UNION ALL

    SELECT '42059','D:\Accounting\Comerica BBC\BBR 11-30-08\11-30-08 Inventory Report.xls','Created','Dec 12 2008 4:16PM' UNION ALL

    SELECT '42060','D:\Accounting\Comerica BBC\BBR 11-30-08\11-30-08 Inventory Report.xls','Deleted','Dec 12 2008 4:16PM' UNION ALL

    SELECT '42092','D:\Human Resources\Trackers - 2008.xls','Changed','Dec 12 2008 4:16PM' UNION ALL

    SELECT '42098','D:\Human Resources\Trackers - 2008.xls~RF564a19fa.TMP///D:\Human Resources\Trackers - 2008.xls','Renamed','Dec 12 2008 4:16PM' UNION ALL

    SELECT '42139','D:\Human Resources\Trackers - 2008.xls~RF564aafe1.TMP///D:\Human Resources\Trackers - 2008.xls','Renamed','Dec 12 2008 4:16PM' UNION ALL

    SELECT '42155','D:\MTR\11-15-2008\08-11-15_WDI--LIST1\~$-22270-02.doc','Created','Dec 12 2008 4:17PM' UNION ALL

    SELECT '42156','D:\MTR\11-15-2008\08-11-15_WDI--LIST1\~$-22270-02.doc','Changed','Dec 12 2008 4:17PM' UNION ALL

    SELECT '42174','D:\Users\mburkhalter\Marisa\time.xls','Changed','Dec 12 2008 4:18PM' UNION ALL

    SELECT '42192','D:\Users\mburkhalter\Marisa\time.xls','Changed','Dec 12 2008 4:18PM' UNION ALL

    SELECT '42198','D:\Users\mburkhalter\Marisa\time.xls~RF51e049f.TMP///D:\Users\mburkhalter\Marisa\time.xls','Renamed','Dec 12 2008 4:18PM' UNION ALL

    SELECT '42220','D:\Accounting\BalanceSheetComparison\2008\WDI-11-30-08.xls~RF51e8fc8.TMP///D:\Accounting\BalanceSheetComparison\2008\WDI-11-30-0','Renamed','Dec 12 2008 4:19PM' UNION ALL

    SELECT '42247','D:\Accounting\BalanceSheetComparison\2008\WDI-11-30-08.xls~RF51f8b10.TMP///D:\Accounting\BalanceSheetComparison\2008\WDI-11-30-0','Renamed','Dec 12 2008 4:20PM' UNION ALL

    SELECT '42273','D:\Human Resources\Trackers - 2008.xls~RF564fcb31.TMP///D:\Human Resources\Trackers - 2008.xls','Renamed','Dec 12 2008 4:22PM' UNION ALL

    SELECT '42299','D:\Human Resources\Trackers - 2008.xls~RF5650464d.TMP///D:\Human Resources\Trackers - 2008.xls','Renamed','Dec 12 2008 4:22PM' UNION ALL

    SELECT '42341','D:\Accounting\BalanceSheetComparison\2008\WDI-11-30-08.xls~RF5232abd.TMP///D:\Accounting\BalanceSheetComparison\2008\WDI-11-30-0','Renamed','Dec 12 2008 4:24PM' UNION ALL

    SELECT '42347','D:\Accounting\BalanceSheetComparison\2008\WDI-11-30-08.xls','Changed','Dec 12 2008 4:24PM' UNION ALL

    SELECT '42348','D:\Accounting\BalanceSheetComparison\2008\WDI-11-30-08.xls','Changed','Dec 12 2008 4:24PM' UNION ALL

    SELECT '42349','D:\Accounting\BalanceSheetComparison\2008\WDI-11-30-08.xls','Changed','Dec 12 2008 4:24PM' UNION ALL

    SELECT '42444','D:\Accounting\BalanceSheetComparison\2008\WDI-11-30-08.xls','Changed','Dec 12 2008 4:25PM' UNION ALL

    SELECT '42451','D:\Accounting\BalanceSheetComparison\2008\WDI-11-30-08.xls~RF524cc57.TMP///D:\Accounting\BalanceSheetComparison\2008\WDI-11-30-0','Renamed','Dec 12 2008 4:25PM' UNION ALL

    SELECT '42486','D:\Accounting\BalanceSheetComparison\2008\WDI-11-30-08.xls~RF524f03b.TMP///D:\Accounting\BalanceSheetComparison\2008\WDI-11-30-0','Renamed','Dec 12 2008 4:26PM' UNION ALL

    SELECT '42512','D:\Accounting\BalanceSheetComparison\2008\WDI-11-30-08.xls','Changed','Dec 12 2008 4:26PM' UNION ALL

    SELECT '42513','D:\Accounting\BalanceSheetComparison\2008\WDI-11-30-08.xls','Changed','Dec 12 2008 4:26PM' UNION ALL

    SELECT '42516','D:\Accounting\BalanceSheetComparison\2008\WDI-11-30-08.xls','Changed','Dec 12 2008 4:26PM' UNION ALL

    SELECT '42531','D:\QuickBooks\COLLECTION\Statements\12-8-08 -JENNY.xls','Changed','Dec 12 2008 4:26PM' UNION ALL

    SELECT '42536','D:\QuickBooks\COLLECTION\Statements\12-8-08 -JENNY.xls~RF167c2b87.TMP///D:\QuickBooks\COLLECTION\Statements\12-8-08 -JENNY.xls','Renamed','Dec 12 2008 4:26PM' UNION ALL

    SELECT '42564','D:\MTR\11-15-2008\08-11-15_WDI--LIST1\~$-31115-01.doc','Created','Dec 12 2008 4:27PM' UNION ALL

    SELECT '42565','D:\MTR\11-15-2008\08-11-15_WDI--LIST1\~$-31115-01.doc','Changed','Dec 12 2008 4:27PM' UNION ALL

    SELECT '42579','D:\Accounting\BalanceSheetComparison\2008\WDI-11-30-08.xls','Changed','Dec 12 2008 4:27PM' UNION ALL

    SELECT '42584','D:\Accounting\BalanceSheetComparison\2008\WDI-11-30-08.xls~RF5266aa6.TMP///D:\Accounting\BalanceSheetComparison\2008\WDI-11-30-0','Renamed','Dec 12 2008 4:27PM' UNION ALL

    SELECT '42588','D:\MTR\11-15-2008\08-11-15_WDI--LIST1\~$-31115-02.doc','Created','Dec 12 2008 4:27PM' UNION ALL

    SELECT '42589','D:\MTR\11-15-2008\08-11-15_WDI--LIST1\~$-31115-02.doc','Changed','Dec 12 2008 4:27PM' UNION ALL

    SELECT '42591','D:\MTR\11-15-2008\08-11-15_WDI--LIST1\~$-31117-01.doc','Created','Dec 12 2008 4:27PM' UNION ALL

    SELECT '42592','D:\MTR\11-15-2008\08-11-15_WDI--LIST1\~$-31117-01.doc','Changed','Dec 12 2008 4:27PM' UNION ALL

    SELECT '42594','D:\MTR\11-15-2008\08-11-15_WDI--LIST1\~$-31117-02.doc','Created','Dec 12 2008 4:27PM' UNION ALL

    SELECT '42595','D:\MTR\11-15-2008\08-11-15_WDI--LIST1\~$-31117-02.doc','Changed','Dec 12 2008 4:27PM' UNION ALL

    SELECT '42597','D:\Users\mburkhalter\Marisa\time.xls','Changed','Dec 12 2008 4:28PM' UNION ALL

    SELECT '44292','D:\MTR\11-15-2008\08-11-15_WDI--LIST1\~$-15015.doc','Created','Dec 12 2008 4:38PM' UNION ALL

    SELECT '44293','D:\MTR\11-15-2008\08-11-15_WDI--LIST1\~$-15015.doc','Changed','Dec 12 2008 4:38PM' UNION ALL

    SELECT '44502','D:\Human Resources\Personnel\Employee list 2.xls','Changed','Dec 12 2008 4:45PM' UNION ALL

    SELECT '44510','D:\MTR\11-15-2008\08-11-15_WDI--LIST1\~$-25025.doc','Created','Dec 12 2008 4:48PM' UNION ALL

    SELECT '44511','D:\MTR\11-15-2008\08-11-15_WDI--LIST1\~$-25025.doc','Changed','Dec 12 2008 4:48PM' UNION ALL

    SELECT '44513','D:\Human Resources\Personnel\Employee list 2.xls','Changed','Dec 12 2008 4:49PM' UNION ALL

    SELECT '44520','D:\Manufacturing\WDI Mfg. Production 2008\Open WO.xls','Deleted','Dec 12 2008 4:49PM' UNION ALL

    SELECT '44524','D:\Manufacturing\WDI Mfg. Production 2008\Open WO.xls','Created','Dec 12 2008 4:49PM' UNION ALL

    SELECT '48448','D:\Warehouse\Tomball Warehouse\Cons. Inventory.xls','Deleted','Dec 12 2008 4:55PM' UNION ALL

    SELECT '48452','D:\Warehouse\Tomball Warehouse\Cons. Inventory.xls','Created','Dec 12 2008 4:55PM' UNION ALL

    SELECT '48456','D:\Warehouse\Tomball Warehouse\EAL.xls','Deleted','Dec 12 2008 4:56PM' UNION ALL

    SELECT '48460','D:\Warehouse\Tomball Warehouse\EAL.xls','Created','Dec 12 2008 4:56PM' UNION ALL

    SELECT '48465','D:\Warehouse\Tomball Warehouse\PDL.xls','Deleted','Dec 12 2008 4:56PM' UNION ALL

    SELECT '48469','D:\Warehouse\Tomball Warehouse\PDL.xls','Created','Dec 12 2008 4:56PM' UNION ALL

    SELECT '48487','D:\Users\wsun\2008\hvc\MIP Invoice# 0214.xls','Created','Dec 12 2008 4:57PM' UNION ALL

    SELECT '48488','D:\Users\wsun\2008\hvc\MIP Invoice# 0214.xls','Deleted','Dec 12 2008 4:57PM' UNION ALL

    SELECT '49490','D:\MTR\11-15-2008\08-11-15_WDI--LIST1\~$-35025.doc','Created','Dec 12 2008 4:59PM' UNION ALL

    SELECT '49491','D:\MTR\11-15-2008\08-11-15_WDI--LIST1\~$-35025.doc','Changed','Dec 12 2008 4:59PM' UNION ALL

    SELECT '49971','D:\Profiles\dbowen\Desktop\To Do 12-15.doc','Created','Dec 12 2008 5:03PM' UNION ALL

    SELECT '49973','D:\Profiles\dbowen\Desktop\Slow Moving Items out of Tomball Warehouse.xls','Created','Dec 12 2008 5:03PM' UNION ALL

    SELECT '49977','D:\Profiles\dbowen\Desktop\Q4 - End of Year WDI Count Sheet.xls','Created','Dec 12 2008 5:03PM' UNION ALL

    SELECT '49981','D:\Profiles\dbowen\Desktop\2008 Year End Physical Count Procedures- rev1.doc','Created','Dec 12 2008 5:03PM' UNION ALL

    SELECT '49983','D:\Profiles\dbowen\Desktop\Q4- End of Year Count Sheets WDI and HVC.xls','Created','Dec 12 2008 5:03PM' UNION ALL

    SELECT '49986','D:\Profiles\dbowen\Desktop\Q4- End of Year HVC Count Sheet.xls','Created','Dec 12 2008 5:03PM' UNION ALL

    SELECT '49990','D:\Profiles\dbowen\Desktop\MinMax.xls','Deleted','Dec 12 2008 5:03PM' UNION ALL

    SELECT '49994','D:\Profiles\dbowen\Desktop\MinMax.xls','Created','Dec 12 2008 5:03PM' UNION ALL

    SELECT '49996','D:\Profiles\dbowen\Desktop\2008 On-Hand vs. Sold10-31.xls','Deleted','Dec 12 2008 5:03PM' UNION ALL

    SELECT '50000','D:\Profiles\dbowen\Desktop\2008 On-Hand vs. Sold10-31.xls','Created','Dec 12 2008 5:03PM' UNION ALL

    SELECT '50010','D:\Profiles\dbowen\Desktop\HVC PARTS LIST.xls','Deleted','Dec 12 2008 5:03PM' UNION ALL

    SELECT '50014','D:\Profiles\dbowen\Desktop\HVC PARTS LIST.xls','Created','Dec 12 2008 5:03PM' UNION ALL

    SELECT '50172','D:\QuickBooks\Inventory\Inventory Control December 08.xls~RF158a84db.TMP///D:\QuickBooks\Inventory\Inventory Control December 08','Renamed','Dec 12 2008 5:03PM' UNION ALL

    SELECT '52213','D:\MTR\11-15-2008\08-11-15_WDI--LIST1\~$-51024.doc','Created','Dec 12 2008 5:09PM' UNION ALL

    SELECT '52214','D:\MTR\11-15-2008\08-11-15_WDI--LIST1\~$-51024.doc','Changed','Dec 12 2008 5:09PM' UNION ALL

    SELECT '52220','D:\Warehouse\TOMBALL BACKORDER REPORT\Tomball Backorder Report.xls','Deleted','Dec 12 2008 5:09PM' UNION ALL

    SELECT '52224','D:\Warehouse\TOMBALL BACKORDER REPORT\Tomball Backorder Report.xls','Created','Dec 12 2008 5:09PM' UNION ALL

    SELECT '52229','D:\Warehouse\TOMBALL BACKORDER REPORT\Tomball Backorder Report.xls','Deleted','Dec 12 2008 5:09PM' UNION ALL

    SELECT '52233','D:\Warehouse\TOMBALL BACKORDER REPORT\Tomball Backorder Report.xls','Created','Dec 12 2008 5:09PM' UNION ALL

    SELECT '52246','D:\MTR\11-15-2008\08-11-15_WDI--LIST1\~$-70524.doc','Created','Dec 12 2008 5:20PM' UNION ALL

    SELECT '52247','D:\MTR\11-15-2008\08-11-15_WDI--LIST1\~$-70524.doc','Changed','Dec 12 2008 5:20PM' UNION ALL

    SELECT '52506','D:\MTR\11-15-2008\08-11-15_WDI--LIST1\~$-71024.doc','Created','Dec 12 2008 5:30PM' UNION ALL

    SELECT '52507','D:\MTR\11-15-2008\08-11-15_WDI--LIST1\~$-71024.doc','Changed','Dec 12 2008 5:30PM' UNION ALL

    SELECT '52524','D:\Manufacturing\QUALITY SYSTEM WDI MANUFACTURING\Quality Forms 20070305\NCR TBL 11-19-2007.xls','Deleted','Dec 12 2008 5:32PM' UNION ALL

    SELECT '52528','D:\Manufacturing\QUALITY SYSTEM WDI MANUFACTURING\Quality Forms 20070305\NCR TBL 11-19-2007.xls','Created','Dec 12 2008 5:32PM' UNION ALL

    SELECT '52544','D:\Manufacturing\QUALITY SYSTEM WDI MANUFACTURING\Quality Forms 20070305\NCR TBL 11-19-2007.xls','Deleted','Dec 12 2008 5:33PM' UNION ALL

    SELECT '52548','D:\Manufacturing\QUALITY SYSTEM WDI MANUFACTURING\Quality Forms 20070305\NCR TBL 11-19-2007.xls','Created','Dec 12 2008 5:33PM' UNION ALL

    SELECT '52594','D:\Warehouse\TOMBALL BACKORDER REPORT\Tomball Backorder Report.xls','Deleted','Dec 12 2008 5:37PM' UNION ALL

    SELECT '52598','D:\Warehouse\TOMBALL BACKORDER REPORT\Tomball Backorder Report.xls','Created','Dec 12 2008 5:37PM' UNION ALL

    SELECT '52603','D:\Warehouse\TOMBALL BACKORDER REPORT\Tomball Backorder Report.xls','Deleted','Dec 12 2008 5:37PM' UNION ALL

    SELECT '52607','D:\Warehouse\TOMBALL BACKORDER REPORT\Tomball Backorder Report.xls','Created','Dec 12 2008 5:37PM' UNION ALL

    SELECT '52612','D:\Warehouse\TOMBALL BACKORDER REPORT\Tomball Backorder Report.xls','Deleted','Dec 12 2008 5:37PM' UNION ALL

    SELECT '52616','D:\Warehouse\TOMBALL BACKORDER REPORT\Tomball Backorder Report.xls','Created','Dec 12 2008 5:37PM' UNION ALL

    SELECT '52646','D:\Warehouse\TOMBALL BACKORDER REPORT\Tomball Backorder Report.xls','Deleted','Dec 12 2008 5:39PM' UNION ALL

    SELECT '52650','D:\Warehouse\TOMBALL BACKORDER REPORT\Tomball Backorder Report.xls','Created','Dec 12 2008 5:39PM' UNION ALL

    SELECT '52655','D:\Warehouse\TOMBALL BACKORDER REPORT\Tomball Backorder Report.xls','Deleted','Dec 12 2008 5:39PM' UNION ALL

    SELECT '52659','D:\Warehouse\TOMBALL BACKORDER REPORT\Tomball Backorder Report.xls','Created','Dec 12 2008 5:39PM' UNION ALL

    SELECT '52683','D:\MTR\11-15-2008\08-11-15_WDI--LIST1\~$-95885.doc','Created','Dec 12 2008 5:41PM' UNION ALL

    SELECT '52684','D:\MTR\11-15-2008\08-11-15_WDI--LIST1\~$-95885.doc','Changed','Dec 12 2008 5:41PM' UNION ALL

    SELECT '52738','D:\Warehouse\TOMBALL BACKORDER REPORT\Tomball Backorder Report.xls','Deleted','Dec 12 2008 5:44PM' UNION ALL

    SELECT '52742','D:\Warehouse\TOMBALL BACKORDER REPORT\Tomball Backorder Report.xls','Created','Dec 12 2008 5:44PM' UNION ALL

    SELECT '52747','D:\Warehouse\TOMBALL BACKORDER REPORT\Tomball Backorder Report.xls','Deleted','Dec 12 2008 5:47PM' UNION ALL

    SELECT '52751','D:\Warehouse\TOMBALL BACKORDER REPORT\Tomball Backorder Report.xls','Created','Dec 12 2008 5:47PM' UNION ALL

    SELECT '52784','D:\Warehouse\TOMBALL BACKORDER REPORT\Tomball Backorder Report.xls','Deleted','Dec 12 2008 5:49PM' UNION ALL

    SELECT '52788','D:\Warehouse\TOMBALL BACKORDER REPORT\Tomball Backorder Report.xls','Created','Dec 12 2008 5:49PM' UNION ALL

    SELECT '52847','D:\MTR\11-15-2008\08-11-15_WDI--LIST1\~$-95887.doc','Created','Dec 12 2008 5:51PM' UNION ALL

    SELECT '52848','D:\MTR\11-15-2008\08-11-15_WDI--LIST1\~$-95887.doc','Changed','Dec 12 2008 5:51PM' UNION ALL

    SELECT '52882','D:\Warehouse\TOMBALL BACKORDER REPORT\Tomball Backorder Report.xls','Deleted','Dec 12 2008 5:54PM' UNION ALL

    SELECT '52886','D:\Warehouse\TOMBALL BACKORDER REPORT\Tomball Backorder Report.xls','Created','Dec 12 2008 5:54PM' UNION ALL

    SELECT '52891','D:\Warehouse\TOMBALL BACKORDER REPORT\Tomball Backorder Report.xls','Deleted','Dec 12 2008 5:54PM' UNION ALL

    SELECT '52895','D:\Warehouse\TOMBALL BACKORDER REPORT\Tomball Backorder Report.xls','Created','Dec 12 2008 5:54PM' UNION ALL

    SELECT '52924','D:\Warehouse\TOMBALL BACKORDER REPORT\Tomball Backorder Report.xls','Deleted','Dec 12 2008 5:57PM' UNION ALL

    SELECT '52928','D:\Warehouse\TOMBALL BACKORDER REPORT\Tomball Backorder Report.xls','Created','Dec 12 2008 5:57PM' UNION ALL

    SELECT '52933','D:\Warehouse\TOMBALL BACKORDER REPORT\Tomball Backorder Report.xls','Deleted','Dec 12 2008 5:58PM' UNION ALL

    SELECT '52937','D:\Warehouse\TOMBALL BACKORDER REPORT\Tomball Backorder Report.xls','Created','Dec 12 2008 5:58PM' UNION ALL

    SELECT '52978','D:\MTR\11-15-2008\08-11-15_WDI--LIST1\~$-95888.doc','Created','Dec 12 2008 6:02PM' UNION ALL

    SELECT '52979','D:\MTR\11-15-2008\08-11-15_WDI--LIST1\~$-95888.doc','Changed','Dec 12 2008 6:02PM' UNION ALL

    SELECT '53008','D:\Warehouse\TOMBALL BACKORDER REPORT\Tomball Backorder Report.xls','Deleted','Dec 12 2008 6:10PM' UNION ALL

    SELECT '53012','D:\Warehouse\TOMBALL BACKORDER REPORT\Tomball Backorder Report.xls','Created','Dec 12 2008 6:10PM' UNION ALL

    SELECT '53033','D:\Users\chan\HR\~$fer Letter - Cindy Johnson.doc','Created','Dec 12 2008 6:10PM' UNION ALL

    SELECT '53034','D:\Users\chan\HR\~$fer Letter - Cindy Johnson.doc','Changed','Dec 12 2008 6:10PM' UNION ALL

    SELECT '53035','D:\Users\chan\HR\~$fer Letter - Cindy Johnson.doc','Changed','Dec 12 2008 6:10PM' UNION ALL

    SELECT '53036','D:\Users\chan\HR\~$fer Letter - Cindy Johnson.doc','Changed','Dec 12 2008 6:10PM' UNION ALL

    SELECT '53039','D:\Users\chan\HR\~$fer Letter - Cindy Johnson.doc','Deleted','Dec 12 2008 6:12PM' UNION ALL

    SELECT '53044','D:\MTR\11-15-2008\08-11-15_WDI--LIST1\~$-96885.doc','Created','Dec 12 2008 6:12PM' UNION ALL

    SELECT '53045','D:\MTR\11-15-2008\08-11-15_WDI--LIST1\~$-96885.doc','Changed','Dec 12 2008 6:12PM' UNION ALL

    SELECT '53047','D:\Users\chan\HR\~$fer Letter - Cindy Johnson.doc','Created','Dec 12 2008 6:12PM' UNION ALL

    SELECT '53048','D:\Users\chan\HR\~$fer Letter - Cindy Johnson.doc','Changed','Dec 12 2008 6:12PM' UNION ALL

    SELECT '53049','D:\Users\chan\HR\~$fer Letter - Cindy Johnson.doc','Changed','Dec 12 2008 6:12PM' UNION ALL

    SELECT '53050','D:\Users\chan\HR\~$fer Letter - Cindy Johnson.doc','Changed','Dec 12 2008 6:12PM' UNION ALL

    SELECT '53073','D:\Users\chan\HR\~WRL2110.tmp///D:\Users\chan\HR\Offer Letter - Cindy Johnson.doc','Renamed','Dec 12 2008 6:12PM' UNION ALL

    SELECT '53079','D:\Users\chan\HR\~$fer Letter - Cindy Johnson.doc','Deleted','Dec 12 2008 6:12PM' UNION ALL

    SELECT '53081','D:\Users\chan\HR\~$fer Letter - Cindy Johnson.doc','Created','Dec 12 2008 6:13PM' UNION ALL

    SELECT '53082','D:\Users\chan\HR\~$fer Letter - Cindy Johnson.doc','Changed','Dec 12 2008 6:13PM' UNION ALL

    SELECT '53083','D:\Users\chan\HR\~$fer Letter - Cindy Johnson.doc','Changed','Dec 12 2008 6:13PM' UNION ALL

    SELECT '53084','D:\Users\chan\HR\~$fer Letter - Cindy Johnson.doc','Changed','Dec 12 2008 6:13PM' UNION ALL

    SELECT '53086','D:\Users\chan\HR\~$fer Letter - Cindy Johnson.doc','Deleted','Dec 12 2008 6:13PM' UNION ALL

    SELECT '53088','D:\Users\chan\Comerica RLOC Reporting\11-30-08 Inventory Report.xls','Created','Dec 12 2008 6:14PM' UNION ALL

    SELECT '53089','D:\Users\chan\Comerica RLOC Reporting\11-30-08 Inventory Report.xls','Deleted','Dec 12 2008 6:14PM' UNION ALL

    SELECT '53937','D:\MTR\11-15-2008\08-11-15_WDI--LIST1\~$-96887.doc','Created','Dec 12 2008 6:33PM' UNION ALL

    SELECT '53938','D:\MTR\11-15-2008\08-11-15_WDI--LIST1\~$-96887.doc','Changed','Dec 12 2008 6:33PM' UNION ALL

    SELECT '53946','D:\MTR\11-15-2008\08-11-15_WDI--LIST1\~$-FC001 (1).doc','Created','Dec 12 2008 6:44PM' UNION ALL

    SELECT '53947','D:\MTR\11-15-2008\08-11-15_WDI--LIST1\~$-FC001 (1).doc','Changed','Dec 12 2008 6:44PM' UNION ALL

    SELECT '53952','D:\Users\chan\KANA\SDBT INVOICE 008126054266.doc','Created','Dec 12 2008 6:54PM' UNION ALL

    SELECT '53975','D:\Users\chan\KANA\~WRL1724.tmp///D:\Users\chan\KANA\SDBT INVOICE 008126054266.doc','Renamed','Dec 12 2008 6:54PM' UNION ALL

    SELECT '53977','D:\Users\chan\KANA\~$BT INVOICE 008126054266.doc','Created','Dec 12 2008 6:54PM' UNION ALL

    SELECT '53978','D:\Users\chan\KANA\~$BT INVOICE 008126054266.doc','Changed','Dec 12 2008 6:54PM' UNION ALL

    SELECT '53979','D:\Users\chan\KANA\~$BT INVOICE 008126054266.doc','Changed','Dec 12 2008 6:54PM' UNION ALL

    SELECT '53980','D:\Users\chan\KANA\~$BT INVOICE 008126054266.doc','Changed','Dec 12 2008 6:54PM' UNION ALL

    SELECT '53986','D:\Users\chan\KANA\~$BT INVOICE 008126054266.doc','Deleted','Dec 12 2008 6:54PM' UNION ALL

    SELECT '53991','D:\MTR\11-15-2008\08-11-15_WDI--LIST1\~$-FC001 (2).doc','Created','Dec 12 2008 6:54PM' UNION ALL

    SELECT '53992','D:\MTR\11-15-2008\08-11-15_WDI--LIST1\~$-FC001 (2).doc','Changed','Dec 12 2008 6:54PM' UNION ALL

    SELECT '53994','D:\Users\chan\HVC Acquisition\Stock Purchase Agreement\HVC Disclosure Letter - 401K Plan.doc','Created','Dec 12 2008 6:58PM' UNION ALL

    SELECT '54017','D:\Users\chan\HVC Acquisition\Stock Purchase Agreement\~WRL1038.tmp///D:\Users\chan\HVC Acquisition\Stock Purchase Agreement\HVC','Renamed','Dec 12 2008 6:58PM' UNION ALL

    SELECT '54019','D:\Users\chan\HVC Acquisition\Stock Purchase Agreement\~$C Disclosure Letter - 401K Plan.doc','Created','Dec 12 2008 6:58PM' UNION ALL

    SELECT '54020','D:\Users\chan\HVC Acquisition\Stock Purchase Agreement\~$C Disclosure Letter - 401K Plan.doc','Changed','Dec 12 2008 6:58PM' UNION ALL

    SELECT '54021','D:\Users\chan\HVC Acquisition\Stock Purchase Agreement\~$C Disclosure Letter - 401K Plan.doc','Changed','Dec 12 2008 6:58PM' UNION ALL

    SELECT '54022','D:\Users\chan\HVC Acquisition\Stock Purchase Agreement\~$C Disclosure Letter - 401K Plan.doc','Changed','Dec 12 2008 6:58PM' UNION ALL

    SELECT '54026','D:\Users\chan\HVC Acquisition\Stock Purchase Agreement\~$C Disclosure Letter - 401K Plan.doc','Deleted','Dec 12 2008 6:58PM' UNION ALL

    SELECT '54040','D:\MTR\11-15-2008\08-11-15_WDI--LIST1\~$-FC007.doc','Created','Dec 12 2008 7:05PM' UNION ALL

    SELECT '54041','D:\MTR\11-15-2008\08-11-15_WDI--LIST1\~$-FC007.doc','Changed','Dec 12 2008 7:05PM' UNION ALL

    SELECT '54050','D:\MTR\11-15-2008\08-11-15_WDI--LIST1\~$-FC009.doc','Created','Dec 12 2008 7:15PM' UNION ALL

    SELECT '54051','D:\MTR\11-15-2008\08-11-15_WDI--LIST1\~$-FC009.doc','Changed','Dec 12 2008 7:15PM' UNION ALL

    SELECT '54059','D:\MTR\11-15-2008\08-11-15_WDI--LIST1\~$-JM107.doc','Created','Dec 12 2008 7:26PM' UNION ALL

    SELECT '54060','D:\MTR\11-15-2008\08-11-15_WDI--LIST1\~$-JM107.doc','Changed','Dec 12 2008 7:26PM' UNION ALL

    SELECT '54068','D:\MTR\11-15-2008\08-11-15_WDI--LIST1\~$-JM109.doc','Created','Dec 12 2008 7:36PM' UNION ALL

    SELECT '54069','D:\MTR\11-15-2008\08-11-15_WDI--LIST1\~$-JM109.doc','Changed','Dec 12 2008 7:36PM' UNION ALL

    SELECT '54077','D:\MTR\11-15-2008\08-11-15_WDI--LIST1\~$008071-21.doc','Created','Dec 12 2008 7:47PM' UNION ALL

    SELECT '54078','D:\MTR\11-15-2008\08-11-15_WDI--LIST1\~$008071-21.doc','Changed','Dec 12 2008 7:47PM' UNION ALL

    SELECT '56563','D:\MTR\11-15-2008\08-11-15_WDI--LIST1\~$008071-23.doc','Created','Dec 12 2008 8:08PM' UNION ALL

    SELECT '56564','D:\MTR\11-15-2008\08-11-15_WDI--LIST1\~$008071-23.doc','Changed','Dec 12 2008 8:08PM' UNION ALL

    SELECT '56581','D:\MTR\11-15-2008\08-11-15_WDI--LIST2\~$-00003.doc','Created','Dec 12 2008 8:29PM' UNION ALL

    SELECT '56582','D:\MTR\11-15-2008\08-11-15_WDI--LIST2\~$-00003.doc','Changed','Dec 12 2008 8:29PM' UNION ALL

    SELECT '56584','D:\MTR\11-15-2008\08-11-15_WDI--LIST2\~$-23989A.doc','Created','Dec 12 2008 8:29PM' UNION ALL

    SELECT '56585','D:\MTR\11-15-2008\08-11-15_WDI--LIST2\~$-23989A.doc','Changed','Dec 12 2008 8:29PM' UNION ALL

    SELECT '56587','D:\MTR\11-15-2008\08-11-15_WDI--LIST2\~$-24063.doc','Created','Dec 12 2008 8:29PM' UNION ALL

    SELECT '56588','D:\MTR\11-15-2008\08-11-15_WDI--LIST2\~$-24063.doc','Changed','Dec 12 2008 8:29PM' UNION ALL

    SELECT '56590','D:\MTR\11-15-2008\08-11-15_WDI--LIST2\~$-95885.doc','Created','Dec 12 2008 8:29PM' UNION ALL

    SELECT '56591','D:\MTR\11-15-2008\08-11-15_WDI--LIST2\~$-95885.doc','Changed','Dec 12 2008 8:29PM' UNION ALL

    SELECT '56599','D:\MTR\11-15-2008\08-11-15_WDI--LIST2\~$-95888.doc','Created','Dec 12 2008 8:39PM' UNION ALL

    SELECT '56600','D:\MTR\11-15-2008\08-11-15_WDI--LIST2\~$-95888.doc','Changed','Dec 12 2008 8:39PM' UNION ALL

    --===== Set the identity insert back to normal

    SET IDENTITY_INSERT #file_info OFF

    SET IDENTITY_INSERT #file_modify OFF

  • 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

  • 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.

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

  • 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

  • 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.

  • Jonathan, to elaborate on my last post, here is what I'm talking about...

    SELECT

    fi_id = MAX(fi.fi_id),

    fi.fi_pathname,

    fi.fi_username,

    fi.fi_permission,

    fi.fi_num_locks,

    Start = MAX(CASE WHEN fi.action = 'Start' THEN fi.dttm ELSE NULL END),

    Stop = MAX(CASE WHEN fi.action = 'Stop' THEN fi.dttm ELSE NULL END)

    FROM #file_info fi

    GROUP BY fi.fi_pathname,fi.fi_username,fi.fi_permission,fi.fi_num_locks

    ORDER BY fi_id

    That seems to work. However, it turns out the column fi_num_locks also has multiple values for some of the records. So, in order to display only one line for each fi_id, you can not include it in the query. I'm not sure what that is, but if you need to see it, then understand that every fi_id that has multiple fi_num_lock values will appear multiple times. You can see which ones they are by running this...

    SELECT

    fi_id

    FROM

    (

    SELECT

    fi_id = MAX(fi.fi_id),

    fi.fi_pathname,

    fi.fi_username,

    fi.fi_permission,

    fi.fi_num_locks,

    Start = MAX(CASE WHEN fi.action = 'Start' THEN fi.dttm ELSE NULL END),

    Stop = MAX(CASE WHEN fi.action = 'Stop' THEN fi.dttm ELSE NULL END)

    FROM #file_info fi

    GROUP BY fi.fi_pathname,fi.fi_username,fi.fi_permission,fi.fi_num_locks

    --ORDER BY fi_id

    ) t1

    GROUP BY fi_id

    HAVING COUNT(fi_id) > 1

    Now, take fi_id 166748 for example. If you go back and re-run the first query, you will see two instances of that record, one with fi_num_locks = 0 and one with fi_num_locks = 3.

    fi_idfi_pathnamefi_usernamefi_permissionfi_num_locksStartStop

    166748D:\MTR\11-15-2008\08-11-15_WDI--LIST1\2008-11-15 PACKING LIST-WDI.xlsWSUN3502008-12-12 08:20:00.000NULL

    166748D:\MTR\11-15-2008\08-11-15_WDI--LIST1\2008-11-15 PACKING LIST-WDI.xlsWSUN353NULL2008-12-12 08:21:00.000

    Just some things to think about.

    Greg
    _________________________________________________________________________________________________
    The glass is at one half capacity: nothing more, nothing less.

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

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