March 27, 2008 at 12:48 pm
I have the following query. It works and the table is relative small so performance is not the issue. This basically takes the rows inserted for this week's job and compares them to last week's rows, reporting any differences between the two counts. As I'm beginning to do more development work at my current job, I don't want to start developing bad coding habits or perpetuate ones that they currently have in place. Maybe it's just me but this looks like it could be improved and I'm looking for any suggestions (like I said, it works, it just seems clumsy). I've included the table layout and 1000 rows of data in a text file if you need it but I have a feeling a quick look below may be enough. Lastly, any preferences for a good book for TSQL development (amazon has 267 of them)?
Query:
select c.Table_Name, c.DBName, c.Row_Count as CurrentWk, c1.Row_Count as LastWk, (c.Row_Count - c1.Row_Count) as Diff
from DataRowCounts c
LEFT OUTER JOIN
DataRowCounts c1 on
c1.Table_Name = c.Table_Name
and c1.DBName = c.DBName
and CONVERT(char,c1.Run_Date,112) = CONVERT(char,(DATEADD(wk, -1,(select MAX(c2.Run_Date) from DataRowCounts c2))),112)
where CONVERT(char,c.Run_Date,112) = (select CONVERT(char,MAX(c2.Run_Date),112) from DataRowCounts c2)
and (c.Row_Count - c1.Row_Count) <> 0
order by (c.Row_Count - c1.Row_Count) desc
-- You can't be late until you show up.
March 27, 2008 at 1:24 pm
The one thing I noticed is the date comparisons. You should rather do comparisons (with between if necessary) of the dates as datetimes rather than converting the dates to strings to compare.
Conversions to strings are (relatively) expensive. The bigger issue is that SQL cannot seek on an index if there's a function applied on the column.
WHERE Col1 = 1 -- Is seekable
WHERE CAST(Col1 AS VARCHAR(2)) = '1' -- Is not seekable
I know you say you have a small number of rows and performance is not an issue, but this could cause you issues sometime in the future if the table grows
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 27, 2008 at 1:37 pm
That was the part I was stumped on. If I tried this:
SELECT c.DBName,
c.Table_Name,
c.Row_Count AS CurrentWk,
c.Run_date AS CurrentDt,
c1.Row_Count AS LastWk,
c1.Run_Date As LastDt,
(c.Row_Count - c1.Row_Count) AS Diff
FROM DataRowCounts c
LEFT OUTER JOIN DataRowCounts c1
ON c1.Table_Name = c.Table_Name
AND c1.DBName = c.DBName
AND c1.Run_Date = (DATEADD(wk,-1,(SELECT MAX(c2.Run_Date) FROM DataRowCounts c2)))
WHERE c.Run_Date = (SELECT MAX(c2.Run_Date) FROM DataRowCounts c2)
AND (c.Row_Count - c1.Row_Count) > 0
ORDER BY (c.Row_Count - c1.Row_Count) DESC
it returns zero rows due to the time portion of the field being different. So I kept tweaking the code until it looked like the code in my original post. However, the more I looked at it (even though it works) the more I thought I was taking the hard way to achieve my results. Any suggestions on a TSQL developer's guide?
-- You can't be late until you show up.
March 27, 2008 at 2:00 pm
I agree don't convert to varchar, try instead using DATEADD w DATEDIFF to alter the date itself. Here I made that tweak along with a tweak of get the MAX(run_date) once and joining as a set itself, but that should not have a major impact just reduces the read by 1 or so. However, noted yo are not concerned with the Table_Name and DBName in usin that value so depending on your specific need there could a hole in your intended logic.
SELECT
c.Table_Name,
c.DBName,
c.Row_Count as CurrentWk,
c1.Row_Count as LastWk,
(c.Row_Count - c1.Row_Count) as Diff
FROM
DataRowCounts c
INNER JOIN
(SELECT MAX(Run_Date) Run_Date from DataRowCounts) c2
ON
DATEADD(d,DATEDIFF(d,c1.Run_Date,0),0) = DATEADD(d,DATEDIFF(d,c2.Run_Date,0),0)
LEFT OUTER JOIN
DataRowCounts c1
ON
c1.Table_Name = c.Table_Name
and c1.DBName = c.DBName
and DATEADD(d,DATEDIFF(d,c1.Run_Date,0),0) = DATEADD(wk,-1,DATEADD(d,DATEDIFF(d,c2.Run_Date,0),0))
WHERE
(c.Row_Count - c1.Row_Count) <> 0
ORDER BY
(c.Row_Count - c1.Row_Count) desc
March 27, 2008 at 2:06 pm
If I understand it right (I did end up needing the data to figure this out) - you're looking to pull out the latest rowcounts by table, and compare them to the week prior. Also - to pick up on Gail's point - you're casting to char to get rid of the "time component"
A few things that would make this run quite a bit faster (and will KEEP it running fast, even when it grows):
- get rid of the time components using a calculated field.
- create a clustered index on tablename, dbname, rundate_short (the computed column). Actually looks like the rundate_short will end up being the most selective, so I'm thinking of putting it first.
- use the week concept and make derived tables on what you want only.
Your DDL then becomes:
CREATE TABLE [DataRowCounts] (
[Table_Name] [sysname] NOT NULL ,
[Row_Count] [bigint] NOT NULL ,
[Run_Date] [datetime] NOT NULL ,
[DBName] [char] (25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
rundate_short as dateadd(week,datediff(week,0,run_date),0)
) ON [PRIMARY]
GO
Create clustered index ix_dRC on datarowcounts(rundate_short,table_name,dbname)
go
Your query then becomes:
declare @currentweek datetime
select @currentweek=max(rundate_short) from datarowcounts
declare @previousweek datetime
set @previousweek=dateadd(week,-1,@currentweek);
select c.Table_Name,
c.DBName,
c.Row_Count as CurrentWk,
c1.Row_Count as LastWk,
(c.Row_Count - c1.Row_Count) as Diff
from (select * from datarowcounts where rundate_short=@currentweek) c
inner join --since you're doing comparisons on counts, this is an INNER JOIN
(select * from datarowcounts where rundate_short=@previousweek) c1
ON c.table_name=c1.table_name
and c.dbname=c1.dbname
where c.row_count<>c1.row_count
For S's and G's - the "cleaned up" insert statement to get the data looks like:
Insert datarowcounts(Table_Name,Row_Count,Run_Date,DBName)
select 'SYS_SECU','1','2008-03-23 05:30:01.877','UT_GATEWAY' UNION ALL
Select 'TEMPPROC','0','2008-03-23 05:30:01.877','UT_GATEWAY' UNION ALL
Select 'TP','2','2008-03-23 05:30:01.877','UT_GATEWAY' UNION ALL
Select 'TRADSTAT','13','2008-03-23 05:30:01.877','UT_GATEWAY' UNION ALL
Select 'TRLOG','0','2008-03-23 05:30:01.877','UT_GATEWAY' UNION ALL
Select 'WIXSET','2','2008-03-23 05:30:01.877','UT_GATEWAY' UNION ALL
SELECT 'dtproperties','0','2008-03-23 05:30:01.877','UT_GATEWAY' UNION ALL
SELECT 'ARCHFILE','23','2008-03-23 05:30:01.877','UT_GATEWAY' UNION ALL
SELECT 'COMMCH','0','2008-03-23 05:30:01.877','UT_GATEWAY' UNION ALL
SELECT 'ERROR','0','2008-03-23 05:30:01.877','UT_GATEWAY' UNION ALL
SELECT 'FGID','2','2008-03-23 05:30:01.877','UT_GATEWAY' UNION ALL
SELECT 'FGWIDTH','7','2008-03-23 05:30:01.877','UT_GATEWAY' UNION ALL
SELECT 'MBOX','2','2008-03-23 05:30:01.877','UT_GATEWAY' UNION ALL
SELECT 'PROCFILE','348','2008-03-23 05:30:01.877','UT_GATEWAY' UNION ALL
SELECT 'PROCNAME','31','2008-03-23 05:30:01.877','UT_GATEWAY' UNION ALL
SELECT 'PWD_GEN','0','2008-03-23 05:30:01.877','UT_GATEWAY' UNION ALL
SELECT 'RUN_ID','1','2008-03-23 05:30:01.877','UT_GATEWAY' UNION ALL
SELECT 'SYSUSER','1','2008-03-23 05:30:01.877','UT_GATEWAY' UNION ALL
SELECT 'Employee File','305167','2008-03-23 05:30:01.767','tbgfmla4' UNION ALL
SELECT 'Hist Company Insurance File','0','2008-03-23 05:30:01.767','tbgfmla4' UNION ALL
SELECT 'PlatformUpdates','62','2008-03-23 05:30:01.767','tbgfmla4' UNION ALL
SELECT 'INGHAM_SSO','2574','2008-03-23 05:30:01.767','tbgfmla4' UNION ALL
SELECT 'State Leave Plan File','34','2008-03-23 05:30:01.767','tbgfmla4' UNION ALL
SELECT 'hcscmanagerdat','1754','2008-03-23 05:30:01.767','tbgfmla4' UNION ALL
SELECT 'Claim File Empl Export_MT','0','2008-03-23 05:30:01.767','tbgfmla4' UNION ALL
SELECT 'Claim Notes','414425','2008-03-23 05:30:01.767','tbgfmla4' UNION ALL
SELECT 'HCSCmanagersold','13959','2008-03-23 05:30:01.767','tbgfmla4' UNION ALL
SELECT 'Empl_Premium_Export_MT','0','2008-03-23 05:30:01.767','tbgfmla4' UNION ALL
SELECT 'Claim Hours Used_MT_ALL_CL','0','2008-03-23 05:30:01.767','tbgfmla4' UNION ALL
SELECT 'Claim Hours Used_MT_ALL_FSCo','0','2008-03-23 05:30:01.767','tbgfmla4' UNION ALL
SELECT 'Manager Data','8616','2008-03-23 05:30:01.767','tbgfmla4' UNION ALL
SELECT '~TMPCLP184881','0','2008-03-23 05:30:01.767','tbgfmla4' UNION ALL
SELECT 'HCSC_conver_IDS','272','2008-03-23 05:30:01.767','tbgfmla4' UNION ALL
SELECT 'Claim Hours Used_MT_CL','0','2008-03-23 05:30:01.767','tbgfmla4' UNION ALL
SELECT '~TMPCLP546791','1714','2008-03-23 05:30:01.767','tbgfmla4' UNION ALL
SELECT 'Claim Hours Used_MT_FSCo','0','2008-03-23 05:30:01.767','tbgfmla4' UNION ALL
SELECT 'Company Admin Table','2','2008-03-23 05:30:01.767','tbgfmla4' UNION ALL
SELECT 'tempmanagercheck','14231','2008-03-23 05:30:01.767','tbgfmla4' UNION ALL
SELECT 'HCSCPROD','15852','2008-03-23 05:30:01.767','tbgfmla4' UNION ALL
SELECT 'Claim Hours Used_OC_MT','0','2008-03-23 05:30:01.767','tbgfmla4' UNION ALL
SELECT 'Clm_EDClaim','3','2008-03-23 05:30:01.767','tbgfmla4' UNION ALL
SELECT 'Clm_EDEmpl','1','2008-03-23 05:30:01.767','tbgfmla4' UNION ALL
SELECT 'EE_EDEmpl','0','2008-03-23 05:30:01.767','tbgfmla4' UNION ALL
SELECT 'Missing Employees','1','2008-03-23 05:30:01.767','tbgfmla4' UNION ALL
SELECT 'Claim File_backup','96241','2008-03-23 05:30:01.767','tbgfmla4' UNION ALL
SELECT 'MassLetters','31','2008-03-23 05:30:01.767','tbgfmla4' UNION ALL
SELECT 'EE_MGR_ID_PAMP','807','2008-03-23 05:30:01.767','tbgfmla4' UNION ALL
SELECT 'EE_MGR_ID_CME','1307','2008-03-23 05:30:01.767','tbgfmla4' UNION ALL
SELECT 'ManagersComcast','199','2008-03-23 05:30:01.767','tbgfmla4' UNION ALL
SELECT 'EE_MGR_ID_IWCO','1483','2008-03-23 05:30:01.767','tbgfmla4' UNION ALL
SELECT 'EE_MGR_ID_INGHAM','2039','2008-03-23 05:30:01.767','tbgfmla4' UNION ALL
SELECT 'EE_MGR_GE','8168','2008-03-23 05:30:01.767','tbgfmla4' UNION ALL
SELECT 'CompanyInfo','193','2008-03-23 05:30:01.767','tbgfmla4' UNION ALL
SELECT 'BenefitRates','3101','2008-03-23 05:30:01.767','tbgfmla4' UNION ALL
SELECT 'update_ImportErrors','0','2008-03-23 05:30:01.767','tbgfmla4' UNION ALL
SELECT 'WeeklyReportInfo','906','2008-03-23 05:30:01.767','tbgfmla4' UNION ALL
SELECT 'EE_EDClaim','0','2008-03-23 05:30:01.767','tbgfmla4' UNION ALL
SELECT 'EE StateSet','0','2008-03-23 05:30:01.767','tbgfmla4' UNION ALL
SELECT 'update_ImportErrors1','7','2008-03-23 05:30:01.767','tbgfmla4' UNION ALL
SELECT 'Freq_Hrs_YTD','855','2008-03-23 05:30:01.767','tbgfmla4' UNION ALL
SELECT 'Freq_Dec_YTD','1','2008-03-23 05:30:01.767','tbgfmla4' UNION ALL
SELECT 'Employee Ins Coverage File','0','2008-03-23 05:30:01.767','tbgfmla4' UNION ALL
SELECT 'update_ImportErrors2','7','2008-03-23 05:30:01.767','tbgfmla4' UNION ALL
SELECT 'ReportScripts','7','2008-03-23 05:30:01.767','tbgfmla4' UNION ALL
SELECT 'Hours Summary Update','0','2008-03-23 05:30:01.767','tbgfmla4' UNION ALL
SELECT 'update_ImportErrors3','7','2008-03-23 05:30:01.767','tbgfmla4' UNION ALL
SELECT 'WebLinks','0','2008-03-23 05:30:01.767','tbgfmla4' UNION ALL
SELECT 'Claim File','126431','2008-03-23 05:30:01.767','tbgfmla4' UNION ALL
SELECT 'Dept Code','118','2008-03-23 05:30:01.767','tbgfmla4' UNION ALL
SELECT 'Employee Filebackup','132066','2008-03-23 05:30:01.767','tbgfmla4' UNION ALL
SELECT 'Callback Rsn File','0','2008-03-23 05:30:01.767','tbgfmla4' UNION ALL
SELECT 'Hours Summary_TA','0','2008-03-23 05:30:01.767','tbgfmla4' UNION ALL
SELECT 'Manager Data_20061012','3157','2008-03-23 05:30:01.767','tbgfmla4' UNION ALL
SELECT 'Relation File','6','2008-03-23 05:30:01.767','tbgfmla4' UNION ALL
SELECT 'Correspondence File','1520','2008-03-23 05:30:01.767','tbgfmla4' UNION ALL
SELECT 'Hist Claim File Non GEC','0','2008-03-23 05:30:01.767','tbgfmla4' UNION ALL
SELECT 'Correspondence File Old','0','2008-03-23 05:30:01.767','tbgfmla4' UNION ALL
SELECT 'Denial_Counts','26','2008-03-23 05:30:01.767','tbgfmla4' UNION ALL
SELECT 'CI_Web_Import_Calc','0','2008-03-23 05:30:01.767','tbgfmla4' UNION ALL
SELECT 'ManagersBMW','20','2008-03-23 05:30:01.767','tbgfmla4' UNION ALL
SELECT 'HRContactComcastNew','199','2008-03-23 05:30:01.767','tbgfmla4' UNION ALL
SELECT 'HRContactComcast','198','2008-03-23 05:30:01.767','tbgfmla4' UNION ALL
SELECT 'dtproperties','0','2008-03-23 05:30:01.767','tbgfmla4' UNION ALL
SELECT 'Freq_Dec_YTD_New','1','2008-03-23 05:30:01.767','tbgfmla4' UNION ALL
SELECT 'Freq_Hrs_YTD_New','208','2008-03-23 05:30:01.767','tbgfmla4' UNION ALL
SELECT 'Employee Update File','2516','2008-03-23 05:30:01.767','tbgfmla4' UNION ALL
SELECT 'CI_Web_Import_Raw','0','2008-03-23 05:30:01.767','tbgfmla4' UNION ALL
SELECT 'Hours Update CoLvPlan','2','2008-03-23 05:30:01.767','tbgfmla4' UNION ALL
SELECT 'Hist Claim Notes','377840','2008-03-23 05:30:01.767','tbgfmla4' UNION ALL
SELECT 'ManagersChemtura','19','2008-03-23 05:30:01.767','tbgfmla4' UNION ALL
SELECT 'Hist Employee Ins Billing File','0','2008-03-23 05:30:01.767','tbgfmla4' UNION ALL
SELECT 'Company Leave Plan File_EEMT','0','2008-03-23 05:30:01.767','tbgfmla4' UNION ALL
SELECT 'ManagerSunlifeBackup','460','2008-03-23 05:30:01.767','tbgfmla4' UNION ALL
SELECT 'Company Leave Plan File_OCMT','0','2008-03-23 05:30:01.767','tbgfmla4' UNION ALL
SELECT 'tempTermDteResearch','2943','2008-03-23 05:30:01.767','tbgfmla4' UNION ALL
SELECT 'Employee File Archive','0','2008-03-23 05:30:01.767','tbgfmla4' UNION ALL
SELECT 'HS Clm Updte Clm','0','2008-03-23 05:30:01.767','tbgfmla4' UNION ALL
SELECT 'HS EE','1','2008-03-23 05:30:01.767','tbgfmla4' UNION ALL
SELECT 'Conversion Errors','0','2008-03-23 05:30:01.767','tbgfmla4' UNION ALL
SELECT 'History_Claim_File','0','2008-03-23 05:30:01.767','tbgfmla4' UNION ALL
SELECT 'ManagersSensata','1614','2008-03-23 05:30:01.767','tbgfmla4' UNION ALL
SELECT 'ManagersIwcoDirect','14','2008-03-23 05:30:01.767','tbgfmla4' UNION ALL
SELECT 'HS EEClm','3','2008-03-23 05:30:01.767','tbgfmla4' UNION ALL
SELECT 'HS Empl Update','0','2008-03-23 05:30:01.767','tbgfmla4' UNION ALL
SELECT 'ManagersCommonWealth','407','2008-03-23 05:30:01.767','tbgfmla4' UNION ALL
SELECT 'SensataTemp','1603','2008-03-23 05:30:01.767','tbgfmla4' UNION ALL
SELECT 'InghamManagers','119','2008-03-23 05:30:01.767','tbgfmla4' UNION ALL
SELECT 'HS Update HS','0','2008-03-23 05:30:01.767','tbgfmla4' UNION ALL
SELECT 'ManagersFreshExpress','10','2008-03-23 05:30:01.767','tbgfmla4' UNION ALL
SELECT 'Hist Company Leave Plan File','268','2008-03-23 05:30:01.767','tbgfmla4' UNION ALL
SELECT 'Employee File_20061017','143235','2008-03-23 05:30:01.767','tbgfmla4' UNION ALL
SELECT 'ManagersSunlife','462','2008-03-23 05:30:01.767','tbgfmla4' UNION ALL
SELECT 'IT_TaskList','5','2008-03-23 05:30:01.767','tbgfmla4' UNION ALL
SELECT 'Manager Data_20061018','3322','2008-03-23 05:30:01.767','tbgfmla4' UNION ALL
SELECT 'Employee Ins Billing File','0','2008-03-23 05:30:01.767','tbgfmla4' UNION ALL
SELECT 'Company Data File','130','2008-03-23 05:30:01.767','tbgfmla4' UNION ALL
SELECT 'Employee File_20061018','135116','2008-03-23 05:30:01.767','tbgfmla4' UNION ALL
SELECT 'EligibleEmployees','92','2008-03-23 05:30:01.767','tbgfmla4' UNION ALL
SELECT 'Hours Summary','557474','2008-03-23 05:30:01.767','tbgfmla4' UNION ALL
SELECT 'ManagersPenske','1150','2008-03-23 05:30:01.767','tbgfmla4' UNION ALL
SELECT 'Hist Hours Summary','531470','2008-03-23 05:30:01.767','tbgfmla4' UNION ALL
SELECT 'INGREG_HW','3107','2008-03-23 05:30:01.767','tbgfmla4' UNION ALL
SELECT 'Att_AbsCde','0','2008-03-23 05:30:01.767','tbgfmla4' UNION ALL
SELECT 'FMLAInputData_ImportErrors','0','2008-03-23 05:30:01.767','tbgfmla4' UNION ALL
SELECT 'Claim File_11022006','56414','2008-03-23 05:30:01.767','tbgfmla4' UNION ALL
SELECT 'GESSOConv','21223','2008-03-23 05:30:01.767','tbgfmla4' UNION ALL
SELECT 'Att_AbsRec','0','2008-03-23 05:30:01.767','tbgfmla4' UNION ALL
SELECT 'Company Insurance File','0','2008-03-23 05:30:01.767','tbgfmla4' UNION ALL
SELECT 'Att_AbsRec_Import','0','2008-03-23 05:30:01.767','tbgfmla4' UNION ALL
SELECT 'Att_CoPlans','0','2008-03-23 05:30:01.767','tbgfmla4' UNION ALL
SELECT 'GEC_ClmTrk','0','2008-03-23 05:30:01.767','tbgfmla4' UNION ALL
SELECT 'Att_Corresp','0','2008-03-23 05:30:01.767','tbgfmla4' UNION ALL
SELECT 'Att_CoRules','0','2008-03-23 05:30:01.767','tbgfmla4' UNION ALL
SELECT 'Correspondence Signature','11','2008-03-23 05:30:01.767','tbgfmla4' UNION ALL
SELECT 'NewEmplUpdate','2516','2008-03-23 05:30:01.767','tbgfmla4' UNION ALL
SELECT 'Att_Occur','0','2008-03-23 05:30:01.767','tbgfmla4' UNION ALL
SELECT 'FedPersRsn','0','2008-03-23 05:30:01.767','tbgfmla4' UNION ALL
SELECT 'Hist Company Data File','0','2008-03-23 05:30:01.767','tbgfmla4' UNION ALL
SELECT 'Hist Employee File','0','2008-03-23 05:30:01.767','tbgfmla4' UNION ALL
SELECT 'ManagerUpdate','7046','2008-03-23 05:30:01.767','tbgfmla4' UNION ALL
SELECT 'Company Data File_EEMT','0','2008-03-23 05:30:01.767','tbgfmla4' UNION ALL
SELECT 'Hist_Att_AbsCde','0','2008-03-23 05:30:01.767','tbgfmla4' UNION ALL
SELECT 'Hist_Att_AbsRec','0','2008-03-23 05:30:01.767','tbgfmla4' UNION ALL
SELECT 'Hist_Att_CoPlans','0','2008-03-23 05:30:01.767','tbgfmla4' UNION ALL
SELECT 'Paste Errors','0','2008-03-23 05:30:01.767','tbgfmla4' UNION ALL
SELECT 'Hist_Att_CoRules','0','2008-03-23 05:30:01.767','tbgfmla4' UNION ALL
SELECT 'Hist_Att_Occur','0','2008-03-23 05:30:01.767','tbgfmla4' UNION ALL
SELECT 'DataRowCounts','151','2008-03-23 05:30:01.767','tbgfmla4' UNION ALL
SELECT 'SysCdeDDBox1','0','2008-03-23 05:30:01.767','tbgfmla4' UNION ALL
SELECT 'Company Leave Plan File','288','2008-03-23 05:30:01.767','tbgfmla4' UNION ALL
SELECT 'SysCdeDDBox2','0','2008-03-23 05:30:01.767','tbgfmla4' UNION ALL
SELECT 'SysCdeDDBox3','0','2008-03-23 05:30:01.767','tbgfmla4' UNION ALL
SELECT 'AdvMgr','36','2008-03-23 05:30:01.767','tbgfmla4' UNION ALL
SELECT 'Freq_Dec_YTD_All','2','2008-03-23 05:30:01.767','tbgfmla4' UNION ALL
SELECT 'SysCdeDDBox4','0','2008-03-23 05:30:01.767','tbgfmla4' UNION ALL
SELECT 'Freq_Hrs_YTD_All','53732','2008-03-23 05:30:01.767','tbgfmla4' UNION ALL
SELECT 'SysCdeDDBox5','0','2008-03-23 05:30:01.767','tbgfmla4' UNION ALL
SELECT 'Hist Claim File','537014','2008-03-23 05:30:01.767','tbgfmla4' UNION ALL
SELECT 'Company Data File_OCMT','0','2008-03-23 05:30:01.767','tbgfmla4' UNION ALL
SELECT 'SysCdeDDBox6','0','2008-03-23 05:30:01.767','tbgfmla4' UNION ALL
SELECT 'States','51','2008-03-23 05:30:01.767','tbgfmla4' UNION ALL
SELECT 'Hist State Leave Plan File','33','2008-03-23 05:30:01.767','tbgfmla4' UNION ALL
SELECT 'Correspondence Sent','3497','2008-03-23 05:30:01.767','tbgfmla4' UNION ALL
SELECT 'ManagersGTCasino','30','2008-03-23 05:30:01.767','tbgfmla4' UNION ALL
SELECT 'ManagersLaRabida','46','2008-03-23 05:30:01.767','tbgfmla4' UNION ALL
SELECT 'ManagersGEPlastic','23','2008-03-23 05:30:01.767','tbgfmla4' UNION ALL
SELECT 'Hist Claim File GEC Post2004','0','2008-03-23 05:30:01.767','tbgfmla4' UNION ALL
SELECT 'Rsn Denied File','26','2008-03-23 05:30:01.767','tbgfmla4' UNION ALL
SELECT 'Correspondence_Sent_RPT','39','2008-03-23 05:30:01.767','tbgfmla4' UNION ALL
SELECT 'Comcast_MgrID_list','11392','2008-03-23 05:30:01.767','tbgfmla4' UNION ALL
SELECT 'Hist Claim File GEC Pre2004','0','2008-03-23 05:30:01.767','tbgfmla4' UNION ALL
SELECT 'Chemtura_mgrid_list','3530','2008-03-23 05:30:01.767','tbgfmla4' UNION ALL
SELECT 'Manager list 08-17-06','3522','2008-03-23 05:30:01.767','tbgfmla4' UNION ALL
SELECT 'Yankeemanager07152006','4551','2008-03-23 05:30:01.767','tbgfmla4' UNION ALL
SELECT 'EmployeeFile030_2004','3959991','2008-03-23 05:30:01.720','STAGING ' UNION ALL
SELECT 'EmployeeFile030_2005','11756439','2008-03-23 05:30:01.720','STAGING ' UNION ALL
SELECT 'EmployeeFile030_2006','15752337','2008-03-23 05:30:01.720','STAGING ' UNION ALL
SELECT 'EmployeeFile030_20071210','18246259','2008-03-23 05:30:01.720','STAGING ' UNION ALL
SELECT 'EmployeeFile030CokeCounts','15','2008-03-23 05:30:01.720','STAGING ' UNION ALL
SELECT 'employeefile030test','0','2008-03-23 05:30:01.720','STAGING ' UNION ALL
SELECT 'EMPLOYEEFILE030_TEMP','0','2008-03-23 05:30:01.720','STAGING ' UNION ALL
SELECT 'Employeefile030','4430731','2008-03-23 05:30:01.720','STAGING ' UNION ALL
SELECT 'EmployeeFile030Temp','230','2008-03-23 05:30:01.720','STAGING ' UNION ALL
SELECT 'EmployeeFile030Errors','12986','2008-03-23 05:30:01.720','STAGING ' UNION ALL
SELECT 'EligibilityStaging','0','2008-03-23 05:30:01.720','STAGING ' UNION ALL
SELECT 'dtproperties','0','2008-03-23 05:30:01.720','STAGING ' UNION ALL
SELECT 'mon','0','2008-03-23 05:30:01.547','IPRISM' UNION ALL
SELECT 'RT','0','2008-03-23 05:30:01.547','IPRISM' UNION ALL
SELECT 'dtproperties','0','2008-03-23 05:30:01.547','IPRISM' UNION ALL
SELECT 'CAS_SEGMENT','0','2008-03-23 05:30:01.453','HIPAA_ODS_ARCHIVE ' UNION ALL
SELECT 'CAT_SEGMENT','0','2008-03-23 05:30:01.453','HIPAA_ODS_ARCHIVE ' UNION ALL
SELECT 'CL1_SEGMENT','0','2008-03-23 05:30:01.453','HIPAA_ODS_ARCHIVE ' UNION ALL
SELECT 'CLM_SEGMENT','0','2008-03-23 05:30:01.453','HIPAA_ODS_ARCHIVE ' UNION ALL
SELECT 'CLP_SEGMENT','0','2008-03-23 05:30:01.453','HIPAA_ODS_ARCHIVE ' UNION ALL
SELECT 'CN1_SEGMENT','0','2008-03-23 05:30:01.453','HIPAA_ODS_ARCHIVE ' UNION ALL
SELECT 'COB_SEGMENT','0','2008-03-23 05:30:01.453','HIPAA_ODS_ARCHIVE ' UNION ALL
SELECT 'COMPANY_INFO','0','2008-03-23 05:30:01.453','HIPAA_ODS_ARCHIVE ' UNION ALL
SELECT 'CONTACT_INFO','0','2008-03-23 05:30:01.453','HIPAA_ODS_ARCHIVE ' UNION ALL
SELECT 'CR1_SEGMENT','0','2008-03-23 05:30:01.453','HIPAA_ODS_ARCHIVE ' UNION ALL
SELECT 'CR2_SEGMENT','0','2008-03-23 05:30:01.453','HIPAA_ODS_ARCHIVE ' UNION ALL
SELECT 'CR3_SEGMENT','0','2008-03-23 05:30:01.453','HIPAA_ODS_ARCHIVE ' UNION ALL
SELECT 'CR5_SEGMENT','0','2008-03-23 05:30:01.453','HIPAA_ODS_ARCHIVE ' UNION ALL
SELECT 'CR6_SEGMENT','0','2008-03-23 05:30:01.453','HIPAA_ODS_ARCHIVE ' UNION ALL
SELECT 'CR7_SEGMENT','0','2008-03-23 05:30:01.453','HIPAA_ODS_ARCHIVE ' UNION ALL
SELECT 'CRC_SEGMENT','0','2008-03-23 05:30:01.453','HIPAA_ODS_ARCHIVE ' UNION ALL
SELECT 'CTP_SEGMENT','0','2008-03-23 05:30:01.453','HIPAA_ODS_ARCHIVE ' UNION ALL
SELECT 'CUR_SEGMENT','0','2008-03-23 05:30:01.453','HIPAA_ODS_ARCHIVE ' UNION ALL
SELECT 'DMG_SEGMENT','0','2008-03-23 05:30:01.453','HIPAA_ODS_ARCHIVE ' UNION ALL
SELECT 'DSB_SEGMENT','0','2008-03-23 05:30:01.453','HIPAA_ODS_ARCHIVE ' UNION ALL
SELECT 'DTM_SEGMENT','0','2008-03-23 05:30:01.453','HIPAA_ODS_ARCHIVE ' UNION ALL
SELECT 'DTP_SEGMENT','0','2008-03-23 05:30:01.453','HIPAA_ODS_ARCHIVE ' UNION ALL
SELECT 'EB_SEGMENT','0','2008-03-23 05:30:01.453','HIPAA_ODS_ARCHIVE ' UNION ALL
SELECT 'ENT_SEGMENT','0','2008-03-23 05:30:01.453','HIPAA_ODS_ARCHIVE ' UNION ALL
SELECT 'EQ_SEGMENT','0','2008-03-23 05:30:01.453','HIPAA_ODS_ARCHIVE ' UNION ALL
SELECT 'FRM_SEGMENT','0','2008-03-23 05:30:01.453','HIPAA_ODS_ARCHIVE ' UNION ALL
SELECT 'GE_SEGMENT','0','2008-03-23 05:30:01.453','HIPAA_ODS_ARCHIVE ' UNION ALL
SELECT 'GS_SEGMENT','0','2008-03-23 05:30:01.453','HIPAA_ODS_ARCHIVE ' UNION ALL
SELECT 'HCP_SEGMENT','0','2008-03-23 05:30:01.453','HIPAA_ODS_ARCHIVE ' UNION ALL
SELECT 'HCR_SEGMENT','0','2008-03-23 05:30:01.453','HIPAA_ODS_ARCHIVE ' UNION ALL
SELECT 'HD_SEGMENT','0','2008-03-23 05:30:01.453','HIPAA_ODS_ARCHIVE ' UNION ALL
SELECT 'HIPAA_LOOP','0','2008-03-23 05:30:01.453','HIPAA_ODS_ARCHIVE ' UNION ALL
SELECT 'HIPAA_SEGMENT_LOOKUP','0','2008-03-23 05:30:01.453','HIPAA_ODS_ARCHIVE ' UNION ALL
SELECT 'HIPAA_TRADING_PARTNER','0','2008-03-23 05:30:01.453','HIPAA_ODS_ARCHIVE ' UNION ALL
SELECT 'HIPAA_TRANSACTIONS','0','2008-03-23 05:30:01.453','HIPAA_ODS_ARCHIVE ' UNION ALL
SELECT 'HIPAA_TRANSACTION_LOOKUP','0','2008-03-23 05:30:01.453','HIPAA_ODS_ARCHIVE ' UNION ALL
SELECT 'HIPAA_TRANSACTION_SEGMENT_LOOKUP','0','2008-03-23 05:30:01.453','HIPAA_ODS_ARCHIVE ' UNION ALL
SELECT 'HI_SEGMENT','0','2008-03-23 05:30:01.453','HIPAA_ODS_ARCHIVE ' UNION ALL
SELECT 'HLH_SEGMENT','0','2008-03-23 05:30:01.453','HIPAA_ODS_ARCHIVE ' UNION ALL
SELECT 'HL_SEGMENT','0','2008-03-23 05:30:01.453','HIPAA_ODS_ARCHIVE ' UNION ALL
SELECT 'HSD_SEGMENT','0','2008-03-23 05:30:01.453','HIPAA_ODS_ARCHIVE ' UNION ALL
SELECT 'ICM_SEGMENT','0','2008-03-23 05:30:01.453','HIPAA_ODS_ARCHIVE ' UNION ALL
SELECT 'IDC_SEGMENT','0','2008-03-23 05:30:01.453','HIPAA_ODS_ARCHIVE ' UNION ALL
SELECT 'IEA_SEGMENT','0','2008-03-23 05:30:01.453','HIPAA_ODS_ARCHIVE ' UNION ALL
SELECT 'III_SEGMENT','0','2008-03-23 05:30:01.453','HIPAA_ODS_ARCHIVE ' UNION ALL
SELECT 'INS_SEGMENT','0','2008-03-23 05:30:01.453','HIPAA_ODS_ARCHIVE ' UNION ALL
SELECT 'ISA_SEGMENT','0','2008-03-23 05:30:01.453','HIPAA_ODS_ARCHIVE ' UNION ALL
SELECT 'IT1_SEGMENT','0','2008-03-23 05:30:01.453','HIPAA_ODS_ARCHIVE ' UNION ALL
SELECT 'K3_SEGMENT','0','2008-03-23 05:30:01.453','HIPAA_ODS_ARCHIVE ' UNION ALL
SELECT 'LE_SEGMENT','0','2008-03-23 05:30:01.453','HIPAA_ODS_ARCHIVE ' UNION ALL
SELECT 'LIN_SEGMENT','0','2008-03-23 05:30:01.453','HIPAA_ODS_ARCHIVE ' UNION ALL
SELECT 'LQ_SEGMENT','0','2008-03-23 05:30:01.453','HIPAA_ODS_ARCHIVE ' UNION ALL
SELECT 'LS_SEGMENT','0','2008-03-23 05:30:01.453','HIPAA_ODS_ARCHIVE ' UNION ALL
SELECT 'LUI_SEGMENT','0','2008-03-23 05:30:01.453','HIPAA_ODS_ARCHIVE ' UNION ALL
SELECT 'LX_SEGMENT','0','2008-03-23 05:30:01.453','HIPAA_ODS_ARCHIVE ' UNION ALL
SELECT 'MEA_SEGMENT','0','2008-03-23 05:30:01.453','HIPAA_ODS_ARCHIVE ' UNION ALL
SELECT 'MIA_SEGMENT','0','2008-03-23 05:30:01.453','HIPAA_ODS_ARCHIVE ' UNION ALL
SELECT 'MOA_SEGMENT','0','2008-03-23 05:30:01.453','HIPAA_ODS_ARCHIVE ' UNION ALL
SELECT 'MSG_SEGMENT','0','2008-03-23 05:30:01.453','HIPAA_ODS_ARCHIVE ' UNION ALL
SELECT 'N1_SEGMENT','0','2008-03-23 05:30:01.453','HIPAA_ODS_ARCHIVE ' UNION ALL
SELECT 'N2_SEGMENT','0','2008-03-23 05:30:01.453','HIPAA_ODS_ARCHIVE ' UNION ALL
SELECT 'N3_SEGMENT','0','2008-03-23 05:30:01.453','HIPAA_ODS_ARCHIVE ' UNION ALL
SELECT 'N4_SEGMENT','0','2008-03-23 05:30:01.453','HIPAA_ODS_ARCHIVE ' UNION ALL
SELECT 'NM1_SEGMENT','0','2008-03-23 05:30:01.453','HIPAA_ODS_ARCHIVE ' UNION ALL
SELECT 'NTE_SEGMENT','0','2008-03-23 05:30:01.453','HIPAA_ODS_ARCHIVE ' UNION ALL
SELECT 'OI_SEGMENT','0','2008-03-23 05:30:01.453','HIPAA_ODS_ARCHIVE ' UNION ALL
SELECT 'PAT_SEGMENT','0','2008-03-23 05:30:01.453','HIPAA_ODS_ARCHIVE ' UNION ALL
SELECT 'PER_SEGMENT','0','2008-03-23 05:30:01.453','HIPAA_ODS_ARCHIVE ' UNION ALL
SELECT 'PLA_SEGMENT','0','2008-03-23 05:30:01.453','HIPAA_ODS_ARCHIVE ' UNION ALL
SELECT 'PLB_SEGMENT','0','2008-03-23 05:30:01.453','HIPAA_ODS_ARCHIVE ' UNION ALL
SELECT 'PRV_SEGMENT','0','2008-03-23 05:30:01.453','HIPAA_ODS_ARCHIVE ' UNION ALL
SELECT 'PS1_SEGMENT','0','2008-03-23 05:30:01.453','HIPAA_ODS_ARCHIVE ' UNION ALL
SELECT 'PWK_SEGMENT','0','2008-03-23 05:30:01.453','HIPAA_ODS_ARCHIVE ' UNION ALL
SELECT 'QTY_SEGMENT','0','2008-03-23 05:30:01.453','HIPAA_ODS_ARCHIVE ' UNION ALL
SELECT 'REF_SEGMENT','0','2008-03-23 05:30:01.453','HIPAA_ODS_ARCHIVE ' UNION ALL
SELECT 'RMR_SEGMENT','0','2008-03-23 05:30:01.453','HIPAA_ODS_ARCHIVE ' UNION ALL
SELECT 'SBR_SEGMENT','0','2008-03-23 05:30:01.453','HIPAA_ODS_ARCHIVE ' UNION ALL
SELECT 'SE_SEGMENT','0','2008-03-23 05:30:01.453','HIPAA_ODS_ARCHIVE ' UNION ALL
SELECT 'SLN_SEGMENT','0','2008-03-23 05:30:01.453','HIPAA_ODS_ARCHIVE ' UNION ALL
SELECT 'STC_SEGMENT','0','2008-03-23 05:30:01.453','HIPAA_ODS_ARCHIVE ' UNION ALL
SELECT 'ST_SEGMENT','0','2008-03-23 05:30:01.453','HIPAA_ODS_ARCHIVE ' UNION ALL
SELECT 'SV1_SEGMENT','0','2008-03-23 05:30:01.453','HIPAA_ODS_ARCHIVE ' UNION ALL
SELECT 'SV2_SEGMENT','0','2008-03-23 05:30:01.453','HIPAA_ODS_ARCHIVE ' UNION ALL
SELECT 'SV4_SEGMENT','0','2008-03-23 05:30:01.453','HIPAA_ODS_ARCHIVE ' UNION ALL
SELECT 'SVC_SEGMENT','0','2008-03-23 05:30:01.453','HIPAA_ODS_ARCHIVE ' UNION ALL
SELECT 'SVD_SEGMENT','0','2008-03-23 05:30:01.453','HIPAA_ODS_ARCHIVE ' UNION ALL
SELECT 'TA1_SEGMENT','0','2008-03-23 05:30:01.453','HIPAA_ODS_ARCHIVE ' UNION ALL
SELECT 'TRADING_PARTNER_CONTACT','0','2008-03-23 05:30:01.453','HIPAA_ODS_ARCHIVE ' UNION ALL
SELECT 'TRN_SEGMENT','0','2008-03-23 05:30:01.453','HIPAA_ODS_ARCHIVE ' UNION ALL
SELECT 'TS2_SEGMENT','0','2008-03-23 05:30:01.453','HIPAA_ODS_ARCHIVE ' UNION ALL
SELECT 'TS3_SEGMENT','0','2008-03-23 05:30:01.453','HIPAA_ODS_ARCHIVE ' UNION ALL
SELECT 'UM_SEGMENT','0','2008-03-23 05:30:01.453','HIPAA_ODS_ARCHIVE ' UNION ALL
SELECT 'dtproperties','0','2008-03-23 05:30:01.453','HIPAA_ODS_ARCHIVE ' UNION ALL
SELECT 'AAA_SEGMENT','0','2008-03-23 05:30:01.453','HIPAA_ODS_ARCHIVE ' UNION ALL
SELECT 'ACT_SEGMENT','0','2008-03-23 05:30:01.453','HIPAA_ODS_ARCHIVE ' UNION ALL
SELECT 'ADX_SEGMENT','0','2008-03-23 05:30:01.453','HIPAA_ODS_ARCHIVE ' UNION ALL
SELECT 'AMT_SEGMENT','0','2008-03-23 05:30:01.453','HIPAA_ODS_ARCHIVE ' UNION ALL
SELECT 'BGN_SEGMENT','0','2008-03-23 05:30:01.453','HIPAA_ODS_ARCHIVE ' UNION ALL
SELECT 'BHT_SEGMENT','0','2008-03-23 05:30:01.453','HIPAA_ODS_ARCHIVE ' UNION ALL
SELECT 'BPR_SEGMENT','0','2008-03-23 05:30:01.453','HIPAA_ODS_ARCHIVE ' UNION ALL
SELECT 'BUSINESS_EDIT_INDEX','0','2008-03-23 05:30:01.453','HIPAA_ODS_ARCHIVE ' UNION ALL
SELECT 'BUSINESS_EDIT_LOG','0','2008-03-23 05:30:01.453','HIPAA_ODS_ARCHIVE ' UNION ALL
SELECT 'BUSINESS_EDIT_MESSAGES','0','2008-03-23 05:30:01.453','HIPAA_ODS_ARCHIVE ' UNION ALL
SELECT 'BUSINESS_ERROR_LOG','0','2008-03-23 05:30:01.453','HIPAA_ODS_ARCHIVE ' UNION ALL
SELECT 'CL1_SEGMENT','61','2008-03-23 05:30:01.377','HIPAA ' UNION ALL
SELECT 'CLM_SEGMENT','3104','2008-03-23 05:30:01.377','HIPAA ' UNION ALL
SELECT 'ACT_SEGMENT','0','2008-03-23 05:30:01.377','HIPAA ' UNION ALL
SELECT 'ADX_SEGMENT','0','2008-03-23 05:30:01.377','HIPAA ' UNION ALL
SELECT 'AMT_SEGMENT','0','2008-03-23 05:30:01.377','HIPAA ' UNION ALL
SELECT 'BGN_SEGMENT','866','2008-03-23 05:30:01.377','HIPAA ' UNION ALL
SELECT 'BHT_SEGMENT','31','2008-03-23 05:30:01.377','HIPAA ' UNION ALL
SELECT 'BPR_SEGMENT','0','2008-03-23 05:30:01.377','HIPAA ' UNION ALL
SELECT 'BUSINESS_EDIT_MESSAGES','38','2008-03-23 05:30:01.377','HIPAA ' UNION ALL
SELECT 'BUSINESS_ERROR_LOG','325','2008-03-23 05:30:01.377','HIPAA ' UNION ALL
SELECT 'CAS_SEGMENT','11328','2008-03-23 05:30:01.377','HIPAA ' UNION ALL
SELECT 'CAT_SEGMENT','0','2008-03-23 05:30:01.377','HIPAA ' UNION ALL
SELECT 'CLP_SEGMENT','0','2008-03-23 05:30:01.377','HIPAA ' UNION ALL
SELECT 'CN1_SEGMENT','0','2008-03-23 05:30:01.377','HIPAA ' UNION ALL
SELECT 'COB_SEGMENT','0','2008-03-23 05:30:01.377','HIPAA ' UNION ALL
SELECT 'COMPANY_INFO','4','2008-03-23 05:30:01.377','HIPAA ' UNION ALL
SELECT 'CONTACT_INFO','10','2008-03-23 05:30:01.377','HIPAA ' UNION ALL
SELECT 'CR1_SEGMENT','0','2008-03-23 05:30:01.377','HIPAA ' UNION ALL
SELECT 'CR2_SEGMENT','0','2008-03-23 05:30:01.377','HIPAA ' UNION ALL
SELECT 'CR3_SEGMENT','0','2008-03-23 05:30:01.377','HIPAA ' UNION ALL
SELECT 'CR5_SEGMENT','0','2008-03-23 05:30:01.377','HIPAA ' UNION ALL
SELECT 'CR6_SEGMENT','0','2008-03-23 05:30:01.377','HIPAA ' UNION ALL
SELECT 'CR7_SEGMENT','0','2008-03-23 05:30:01.377','HIPAA ' UNION ALL
SELECT 'CRC_SEGMENT','0','2008-03-23 05:30:01.377','HIPAA ' UNION ALL
SELECT 'CTP_SEGMENT','0','2008-03-23 05:30:01.377','HIPAA ' UNION ALL
SELECT 'CUR_SEGMENT','0','2008-03-23 05:30:01.377','HIPAA ' UNION ALL
SELECT 'DMG_SEGMENT','648510','2008-03-23 05:30:01.377','HIPAA ' UNION ALL
SELECT 'DSB_SEGMENT','0','2008-03-23 05:30:01.377','HIPAA ' UNION ALL
SELECT 'DTM_SEGMENT','0','2008-03-23 05:30:01.377','HIPAA ' UNION ALL
SELECT 'DTP_SEGMENT','1072869','2008-03-23 05:30:01.377','HIPAA ' UNION ALL
SELECT 'EB_SEGMENT','0','2008-03-23 05:30:01.377','HIPAA ' UNION ALL
SELECT 'ENT_SEGMENT','0','2008-03-23 05:30:01.377','HIPAA ' UNION ALL
SELECT 'EQ_SEGMENT','0','2008-03-23 05:30:01.377','HIPAA ' UNION ALL
SELECT 'FRM_SEGMENT','0','2008-03-23 05:30:01.377','HIPAA ' UNION ALL
SELECT 'GE_SEGMENT','0','2008-03-23 05:30:01.377','HIPAA ' UNION ALL
SELECT 'GS_SEGMENT','238','2008-03-23 05:30:01.377','HIPAA ' UNION ALL
SELECT 'HCP_SEGMENT','4700','2008-03-23 05:30:01.377','HIPAA ' UNION ALL
SELECT 'HCR_SEGMENT','0','2008-03-23 05:30:01.377','HIPAA ' UNION ALL
SELECT 'HD_SEGMENT','653773','2008-03-23 05:30:01.377','HIPAA ' UNION ALL
SELECT 'HIPAA_LOOP','2289','2008-03-23 05:30:01.377','HIPAA ' UNION ALL
SELECT 'HIPAA_MAP_SQL_STATEMENTS','12','2008-03-23 05:30:01.377','HIPAA ' UNION ALL
SELECT 'HIPAA_OB837_XMIT_LOG','27176','2008-03-23 05:30:01.377','HIPAA ' UNION ALL
SELECT 'HIPAA_OB835_LASTRUNDATE','1','2008-03-23 05:30:01.377','HIPAA ' UNION ALL
SELECT 'HIPAA_OB837I_LASTRUNDATE','1','2008-03-23 05:30:01.377','HIPAA ' UNION ALL
SELECT 'HIPAA_OB837P_LASTRUNDATE','1','2008-03-23 05:30:01.377','HIPAA ' UNION ALL
SELECT 'HIPAA_SEGMENT_LOOKUP','95','2008-03-23 05:30:01.377','HIPAA ' UNION ALL
SELECT 'HIPAA_TPA_INSNOS','10','2008-03-23 05:30:01.377','HIPAA ' UNION ALL
SELECT 'HIPAA_TRADING_PARTNER','15','2008-03-23 05:30:01.377','HIPAA ' UNION ALL
SELECT 'HIPAA_TRANSACTIONS','900','2008-03-23 05:30:01.377','HIPAA ' UNION ALL
SELECT 'HIPAA_TRANSACTION_LOOKUP','13','2008-03-23 05:30:01.377','HIPAA ' UNION ALL
SELECT 'HIPAA_TRANSACTION_SEGMENT_LOOKUP','116','2008-03-23 05:30:01.377','HIPAA ' UNION ALL
SELECT 'HI_SEGMENT','3104','2008-03-23 05:30:01.377','HIPAA ' UNION ALL
SELECT 'HLH_SEGMENT','0','2008-03-23 05:30:01.377','HIPAA ' UNION ALL
SELECT 'HL_SEGMENT','3840','2008-03-23 05:30:01.377','HIPAA ' UNION ALL
SELECT 'HSD_SEGMENT','0','2008-03-23 05:30:01.377','HIPAA ' UNION ALL
SELECT 'ICM_SEGMENT','0','2008-03-23 05:30:01.377','HIPAA ' UNION ALL
SELECT 'IDC_SEGMENT','0','2008-03-23 05:30:01.377','HIPAA ' UNION ALL
SELECT 'IEA_SEGMENT','0','2008-03-23 05:30:01.377','HIPAA ' UNION ALL
SELECT 'III_SEGMENT','0','2008-03-23 05:30:01.377','HIPAA ' UNION ALL
SELECT 'INS_SEGMENT','653811','2008-03-23 05:30:01.377','HIPAA ' UNION ALL
SELECT 'HIPAA_OB837_LastRunDate','723','2008-03-23 05:30:01.377','HIPAA ' UNION ALL
SELECT 'LX_SEGMENT','4716','2008-03-23 05:30:01.377','HIPAA ' UNION ALL
SELECT 'MEA_SEGMENT','0','2008-03-23 05:30:01.377','HIPAA ' UNION ALL
SELECT 'MIA_SEGMENT','0','2008-03-23 05:30:01.377','HIPAA ' UNION ALL
SELECT 'MOA_SEGMENT','0','2008-03-23 05:30:01.377','HIPAA ' UNION ALL
SELECT 'MSG_SEGMENT','0','2008-03-23 05:30:01.377','HIPAA ' UNION ALL
SELECT 'N1_SEGMENT','170','2008-03-23 05:30:01.377','HIPAA ' UNION ALL
SELECT 'N2_SEGMENT','0','2008-03-23 05:30:01.377','HIPAA ' UNION ALL
SELECT 'N3_SEGMENT','658061','2008-03-23 05:30:01.377','HIPAA ' UNION ALL
SELECT 'N4_SEGMENT','658150','2008-03-23 05:30:01.377','HIPAA ' UNION ALL
SELECT 'NM1_SEGMENT','665516','2008-03-23 05:30:01.377','HIPAA ' UNION ALL
SELECT 'dtproperties','0','2008-03-23 05:30:01.377','HIPAA ' UNION ALL
SELECT 'NTE_SEGMENT','0','2008-03-23 05:30:01.377','HIPAA ' UNION ALL
SELECT 'OI_SEGMENT','3082','2008-03-23 05:30:01.377','HIPAA ' UNION ALL
SELECT 'PAT_SEGMENT','863','2008-03-23 05:30:01.377','HIPAA ' UNION ALL
SELECT 'PER_SEGMENT','360085','2008-03-23 05:30:01.377','HIPAA ' UNION ALL
SELECT 'PLA_SEGMENT','0','2008-03-23 05:30:01.377','HIPAA ' UNION ALL
SELECT 'PLB_SEGMENT','0','2008-03-23 05:30:01.377','HIPAA ' UNION ALL
SELECT 'ISA_SEGMENT','238','2008-03-23 05:30:01.377','HIPAA ' UNION ALL
SELECT 'IT1_SEGMENT','0','2008-03-23 05:30:01.377','HIPAA ' UNION ALL
SELECT 'K3_SEGMENT','0','2008-03-23 05:30:01.377','HIPAA ' UNION ALL
SELECT 'LE_SEGMENT','0','2008-03-23 05:30:01.377','HIPAA ' UNION ALL
SELECT 'LIN_SEGMENT','0','2008-03-23 05:30:01.377','HIPAA ' UNION ALL
SELECT 'LQ_SEGMENT','0','2008-03-23 05:30:01.377','HIPAA ' UNION ALL
SELECT 'LS_SEGMENT','0','2008-03-23 05:30:01.377','HIPAA ' UNION ALL
SELECT 'LUI_SEGMENT','0','2008-03-23 05:30:01.377','HIPAA ' UNION ALL
SELECT 'PRV_SEGMENT','1376','2008-03-23 05:30:01.377','HIPAA ' UNION ALL
SELECT 'PS1_SEGMENT','0','2008-03-23 05:30:01.377','HIPAA ' UNION ALL
SELECT 'PWK_SEGMENT','0','2008-03-23 05:30:01.377','HIPAA ' UNION ALL
SELECT 'QTY_SEGMENT','0','2008-03-23 05:30:01.377','HIPAA ' UNION ALL
SELECT 'REF_SEGMENT','1312229','2008-03-23 05:30:01.377','HIPAA ' UNION ALL
SELECT 'RMR_SEGMENT','0','2008-03-23 05:30:01.377','HIPAA ' UNION ALL
SELECT 'SBR_SEGMENT','4606','2008-03-23 05:30:01.377','HIPAA ' UNION ALL
SELECT 'SE_SEGMENT','0','2008-03-23 05:30:01.377','HIPAA ' UNION ALL
SELECT 'SLN_SEGMENT','0','2008-03-23 05:30:01.377','HIPAA ' UNION ALL
SELECT 'STC_SEGMENT','0','2008-03-23 05:30:01.377','HIPAA ' UNION ALL
SELECT 'ST_SEGMENT','898','2008-03-23 05:30:01.377','HIPAA ' UNION ALL
SELECT 'SV1_SEGMENT','3992','2008-03-23 05:30:01.377','HIPAA ' UNION ALL
SELECT 'SV2_SEGMENT','160','2008-03-23 05:30:01.377','HIPAA ' UNION ALL
SELECT 'SV4_SEGMENT','0','2008-03-23 05:30:01.377','HIPAA ' UNION ALL
SELECT 'SVC_SEGMENT','0','2008-03-23 05:30:01.377','HIPAA ' UNION ALL
SELECT 'SVD_SEGMENT','4672','2008-03-23 05:30:01.377','HIPAA ' UNION ALL
SELECT 'TA1_SEGMENT','0','2008-03-23 05:30:01.377','HIPAA ' UNION ALL
SELECT 'TRADING_PARTNER_CONTACT','0','2008-03-23 05:30:01.377','HIPAA ' UNION ALL
SELECT 'TRN_SEGMENT','0','2008-03-23 05:30:01.377','HIPAA ' UNION ALL
SELECT 'TS2_SEGMENT','0','2008-03-23 05:30:01.377','HIPAA ' UNION ALL
SELECT 'TS3_SEGMENT','0','2008-03-23 05:30:01.377','HIPAA ' UNION ALL
SELECT 'UM_SEGMENT','0','2008-03-23 05:30:01.377','HIPAA ' UNION ALL
SELECT 'TRLOG_ARCHIVE','627741','2008-03-23 05:30:01.377','HIPAA ' UNION ALL
SELECT 'AAA_SEGMENT','0','2008-03-23 05:30:01.377','HIPAA ' UNION ALL
SELECT 'Location_tb','0','2008-03-23 05:30:01.313','GENTRAN ' UNION ALL
SELECT 'Lookup_tb','0','2008-03-23 05:30:01.313','GENTRAN ' UNION ALL
SELECT 'Partner_tb','5','2008-03-23 05:30:01.313','GENTRAN ' UNION ALL
SELECT 'Relationship_tb','11','2008-03-23 05:30:01.313','GENTRAN ' UNION ALL
SELECT 'Schedule_tb','2','2008-03-23 05:30:01.313','GENTRAN ' UNION ALL
SELECT 'Splitter_tb','10','2008-03-23 05:30:01.313','GENTRAN ' UNION ALL
SELECT 'SystemImport_tb','0','2008-03-23 05:30:01.313','GENTRAN ' UNION ALL
SELECT 'Template_tb','89','2008-03-23 05:30:01.313','GENTRAN ' UNION ALL
SELECT 'Track_tb','5','2008-03-23 05:30:01.313','GENTRAN ' UNION ALL
SELECT 'User_tb','5','2008-03-23 05:30:01.313','GENTRAN ' UNION ALL
SELECT 'MailboxConfig_tb','3','2008-03-23 05:30:01.313','GENTRAN ' UNION ALL
SELECT 'ExtData_tb','45','2008-03-23 05:30:01.313','GENTRAN ' UNION ALL
SELECT 'ExtDataXref_tb','1','2008-03-23 05:30:01.313','GENTRAN ' UNION ALL
SELECT 'AuditSourceID_tb','8','2008-03-23 05:30:01.313','GENTRAN ' UNION ALL
SELECT 'AuditComponentID_tb','36','2008-03-23 05:30:01.313','GENTRAN ' UNION ALL
SELECT 'AuditMsg_tb','977','2008-03-23 05:30:01.313','GENTRAN ' UNION ALL
SELECT 'DataAuditType_tb','7','2008-03-23 05:30:01.313','GENTRAN ' UNION ALL
SELECT 'ProcAuditLog_tb','657','2008-03-23 05:30:01.313','GENTRAN ' UNION ALL
SELECT 'DataAuditLog_tb','77','2008-03-23 05:30:01.313','GENTRAN ' UNION ALL
SELECT 'NotifyLog_tb','0','2008-03-23 05:30:01.313','GENTRAN ' UNION ALL
SELECT 'Operators_tb','0','2008-03-23 05:30:01.313','GENTRAN ' UNION ALL
SELECT 'Notify_tb','0','2008-03-23 05:30:01.313','GENTRAN ' UNION ALL
SELECT 'NotifyAction_tb','0','2008-03-23 05:30:01.313','GENTRAN ' UNION ALL
SELECT 'AddressBook_tb','0','2008-03-23 05:30:01.313','GENTRAN ' UNION ALL
SELECT 'Attachment_tb','9','2008-03-23 05:30:01.313','GENTRAN ' UNION ALL
SELECT 'File_tb','7','2008-03-23 05:30:01.313','GENTRAN ' UNION ALL
SELECT 'DistributionList_tb','0','2008-03-23 05:30:01.313','GENTRAN ' UNION ALL
SELECT 'Mailbox_tb','5','2008-03-23 05:30:01.313','GENTRAN ' UNION ALL
SELECT 'Message_tb','9','2008-03-23 05:30:01.313','GENTRAN ' UNION ALL
SELECT 'Recipient_tb','4','2008-03-23 05:30:01.313','GENTRAN ' UNION ALL
SELECT 'DeliveryRule_tb','0','2008-03-23 05:30:01.313','GENTRAN ' UNION ALL
SELECT 'SpoolQueue_tb','0','2008-03-23 05:30:01.313','GENTRAN ' UNION ALL
SELECT 'Tracking_tb','0','2008-03-23 05:30:01.313','GENTRAN ' UNION ALL
SELECT 'DeliveryQuery_tb','0','2008-03-23 05:30:01.313','GENTRAN ' UNION ALL
SELECT 'dtproperties','0','2008-03-23 05:30:01.313','GENTRAN ' UNION ALL
SELECT 'AppDbInformation_tb','1','2008-03-23 05:30:01.313','GENTRAN ' UNION ALL
SELECT 'CrossReference_tb','6','2008-03-23 05:30:01.313','GENTRAN ' UNION ALL
SELECT 'Document_tb','14','2008-03-23 05:30:01.313','GENTRAN ' UNION ALL
SELECT 'Exporter_tb','5','2008-03-23 05:30:01.313','GENTRAN ' UNION ALL
SELECT 'FunctionalGroupControl_tb','10','2008-03-23 05:30:01.313','GENTRAN ' UNION ALL
SELECT 'GenericEnvelopeSegment_tb','24','2008-03-23 05:30:01.313','GENTRAN ' UNION ALL
SELECT 'Group_tb','1','2008-03-23 05:30:01.313','GENTRAN ' UNION ALL
SELECT 'Interchange_tb','1','2008-03-23 05:30:01.313','GENTRAN ' UNION ALL
SELECT 'InterchangeControl_tb','11','2008-03-23 05:30:01.313','GENTRAN ' UNION ALL
SELECT 'dtproperties','0','2008-03-23 05:30:01.250','EC_UTILITY' UNION ALL
SELECT 'ACK997','0','2008-03-23 05:30:01.250','EC_UTILITY' UNION ALL
SELECT 'ACKTA1','0','2008-03-23 05:30:01.250','EC_UTILITY' UNION ALL
SELECT 'ARCHFILE','7417','2008-03-23 05:30:01.250','EC_UTILITY' UNION ALL
SELECT 'COMMCH','0','2008-03-23 05:30:01.250','EC_UTILITY' UNION ALL
SELECT 'ERROR','0','2008-03-23 05:30:01.250','EC_UTILITY' UNION ALL
SELECT 'FGID','3','2008-03-23 05:30:01.250','EC_UTILITY' UNION ALL
SELECT 'FGWIDTH','47','2008-03-23 05:30:01.250','EC_UTILITY' UNION ALL
SELECT 'MBOX','29','2008-03-23 05:30:01.250','EC_UTILITY' UNION ALL
SELECT 'PROCFILE','3059','2008-03-23 05:30:01.250','EC_UTILITY' UNION ALL
SELECT 'PROCNAME','67','2008-03-23 05:30:01.250','EC_UTILITY' UNION ALL
SELECT 'PWD_GEN','0','2008-03-23 05:30:01.250','EC_UTILITY' UNION ALL
SELECT 'QCONDITION','0','2008-03-23 05:30:01.250','EC_UTILITY' UNION ALL
SELECT 'QFIND','0','2008-03-23 05:30:01.250','EC_UTILITY' UNION ALL
SELECT 'RUN_ID','1','2008-03-23 05:30:01.250','EC_UTILITY' UNION ALL
SELECT 'SYS_SECU','1','2008-03-23 05:30:01.250','EC_UTILITY' UNION ALL
SELECT 'SYSUSER','1','2008-03-23 05:30:01.250','EC_UTILITY' UNION ALL
SELECT 'TEMPPROC','0','2008-03-23 05:30:01.250','EC_UTILITY' UNION ALL
SELECT 'TP','31','2008-03-23 05:30:01.250','EC_UTILITY' UNION ALL
SELECT 'TRADSTAT','82','2008-03-23 05:30:01.250','EC_UTILITY' UNION ALL
SELECT 'TRLOG','1147084','2008-03-23 05:30:01.250','EC_UTILITY' UNION ALL
SELECT 'WIXSET','2','2008-03-23 05:30:01.250','EC_UTILITY' UNION ALL
SELECT 'RUN_ID_SCRIPTS','1663','2008-03-23 05:30:01.250','EC_UTILITY' UNION ALL
SELECT 'RUN_ID_EDI','1','2008-03-23 05:30:01.250','EC_UTILITY' UNION ALL
SELECT 'trading_partners','30','2008-03-23 05:30:01.250','EC_UTILITY' UNION ALL
SELECT 'DBSizeUsed','84','2008-03-23 05:30:01.220','DBMaint ' UNION ALL
SELECT 'DBGrowthRate','54','2008-03-23 05:30:01.220','DBMaint ' UNION ALL
SELECT 'DB_Setup','54','2008-03-23 05:30:01.220','DBMaint ' UNION ALL
SELECT 'DataRowCounts','2727','2008-03-23 05:30:01.220','DBMaint ' UNION ALL
SELECT 'dtproperties','0','2008-03-23 05:30:01.220','DBMaint ' UNION ALL
SELECT 'CPSdm081m','0','2008-03-23 05:30:01.190','CPS_TEMP' UNION ALL
SELECT 'CPSdm009','146612','2008-03-23 05:30:01.190','CPS_TEMP' UNION ALL
SELECT 'CPSdm041','353','2008-03-23 05:30:01.190','CPS_TEMP' UNION ALL
SELECT 'CPSdm020m','3516','2008-03-23 05:30:01.190','CPS_TEMP' UNION ALL
SELECT 'dtproperties','0','2008-03-23 05:30:01.190','CPS_TEMP' UNION ALL
SELECT 'CPSdm001','468731','2008-03-23 05:30:01.190','CPS_TEMP' UNION ALL
SELECT 'TempCPSdm030','0','2008-03-23 05:30:01.190','CPS_TEMP' UNION ALL
SELECT 'CPSdm003','778607','2008-03-23 05:30:01.190','CPS_TEMP' UNION ALL
SELECT 'CPSdm036A','3706','2008-03-23 05:30:01.190','CPS_TEMP' UNION ALL
SELECT 'CPSdm010','10533','2008-03-23 05:30:01.190','CPS_TEMP' UNION ALL
SELECT 'CPSdm011','157796','2008-03-23 05:30:01.190','CPS_TEMP' UNION ALL
SELECT 'CPSdm019','5543','2008-03-23 05:30:01.190','CPS_TEMP' UNION ALL
SELECT 'CPSdm021m','23350','2008-03-23 05:30:01.190','CPS_TEMP' UNION ALL
SELECT 'CPSdm023','251897','2008-03-23 05:30:01.190','CPS_TEMP' UNION ALL
SELECT 'CPSdm004','2308885','2008-03-23 05:30:01.190','CPS_TEMP' UNION ALL
SELECT 'DM036A','0','2008-03-23 05:30:01.190','CPS_TEMP' UNION ALL
SELECT 'CPSdm030','2581120','2008-03-23 05:30:01.190','CPS_TEMP' UNION ALL
SELECT 'ccelook','961','2008-03-23 05:30:01.190','CPS_TEMP' UNION ALL
SELECT 'CPSdm016','1587','2008-03-23 05:30:01.190','CPS_TEMP' UNION ALL
SELECT 'UserList','263','2008-03-23 05:30:01.190','CPS_TEMP' UNION ALL
SELECT 'CPSdm090','2078','2008-03-23 05:30:01.190','CPS_TEMP' UNION ALL
SELECT 'CPSdm081','0','2008-03-23 05:30:01.190','CPS_TEMP' UNION ALL
SELECT 'CPSdm019m','244020','2008-03-23 05:30:01.190','CPS_TEMP' UNION ALL
SELECT 'CPSdm030L','1539867','2008-03-23 05:30:01.190','CPS_TEMP' UNION ALL
SELECT 'CPSdm030E','876752','2008-03-23 05:30:01.190','CPS_TEMP' UNION ALL
SELECT 'CPSTrigger','1','2008-03-23 05:30:01.190','CPS_TEMP' UNION ALL
SELECT 'cppSyncLog','44','2008-03-23 05:30:01.190','CPS_TEMP' UNION ALL
SELECT 'CPSdm020','3424','2008-03-23 05:30:01.190','CPS_TEMP' UNION ALL
SELECT 'CPsdm021','8527','2008-03-23 05:30:01.190','CPS_TEMP' UNION ALL
SELECT 'Archive_CPPCDW_Benefit','933001','2008-03-23 05:30:01.140','Claims Data Warehouse ' UNION ALL
SELECT 'Phase2DBRestoreTesting_Second','4','2008-03-23 05:30:01.140','Claims Data Warehouse ' UNION ALL
SELECT 'CPPCDW_Gra','1357','2008-03-23 05:30:01.140','Claims Data Warehouse ' UNION ALL
SELECT 'InsertNetValuesLog','1727','2008-03-23 05:30:01.140','Claims Data Warehouse ' UNION ALL
SELECT 'tempCokeIngenix_10012006_12312006','4557','2008-03-23 05:30:01.140','Claims Data Warehouse ' UNION ALL
SELECT 'DUP_DUP_DEC07','3363','2008-03-23 05:30:01.140','Claims Data Warehouse ' UNION ALL
SELECT 'OB837ToBeProcessed','124','2008-03-23 05:30:01.140','Claims Data Warehouse ' UNION ALL
SELECT 'Archive_CPPCDW_Gra','742459','2008-03-23 05:30:01.140','Claims Data Warehouse ' UNION ALL
SELECT 'CPPCDW_Line_Item','3015','2008-03-23 05:30:01.140','Claims Data Warehouse ' UNION ALL
SELECT 'CDW','1911537','2008-03-23 05:30:01.140','Claims Data Warehouse ' UNION ALL
SELECT 'CPPCDW_Benefit','1275','2008-03-23 05:30:01.140','Claims Data Warehouse ' UNION ALL
SELECT 'jimcdwmil','1757','2008-03-23 05:30:01.140','Claims Data Warehouse ' UNION ALL
SELECT 'jimmiltxt','1390','2008-03-23 05:30:01.140','Claims Data Warehouse ' UNION ALL
SELECT 'ManojTemp','696','2008-03-23 05:30:01.140','Claims Data Warehouse ' UNION ALL
SELECT 'Temp Import OLD_CHGINVNO','648333','2008-03-23 05:30:01.140','Claims Data Warehouse ' UNION ALL
SELECT 'DuPont Claims','3363','2008-03-23 05:30:01.140','Claims Data Warehouse ' UNION ALL
SELECT 'CPPCDW_Client','1649','2008-03-23 05:30:01.140','Claims Data Warehouse ' UNION ALL
SELECT 'CPPToSharepointKeys','1','2008-03-23 05:30:01.140','Claims Data Warehouse ' UNION ALL
SELECT 'jimMilNotSent','222','2008-03-23 05:30:01.140','Claims Data Warehouse ' UNION ALL
SELECT 'CPPWorklifeGraArchive','9418','2008-03-23 05:30:01.140','Claims Data Warehouse ' UNION ALL
SELECT 'Archive_CPPCDW_Client','975626','2008-03-23 05:30:01.140','Claims Data Warehouse ' UNION ALL
SELECT 'DUP_DUP_JUNE07','3815','2008-03-23 05:30:01.140','Claims Data Warehouse ' UNION ALL
SELECT 'TempDuPontChecks','1877','2008-03-23 05:30:01.140','Claims Data Warehouse ' UNION ALL
SELECT 'Jimmilnotsentsingle','142','2008-03-23 05:30:01.140','Claims Data Warehouse ' UNION ALL
SELECT 'TempDupsINdm030forKenny','220445','2008-03-23 05:30:01.140','Claims Data Warehouse ' UNION ALL
SELECT 'DUP_DUP_JAN08','5382','2008-03-23 05:30:01.140','Claims Data Warehouse ' UNION ALL
SELECT 'EJ_Eligibility','57586','2008-03-23 05:30:01.140','Claims Data Warehouse ' UNION ALL
SELECT 'CPPCDW_Reason','1048','2008-03-23 05:30:01.140','Claims Data Warehouse ' UNION ALL
SELECT 'tempEJMedstat_12012006_02112007','912','2008-03-23 05:30:01.140','Claims Data Warehouse ' UNION ALL
SELECT 'Archive_CPPCDW_Reason','1157349','2008-03-23 05:30:01.140','Claims Data Warehouse ' UNION ALL
SELECT 'EJ_GENDER','200','2008-03-23 05:30:01.140','Claims Data Warehouse ' UNION ALL
SELECT 'temp827cdw','2311','2008-03-23 05:30:01.140','Claims Data Warehouse ' UNION ALL
SELECT 'OB837Temp','126','2008-03-23 05:30:01.140','Claims Data Warehouse ' UNION ALL
SELECT 'Claims_Job_Table','581','2008-03-23 05:30:01.140','Claims Data Warehouse ' UNION ALL
SELECT 'EMRNO_TRANSLATION','8309','2008-03-23 05:30:01.140','Claims Data Warehouse ' UNION ALL
SELECT 'tempDuPontDuPont01012007_01312007','3826','2008-03-23 05:30:01.140','Claims Data Warehouse ' UNION ALL
SELECT 'Claims_Log_Table','499963','2008-03-23 05:30:01.140','Claims Data Warehouse ' UNION ALL
SELECT 'OB837Errors','1241','2008-03-23 05:30:01.140','Claims Data Warehouse ' UNION ALL
SELECT '837cdw','56','2008-03-23 05:30:01.140','Claims Data Warehouse ' UNION ALL
SELECT 'CDW_TEST','3107','2008-03-23 05:30:01.140','Claims Data Warehouse ' UNION ALL
SELECT 'OB837Archive','34623','2008-03-23 05:30:01.140','Claims Data Warehouse ' UNION ALL
SELECT 'tempEJMedstat_10012005_11302006','8198','2008-03-23 05:30:01.140','Claims Data Warehouse ' UNION ALL
SELECT 'CrackerBarrel','1798','2008-03-23 05:30:01.140','Claims Data Warehouse ' UNION ALL
SELECT 'tempEJMedstat_12012006_12312006_TO_CONCAT_05_06','283','2008-03-23 05:30:01.140','Claims Data Warehouse ' UNION ALL
SELECT 'ob837jim','205','2008-03-23 05:30:01.140','Claims Data Warehouse ' UNION ALL
SELECT 'clu_claim_data_warehouse','1218735','2008-03-23 05:30:01.140','Claims Data Warehouse ' UNION ALL
SELECT 'TCTable','120','2008-03-23 05:30:01.140','Claims Data Warehouse ' UNION ALL
SELECT 'CRACKER_BARREL_BACKOUT_08142007','1798','2008-03-23 05:30:01.140','Claims Data Warehouse ' UNION ALL
SELECT 'DUP_DUP_FEB08','4259','2008-03-23 05:30:01.140','Claims Data Warehouse ' UNION ALL
SELECT 'test_cppcdw_line_item','37','2008-03-23 05:30:01.140','Claims Data Warehouse ' UNION ALL
SELECT 'test_cppcdw_benefit','1349','2008-03-23 05:30:01.140','Claims Data Warehouse ' UNION ALL
SELECT 'temp837cdw','642','2008-03-23 05:30:01.140','Claims Data Warehouse ' UNION ALL
SELECT 'DUP_DUP_JUL07','4465','2008-03-23 05:30:01.140','Claims Data Warehouse ' UNION ALL
SELECT 'test1_cppcdw_line_item','2','2008-03-23 05:30:01.140','Claims Data Warehouse ' UNION ALL
SELECT 'tempDuPontIngenix_03012007_03312007','4280','2008-03-23 05:30:01.140','Claims Data Warehouse ' UNION ALL
SELECT 'EJ_ACCUM_UHC_WEEKLY_CHECK_NULLS','545','2008-03-23 05:30:01.140','Claims Data Warehouse ' UNION ALL
SELECT 'tempEJ_Medstat_10012005_12312006','8481','2008-03-23 05:30:01.140','Claims Data Warehouse ' UNION ALL
SELECT 'CurTest_cppcdw_benefit','4230','2008-03-23 05:30:01.140','Claims Data Warehouse ' UNION ALL
SELECT 'EMRNO_TRANSLATION_NEW','5927','2008-03-23 05:30:01.140','Claims Data Warehouse ' UNION ALL
SELECT 'tempDuPontIngenix_12012006_01312007','4392','2008-03-23 05:30:01.140','Claims Data Warehouse ' UNION ALL
SELECT 'Claims_Data_warehouse','755524','2008-03-23 05:30:01.140','Claims Data Warehouse ' UNION ALL
SELECT 'Jimproviders','21645','2008-03-23 05:30:01.140','Claims Data Warehouse ' UNION ALL
SELECT 'Copy_CDW_04122007','1248645','2008-03-23 05:30:01.140','Claims Data Warehouse ' UNION ALL
SELECT 'MMPerf','5','2008-03-23 05:30:01.140','Claims Data Warehouse ' UNION ALL
SELECT 'MMTemp','5','2008-03-23 05:30:01.140','Claims Data Warehouse ' UNION ALL
SELECT 'DUP_DUP_MAR07','3138','2008-03-23 05:30:01.140','Claims Data Warehouse ' UNION ALL
SELECT 'CDW_COPY','1502555','2008-03-23 05:30:01.140','Claims Data Warehouse ' UNION ALL
SELECT 'TEMP847','0','2008-03-23 05:30:01.140','Claims Data Warehouse ' UNION ALL
SELECT 'CDW_TEMP_A_08232007','161','2008-03-23 05:30:01.140','Claims Data Warehouse ' UNION ALL
SELECT 'TEMPjim','1','2008-03-23 05:30:01.140','Claims Data Warehouse ' UNION ALL
SELECT 'CDW_TEMP_B_08232007','427','2008-03-23 05:30:01.140','Claims Data Warehouse ' UNION ALL
SELECT 'sent837claims','116601','2008-03-23 05:30:01.140','Claims Data Warehouse ' UNION ALL
SELECT 'CDW_COPY_08232007','1502555','2008-03-23 05:30:01.140','Claims Data Warehouse ' UNION ALL
SELECT 'ob837dailyclaims','119','2008-03-23 05:30:01.140','Claims Data Warehouse ' UNION ALL
SELECT 'ctype','46','2008-03-23 05:30:01.140','Claims Data Warehouse ' UNION ALL
SELECT 'EJ_Adjustments','695','2008-03-23 05:30:01.140','Claims Data Warehouse ' UNION ALL
SELECT 'ob837temptest','139','2008-03-23 05:30:01.140','Claims Data Warehouse ' UNION ALL
SELECT 'tempDuPontIngenix_01012007_01312007','3826','2008-03-23 05:30:01.140','Claims Data Warehouse ' UNION ALL
SELECT 'ob837tobeprocessedtest','139','2008-03-23 05:30:01.140','Claims Data Warehouse ' UNION ALL
SELECT 'copy_claimsjobEJUHC_051807','1','2008-03-23 05:30:01.140','Claims Data Warehouse ' UNION ALL
SELECT 'tempDuPontIngenix_12012006_12312006','2169','2008-03-23 05:30:01.140','Claims Data Warehouse ' UNION ALL
SELECT 'ob837temptest43claims','43','2008-03-23 05:30:01.140','Claims Data Warehouse ' UNION ALL
SELECT 'DUP_DUP_AUG07','3722','2008-03-23 05:30:01.140','Claims Data Warehouse ' UNION ALL
SELECT 'ob837emailclaims','93','2008-03-23 05:30:01.140','Claims Data Warehouse ' UNION ALL
SELECT 'MILA_TEMP','165','2008-03-23 05:30:01.140','Claims Data Warehouse ' UNION ALL
SELECT 'Archive_CPPCDW_Provider','620027','2008-03-23 05:30:01.140','Claims Data Warehouse ' UNION ALL
SELECT 'CPPCDW_Provider','1080','2008-03-23 05:30:01.140','Claims Data Warehouse ' UNION ALL
SELECT 'EJ_20061201_20070111','960','2008-03-23 05:30:01.140','Claims Data Warehouse ' UNION ALL
SELECT 'DUP_DUP_SEP07','4195','2008-03-23 05:30:01.140','Claims Data Warehouse ' UNION ALL
SELECT 'Copy_CPPCDW_Provider','1394','2008-03-23 05:30:01.140','Claims Data Warehouse ' UNION ALL
SELECT 'tempContMedstat_10012006_12312006','7504','2008-03-23 05:30:01.140','Claims Data Warehouse ' UNION ALL
SELECT 'cdw_for_MCD','677','2008-03-23 05:30:01.140','Claims Data Warehouse ' UNION ALL
SELECT 'MEE_','170','2008-03-23 05:30:01.140','Claims Data Warehouse ' UNION ALL
SELECT 'MEE','120','2008-03-23 05:30:01.140','Claims Data Warehouse ' UNION ALL
SELECT 'DUP_DUP_OCT07','5060','2008-03-23 05:30:01.140','Claims Data Warehouse ' UNION ALL
SELECT 'temp_DuPont_DuPont_12012006_12312006_DIST','2173','2008-03-23 05:30:01.140','Claims Data Warehouse ' UNION ALL
SELECT 'ob837CPPtoHipaa','83','2008-03-23 05:30:01.140','Claims Data Warehouse ' UNION ALL
SELECT 'BACKFILL','1991','2008-03-23 05:30:01.140','Claims Data Warehouse ' UNION ALL
SELECT 'temp_DuPont_12012006_12312006','1421','2008-03-23 05:30:01.140','Claims Data Warehouse ' UNION ALL
SELECT 'PAID_DATE_BACKFILL','25812','2008-03-23 05:30:01.140','Claims Data Warehouse ' UNION ALL
SELECT 'ob837archive_copy','2163','2008-03-23 05:30:01.140','Claims Data Warehouse ' UNION ALL
SELECT 'Continental Paid Dates','7994','2008-03-23 05:30:01.140','Claims Data Warehouse ' UNION ALL
SELECT 'Results','1422','2008-03-23 05:30:01.140','Claims Data Warehouse ' UNION ALL
SELECT 'tempEjMedstat_12012006_12312006','268','2008-03-23 05:30:01.140','Claims Data Warehouse ' UNION ALL
SELECT 'dtproperties','0','2008-03-23 05:30:01.140','Claims Data Warehouse ' UNION ALL
SELECT 'CDW_Adj','14639','2008-03-23 05:30:01.140','Claims Data Warehouse ' UNION ALL
SELECT 'tempclaimtypejim','21','2008-03-23 05:30:01.140','Claims Data Warehouse ' UNION ALL
SELECT 'DUP_DUP_APR07','4135','2008-03-23 05:30:01.140','Claims Data Warehouse ' UNION ALL
SELECT 'DUP_DUP_FEB07','4801','2008-03-23 05:30:01.140','Claims Data Warehouse ' UNION ALL
SELECT 'cdwmcdtestclaims','253','2008-03-23 05:30:01.140','Claims Data Warehouse ' UNION ALL
SELECT 'REPAIR_05_16_07','1147','2008-03-23 05:30:01.140','Claims Data Warehouse ' UNION ALL
SELECT 'copy_claimslogEJUHC_051807','26','2008-03-23 05:30:01.140','Claims Data Warehouse ' UNION ALL
SELECT 'tempDuPontIngenix_02012007_02282007','6732','2008-03-23 05:30:01.140','Claims Data Warehouse ' UNION ALL
SELECT '0111EJ_UHC','657','2008-03-23 05:30:01.140','Claims Data Warehouse ' UNION ALL
SELECT '0124EJ_UHC','188','2008-03-23 05:30:01.140','Claims Data Warehouse ' UNION ALL
SELECT 'EJ_Well','4','2008-03-23 05:30:01.140','Claims Data Warehouse ' UNION ALL
SELECT 'MiwaukeeClaimstxt20070319','2007','2008-03-23 05:30:01.140','Claims Data Warehouse ' UNION ALL
SELECT 'CDW_DUPS_OLD','6643','2008-03-23 05:30:01.140','Claims Data Warehouse ' UNION ALL
SELECT 'milwaukee','909','2008-03-23 05:30:01.140','Claims Data Warehouse ' UNION ALL
SELECT 'CDW_DUPS_OLD_ALL','6643','2008-03-23 05:30:01.140','Claims Data Warehouse ' UNION ALL
SELECT 'CDW_DUPS_OLD_ALL_COPY','13306','2008-03-23 05:30:01.140','Claims Data Warehouse ' UNION ALL
SELECT 'Phase2DBRestoreTesting','3','2008-03-23 05:30:01.140','Claims Data Warehouse ' UNION ALL
SELECT 'Archive_CPPCDW_Line_Item','2101905','2008-03-23 05:30:01.140','Claims Data Warehouse ' UNION ALL
SELECT 'templistofclaims','935','2008-03-23 05:30:01.140','Claims Data Warehouse ' UNION ALL
SELECT 'test','3','2008-03-23 05:30:01.140','Claims Data Warehouse ' UNION ALL
SELECT 'DUP_DUP_NOV07','3953','2008-03-23 05:30:01.140','Claims Data Warehouse ' UNION ALL
SELECT 'testtable','3','2008-03-23 05:30:01.140','Claims Data Warehouse ' UNION ALL
SELECT 'DUP_DUP_MAY07','6157','2008-03-23 05:30:01.140','Claims Data Warehouse ' UNION ALL
SELECT 'CDW_UHC_NEGATIVE_TEST','392','2008-03-23 05:30:01.140','Claims Data Warehouse ' UNION ALL
SELECT 'OB837dupclaims','148','2008-03-23 05:30:01.140','Claims Data Warehouse ' UNION ALL
SELECT 'dtproperties','0','2008-03-23 05:30:01.110','CE_STAGE' UNION ALL
SELECT 'CMS_InfoObjects3','1550','2008-03-23 05:30:01.110','CE_STAGE' UNION ALL
SELECT 'CMS_Aliases3','569','2008-03-23 05:30:01.110','CE_STAGE' UNION ALL
SELECT 'CMS_IdNumbers3','2','2008-03-23 05:30:01.110','CE_STAGE' UNION ALL
SELECT 'CMS_VersionInfo','1','2008-03-23 05:30:01.110','CE_STAGE' UNION ALL
SELECT 'CMS_InfoObjects3','3850','2008-03-23 05:30:01.080','CE_PROD ' UNION ALL
SELECT 'CMS_Aliases3','589','2008-03-23 05:30:01.080','CE_PROD ' UNION ALL
SELECT 'CMS_IdNumbers3','2','2008-03-23 05:30:01.080','CE_PROD ' UNION ALL
SELECT 'CMS_VersionInfo','1','2008-03-23 05:30:01.080','CE_PROD ' UNION ALL
SELECT 'dtproperties','0','2008-03-23 05:30:01.080','CE_PROD ' UNION ALL
SELECT 'CMS_AUDITTABLE','31607','2008-03-23 05:30:01.000','CE_AUDIT' UNION ALL
SELECT 'SYS_SECU','1','2008-03-16 05:30:01.777','UT_GATEWAY' UNION ALL
SELECT 'TEMPPROC','0','2008-03-16 05:30:01.777','UT_GATEWAY' UNION ALL
SELECT 'TP','2','2008-03-16 05:30:01.777','UT_GATEWAY' UNION ALL
SELECT 'TRADSTAT','13','2008-03-16 05:30:01.777','UT_GATEWAY' UNION ALL
SELECT 'TRLOG','0','2008-03-16 05:30:01.777','UT_GATEWAY' UNION ALL
SELECT 'WIXSET','2','2008-03-16 05:30:01.777','UT_GATEWAY' UNION ALL
SELECT 'dtproperties','0','2008-03-16 05:30:01.777','UT_GATEWAY' UNION ALL
SELECT 'ARCHFILE','23','2008-03-16 05:30:01.777','UT_GATEWAY' UNION ALL
SELECT 'COMMCH','0','2008-03-16 05:30:01.777','UT_GATEWAY' UNION ALL
SELECT 'ERROR','0','2008-03-16 05:30:01.777','UT_GATEWAY' UNION ALL
SELECT 'FGID','2','2008-03-16 05:30:01.777','UT_GATEWAY' UNION ALL
SELECT 'FGWIDTH','7','2008-03-16 05:30:01.777','UT_GATEWAY' UNION ALL
SELECT 'MBOX','2','2008-03-16 05:30:01.777','UT_GATEWAY' UNION ALL
SELECT 'PROCFILE','348','2008-03-16 05:30:01.777','UT_GATEWAY' UNION ALL
SELECT 'PROCNAME','31','2008-03-16 05:30:01.777','UT_GATEWAY' UNION ALL
SELECT 'PWD_GEN','0','2008-03-16 05:30:01.777','UT_GATEWAY' UNION ALL
SELECT 'RUN_ID','1','2008-03-16 05:30:01.777','UT_GATEWAY' UNION ALL
SELECT 'SYSUSER','1','2008-03-16 05:30:01.777','UT_GATEWAY' UNION ALL
SELECT 'Employee File','302797','2008-03-16 05:30:01.683','tbgfmla4' UNION ALL
SELECT 'Hist Company Insurance File','0','2008-03-16 05:30:01.683','tbgfmla4' UNION ALL
SELECT 'PlatformUpdates','62','2008-03-16 05:30:01.683','tbgfmla4' UNION ALL
SELECT 'INGHAM_SSO','2574','2008-03-16 05:30:01.683','tbgfmla4' UNION ALL
SELECT 'State Leave Plan File','34','2008-03-16 05:30:01.683','tbgfmla4' UNION ALL
SELECT 'hcscmanagerdat','1754','2008-03-16 05:30:01.683','tbgfmla4' UNION ALL
SELECT 'Claim File Empl Export_MT','0','2008-03-16 05:30:01.683','tbgfmla4' UNION ALL
SELECT 'Claim Notes','409579','2008-03-16 05:30:01.683','tbgfmla4' UNION ALL
SELECT 'HCSCmanagersold','13959','2008-03-16 05:30:01.683','tbgfmla4' UNION ALL
SELECT 'Empl_Premium_Export_MT','0','2008-03-16 05:30:01.683','tbgfmla4' UNION ALL
SELECT 'Claim Hours Used_MT_ALL_CL','0','2008-03-16 05:30:01.683','tbgfmla4' UNION ALL
SELECT 'Claim Hours Used_MT_ALL_FSCo','0','2008-03-16 05:30:01.683','tbgfmla4' UNION ALL
SELECT 'Manager Data','8587','2008-03-16 05:30:01.683','tbgfmla4' UNION ALL
SELECT '~TMPCLP184881','0','2008-03-16 05:30:01.683','tbgfmla4' UNION ALL
SELECT 'HCSC_conver_IDS','272','2008-03-16 05:30:01.683','tbgfmla4' UNION ALL
SELECT 'Claim Hours Used_MT_CL','0','2008-03-16 05:30:01.683','tbgfmla4' UNION ALL
SELECT '~TMPCLP546791','1714','2008-03-16 05:30:01.683','tbgfmla4' UNION ALL
SELECT 'Claim Hours Used_MT_FSCo','0','2008-03-16 05:30:01.683','tbgfmla4' UNION ALL
SELECT 'Company Admin Table','2','2008-03-16 05:30:01.683','tbgfmla4' UNION ALL
SELECT 'tempmanagercheck','14231','2008-03-16 05:30:01.683','tbgfmla4' UNION ALL
SELECT 'HCSCPROD','15852','2008-03-16 05:30:01.683','tbgfmla4' UNION ALL
SELECT 'Claim Hours Used_OC_MT','0','2008-03-16 05:30:01.683','tbgfmla4' UNION ALL
SELECT 'Clm_EDClaim','11','2008-03-16 05:30:01.683','tbgfmla4' UNION ALL
SELECT 'Clm_EDEmpl','1','2008-03-16 05:30:01.683','tbgfmla4' UNION ALL
SELECT 'EE_EDEmpl','0','2008-03-16 05:30:01.683','tbgfmla4' UNION ALL
SELECT 'Missing Employees','1','2008-03-16 05:30:01.683','tbgfmla4' UNION ALL
SELECT 'Claim File_backup','96241','2008-03-16 05:30:01.683','tbgfmla4' UNION ALL
SELECT 'MassLetters','31','2008-03-16 05:30:01.683','tbgfmla4' UNION ALL
SELECT 'EE_MGR_ID_PAMP','807','2008-03-16 05:30:01.683','tbgfmla4' UNION ALL
SELECT 'EE_MGR_ID_CME','1307','2008-03-16 05:30:01.683','tbgfmla4' UNION ALL
SELECT 'ManagersComcast','199','2008-03-16 05:30:01.683','tbgfmla4' UNION ALL
SELECT 'EE_MGR_ID_IWCO','1483','2008-03-16 05:30:01.683','tbgfmla4' UNION ALL
SELECT 'EE_MGR_ID_INGHAM','2039','2008-03-16 05:30:01.683','tbgfmla4' UNION ALL
SELECT 'EE_MGR_GE','8168','2008-03-16 05:30:01.683','tbgfmla4' UNION ALL
SELECT 'CompanyInfo','192','2008-03-16 05:30:01.683','tbgfmla4' UNION ALL
SELECT 'BenefitRates','3101','2008-03-16 05:30:01.683','tbgfmla4' UNION ALL
SELECT 'update_ImportErrors','0','2008-03-16 05:30:01.683','tbgfmla4' UNION ALL
SELECT 'WeeklyReportInfo','906','2008-03-16 05:30:01.683','tbgfmla4' UNION ALL
SELECT 'EE_EDClaim','0','2008-03-16 05:30:01.683','tbgfmla4' UNION ALL
SELECT 'EE StateSet','0','2008-03-16 05:30:01.683','tbgfmla4' UNION ALL
SELECT 'update_ImportErrors1','7','2008-03-16 05:30:01.683','tbgfmla4' UNION ALL
SELECT 'Freq_Hrs_YTD','1537','2008-03-16 05:30:01.683','tbgfmla4' UNION ALL
SELECT 'Freq_Dec_YTD','1','2008-03-16 05:30:01.683','tbgfmla4' UNION ALL
SELECT 'Employee Ins Coverage File','0','2008-03-16 05:30:01.683','tbgfmla4' UNION ALL
SELECT 'update_ImportErrors2','7','2008-03-16 05:30:01.683','tbgfmla4' UNION ALL
SELECT 'ReportScripts','7','2008-03-16 05:30:01.683','tbgfmla4' UNION ALL
SELECT 'Hours Summary Update','0','2008-03-16 05:30:01.683','tbgfmla4' UNION ALL
SELECT 'update_ImportErrors3','7','2008-03-16 05:30:01.683','tbgfmla4' UNION ALL
SELECT 'WebLinks','0','2008-03-16 05:30:01.683','tbgfmla4' UNION ALL
SELECT 'Claim File','125284','2008-03-16 05:30:01.683','tbgfmla4' UNION ALL
SELECT 'Dept Code','118','2008-03-16 05:30:01.683','tbgfmla4' UNION ALL
SELECT 'Employee Filebackup','132066','2008-03-16 05:30:01.683','tbgfmla4' UNION ALL
SELECT 'Callback Rsn File','0','2008-03-16 05:30:01.683','tbgfmla4' UNION ALL
SELECT 'Hours Summary_TA','0','2008-03-16 05:30:01.683','tbgfmla4' UNION ALL
SELECT 'Manager Data_20061012','3157','2008-03-16 05:30:01.683','tbgfmla4' UNION ALL
SELECT 'Relation File','6','2008-03-16 05:30:01.683','tbgfmla4' UNION ALL
SELECT 'Correspondence File','1497','2008-03-16 05:30:01.683','tbgfmla4' UNION ALL
SELECT 'Hist Claim File Non GEC','0','2008-03-16 05:30:01.683','tbgfmla4' UNION ALL
SELECT 'Correspondence File Old','0','2008-03-16 05:30:01.683','tbgfmla4' UNION ALL
SELECT 'Denial_Counts','26','2008-03-16 05:30:01.683','tbgfmla4' UNION ALL
SELECT 'CI_Web_Import_Calc','0','2008-03-16 05:30:01.683','tbgfmla4' UNION ALL
SELECT 'ManagersBMW','20','2008-03-16 05:30:01.683','tbgfmla4' UNION ALL
SELECT 'HRContactComcastNew','199','2008-03-16 05:30:01.683','tbgfmla4' UNION ALL
SELECT 'HRContactComcast','198','2008-03-16 05:30:01.683','tbgfmla4' UNION ALL
SELECT 'dtproperties','0','2008-03-16 05:30:01.683','tbgfmla4' UNION ALL
SELECT 'Freq_Dec_YTD_New','1','2008-03-16 05:30:01.683','tbgfmla4' UNION ALL
SELECT 'Freq_Hrs_YTD_New','208','2008-03-16 05:30:01.683','tbgfmla4' UNION ALL
SELECT 'Employee Update File','2516','2008-03-16 05:30:01.683','tbgfmla4' UNION ALL
SELECT 'CI_Web_Import_Raw','0','2008-03-16 05:30:01.683','tbgfmla4' UNION ALL
SELECT 'Hours Update CoLvPlan','4','2008-03-16 05:30:01.683','tbgfmla4' UNION ALL
SELECT 'Hist Claim Notes','372511','2008-03-16 05:30:01.683','tbgfmla4' UNION ALL
SELECT 'ManagersChemtura','19','2008-03-16 05:30:01.683','tbgfmla4' UNION ALL
SELECT 'Hist Employee Ins Billing File','0','2008-03-16 05:30:01.683','tbgfmla4' UNION ALL
SELECT 'Company Leave Plan File_EEMT','0','2008-03-16 05:30:01.683','tbgfmla4' UNION ALL
SELECT 'ManagerSunlifeBackup','460','2008-03-16 05:30:01.683','tbgfmla4' UNION ALL
SELECT 'Company Leave Plan File_OCMT','0','2008-03-16 05:30:01.683','tbgfmla4' UNION ALL
SELECT 'tempTermDteResearch','2943','2008-03-16 05:30:01.683','tbgfmla4' UNION ALL
SELECT 'Employee File Archive','0','2008-03-16 05:30:01.683','tbgfmla4' UNION ALL
SELECT 'HS Clm Updte Clm','0','2008-03-16 05:30:01.683','tbgfmla4' UNION ALL
SELECT 'HS EE','1','2008-03-16 05:30:01.683','tbgfmla4' UNION ALL
SELECT 'Conversion Errors','0','2008-03-16 05:30:01.683','tbgfmla4' UNION ALL
SELECT 'History_Claim_File','0','2008-03-16 05:30:01.683','tbgfmla4' UNION ALL
SELECT 'ManagersSensata','1614','2008-03-16 05:30:01.683','tbgfmla4' UNION ALL
SELECT 'ManagersIwcoDirect','14','2008-03-16 05:30:01.683','tbgfmla4' UNION ALL
SELECT 'HS EEClm','11','2008-03-16 05:30:01.683','tbgfmla4' UNION ALL
SELECT 'HS Empl Update','0','2008-03-16 05:30:01.683','tbgfmla4' UNION ALL
SELECT 'ManagersCommonWealth','410','2008-03-16 05:30:01.683','tbgfmla4' UNION ALL
SELECT 'SensataTemp','1603','2008-03-16 05:30:01.683','tbgfmla4' UNION ALL
SELECT 'InghamManagers','119','2008-03-16 05:30:01.683','tbgfmla4' UNION ALL
SELECT 'HS Update HS','0','2008-03-16 05:30:01.683','tbgfmla4' UNION ALL
SELECT 'ManagersFreshExpress','10','2008-03-16 05:30:01.683','tbgfmla4' UNION ALL
SELECT 'Hist Company Leave Plan File','268','2008-03-16 05:30:01.683','tbgfmla4' UNION ALL
SELECT 'Employee File_20061017','143235','2008-03-16 05:30:01.683','tbgfmla4' UNION ALL
SELECT 'ManagersSunlife','462','2008-03-16 05:30:01.683','tbgfmla4' UNION ALL
SELECT 'IT_TaskList','5','2008-03-16 05:30:01.683','tbgfmla4' UNION ALL
SELECT 'Manager Data_20061018','3322','2008-03-16 05:30:01.683','tbgfmla4' UNION ALL
SELECT 'Employee Ins Billing File','0','2008-03-16 05:30:01.683','tbgfmla4' UNION ALL
SELECT 'Company Data File','130','2008-03-16 05:30:01.683','tbgfmla4' UNION ALL
SELECT 'Employee File_20061018','135116','2008-03-16 05:30:01.683','tbgfmla4' UNION ALL
SELECT 'EligibleEmployees','92','2008-03-16 05:30:01.683','tbgfmla4' UNION ALL
SELECT 'Hours Summary','552657','2008-03-16 05:30:01.683','tbgfmla4' UNION ALL
SELECT 'ManagersPenske','1623','2008-03-16 05:30:01.683','tbgfmla4' UNION ALL
SELECT 'Hist Hours Summary','525076','2008-03-16 05:30:01.683','tbgfmla4' UNION ALL
SELECT 'INGREG_HW','3107','2008-03-16 05:30:01.683','tbgfmla4' UNION ALL
SELECT 'Att_AbsCde','0','2008-03-16 05:30:01.683','tbgfmla4' UNION ALL
SELECT 'FMLAInputData_ImportErrors','0','2008-03-16 05:30:01.683','tbgfmla4' UNION ALL
SELECT 'Claim File_11022006','56414','2008-03-16 05:30:01.683','tbgfmla4' UNION ALL
SELECT 'GESSOConv','21223','2008-03-16 05:30:01.683','tbgfmla4' UNION ALL
SELECT 'Att_AbsRec','0','2008-03-16 05:30:01.683','tbgfmla4' UNION ALL
SELECT 'Company Insurance File','0','2008-03-16 05:30:01.683','tbgfmla4' UNION ALL
SELECT 'Att_AbsRec_Import','0','2008-03-16 05:30:01.683','tbgfmla4' UNION ALL
SELECT 'Att_CoPlans','0','2008-03-16 05:30:01.683','tbgfmla4' UNION ALL
SELECT 'GEC_ClmTrk','0','2008-03-16 05:30:01.683','tbgfmla4' UNION ALL
SELECT 'Att_Corresp','0','2008-03-16 05:30:01.683','tbgfmla4' UNION ALL
SELECT 'Att_CoRules','0','2008-03-16 05:30:01.683','tbgfmla4' UNION ALL
SELECT 'Correspondence Signature','11','2008-03-16 05:30:01.683','tbgfmla4' UNION ALL
SELECT 'NewEmplUpdate','2516','2008-03-16 05:30:01.683','tbgfmla4' UNION ALL
SELECT 'Att_Occur','0','2008-03-16 05:30:01.683','tbgfmla4' UNION ALL
SELECT 'FedPersRsn','0','2008-03-16 05:30:01.683','tbgfmla4' UNION ALL
SELECT 'Hist Company Data File','0','2008-03-16 05:30:01.683','tbgfmla4' UNION ALL
SELECT 'Hist Employee File','0','2008-03-16 05:30:01.683','tbgfmla4' UNION ALL
SELECT 'ManagerUpdate','7046','2008-03-16 05:30:01.683','tbgfmla4' UNION ALL
SELECT 'Company Data File_EEMT','0','2008-03-16 05:30:01.683','tbgfmla4' UNION ALL
SELECT 'Hist_Att_AbsCde','0','2008-03-16 05:30:01.683','tbgfmla4' UNION ALL
SELECT 'Hist_Att_AbsRec','0','2008-03-16 05:30:01.683','tbgfmla4' UNION ALL
SELECT 'Hist_Att_CoPlans','0','2008-03-16 05:30:01.683','tbgfmla4' UNION ALL
SELECT 'Paste Errors','0','2008-03-16 05:30:01.683','tbgfmla4' UNION ALL
SELECT 'Hist_Att_CoRules','0','2008-03-16 05:30:01.683','tbgfmla4' UNION ALL
SELECT 'Hist_Att_Occur','0','2008-03-16 05:30:01.683','tbgfmla4' UNION ALL
SELECT 'DataRowCounts','151','2008-03-16 05:30:01.683','tbgfmla4' UNION ALL
SELECT 'SysCdeDDBox1','0','2008-03-16 05:30:01.683','tbgfmla4' UNION ALL
SELECT 'Company Leave Plan File','288','2008-03-16 05:30:01.683','tbgfmla4' UNION ALL
SELECT 'SysCdeDDBox2','0','2008-03-16 05:30:01.683','tbgfmla4' UNION ALL
SELECT 'SysCdeDDBox3','0','2008-03-16 05:30:01.683','tbgfmla4' UNION ALL
SELECT 'AdvMgr','36','2008-03-16 05:30:01.683','tbgfmla4' UNION ALL
SELECT 'Freq_Dec_YTD_All','2','2008-03-16 05:30:01.683','tbgfmla4' UNION ALL
SELECT 'SysCdeDDBox4','0','2008-03-16 05:30:01.683','tbgfmla4' UNION ALL
SELECT 'Freq_Hrs_YTD_All','53732','2008-03-16 05:30:01.683','tbgfmla4' UNION ALL
SELECT 'SysCdeDDBox5','0','2008-03-16 05:30:01.683','tbgfmla4' UNION ALL
SELECT 'Hist Claim File','530382','2008-03-16 05:30:01.683','tbgfmla4' UNION ALL
SELECT 'Company Data File_OCMT','0','2008-03-16 05:30:01.683','tbgfmla4' UNION ALL
SELECT 'SysCdeDDBox6','0','2008-03-16 05:30:01.683','tbgfmla4' UNION ALL
SELECT 'States','51','2008-03-16 05:30:01.683','tbgfmla4' UNION ALL
SELECT 'Hist State Leave Plan File','33','2008-03-16 05:30:01.683','tbgfmla4' UNION ALL
SELECT 'Correspondence Sent','1044','2008-03-16 05:30:01.683','tbgfmla4' UNION ALL
SELECT 'ManagersGTCasino','30','2008-03-16 05:30:01.683','tbgfmla4' UNION ALL
SELECT 'ManagersLaRabida','46','2008-03-16 05:30:01.683','tbgfmla4' UNION ALL
SELECT 'ManagersGEPlastic','23','2008-03-16 05:30:01.683','tbgfmla4' UNION ALL
SELECT 'Hist Claim File GEC Post2004','0','2008-03-16 05:30:01.683','tbgfmla4' UNION ALL
SELECT 'Rsn Denied File','26','2008-03-16 05:30:01.683','tbgfmla4' UNION ALL
SELECT 'Correspondence_Sent_RPT','31','2008-03-16 05:30:01.683','tbgfmla4' UNION ALL
SELECT 'Comcast_MgrID_list','11392','2008-03-16 05:30:01.683','tbgfmla4' UNION ALL
SELECT 'Hist Claim File GEC Pre2004','0','2008-03-16 05:30:01.683','tbgfmla4' UNION ALL
SELECT 'Chemtura_mgrid_list','3530','2008-03-16 05:30:01.683','tbgfmla4' UNION ALL
SELECT 'Manager list 08-17-06','3522','2008-03-16 05:30:01.683','tbgfmla4' UNION ALL
SELECT 'Yankeemanager07152006','4551','2008-03-16 05:30:01.683','tbgfmla4' UNION ALL
SELECT 'EmployeeFile030_2004','3959991','2008-03-16 05:30:01.607','STAGING ' UNION ALL
SELECT 'EmployeeFile030_2005','11756439','2008-03-16 05:30:01.607','STAGING ' UNION ALL
SELECT 'EmployeeFile030_2006','15752337','2008-03-16 05:30:01.607','STAGING ' UNION ALL
SELECT 'EmployeeFile030_20071210','18246259','2008-03-16 05:30:01.607','STAGING ' UNION ALL
SELECT 'EmployeeFile030CokeCounts','15','2008-03-16 05:30:01.607','STAGING ' UNION ALL
SELECT 'employeefile030test','0','2008-03-16 05:30:01.607','STAGING ' UNION ALL
SELECT 'EMPLOYEEFILE030_TEMP','0','2008-03-16 05:30:01.607','STAGING ' UNION ALL
SELECT 'Employeefile030','3767417','2008-03-16 05:30:01.607','STAGING ' UNION ALL
SELECT 'EmployeeFile030Temp','329','2008-03-16 05:30:01.607','STAGING ' UNION ALL
SELECT 'EmployeeFile030Errors','12986','2008-03-16 05:30:01.607','STAGING ' UNION ALL
SELECT 'EligibilityStaging','0','2008-03-16 05:30:01.607','STAGING ' UNION ALL
SELECT 'dtproperties','0','2008-03-16 05:30:01.607','STAGING ' UNION ALL
SELECT 'mon','0','2008-03-16 05:30:01.433','IPRISM' UNION ALL
SELECT 'RT','0','2008-03-16 05:30:01.433','IPRISM' UNION ALL
SELECT 'dtproperties','0','2008-03-16 05:30:01.433','IPRISM' UNION ALL
SELECT 'CAS_SEGMENT','0','2008-03-16 05:30:01.357','HIPAA_ODS_ARCHIVE ' UNION ALL
SELECT 'CAT_SEGMENT','0','2008-03-16 05:30:01.357','HIPAA_ODS_ARCHIVE ' UNION ALL
SELECT 'CL1_SEGMENT','0','2008-03-16 05:30:01.357','HIPAA_ODS_ARCHIVE ' UNION ALL
SELECT 'CLM_SEGMENT','0','2008-03-16 05:30:01.357','HIPAA_ODS_ARCHIVE ' UNION ALL
SELECT 'CLP_SEGMENT','0','2008-03-16 05:30:01.357','HIPAA_ODS_ARCHIVE ' UNION ALL
SELECT 'CN1_SEGMENT','0','2008-03-16 05:30:01.357','HIPAA_ODS_ARCHIVE ' UNION ALL
SELECT 'COB_SEGMENT','0','2008-03-16 05:30:01.357','HIPAA_ODS_ARCHIVE ' UNION ALL
SELECT 'COMPANY_INFO','0','2008-03-16 05:30:01.357','HIPAA_ODS_ARCHIVE ' UNION ALL
SELECT 'CONTACT_INFO','0','2008-03-16 05:30:01.357','HIPAA_ODS_ARCHIVE ' UNION ALL
SELECT 'CR1_SEGMENT','0','2008-03-16 05:30:01.357','HIPAA_ODS_ARCHIVE ' UNION ALL
SELECT 'CR2_SEGMENT','0','2008-03-16 05:30:01.357','HIPAA_ODS_ARCHIVE ' UNION ALL
SELECT 'CR3_SEGMENT','0','2008-03-16 05:30:01.357','HIPAA_ODS_ARCHIVE ' UNION ALL
SELECT 'CR5_SEGMENT','0','2008-03-16 05:30:01.357','HIPAA_ODS_ARCHIVE ' UNION ALL
SELECT 'CR6_SEGMENT','0','2008-03-16 05:30:01.357','HIPAA_ODS_ARCHIVE ' UNION ALL
SELECT 'CR7_SEGMENT','0','2008-03-16 05:30:01.357','HIPAA_ODS_ARCHIVE ' UNION ALL
SELECT 'CRC_SEGMENT','0','2008-03-16 05:30:01.357','HIPAA_ODS_ARCHIVE ' UNION ALL
SELECT 'CTP_SEGMENT','0','2008-03-16 05:30:01.357','HIPAA_ODS_ARCHIVE ' UNION ALL
SELECT 'CUR_SEGMENT','0','2008-03-16 05:30:01.357','HIPAA_ODS_ARCHIVE ' UNION ALL
SELECT 'DMG_SEGMENT','0','2008-03-16 05:30:01.357','HIPAA_ODS_ARCHIVE ' UNION ALL
SELECT 'DSB_SEGMENT','0','2008-03-16 05:30:01.357','HIPAA_ODS_ARCHIVE ' UNION ALL
SELECT 'DTM_SEGMENT','0','2008-03-16 05:30:01.357','HIPAA_ODS_ARCHIVE ' UNION ALL
SELECT 'DTP_SEGMENT','0','2008-03-16 05:30:01.357','HIPAA_ODS_ARCHIVE ' UNION ALL
SELECT 'EB_SEGMENT','0','2008-03-16 05:30:01.357','HIPAA_ODS_ARCHIVE ' UNION ALL
SELECT 'ENT_SEGMENT','0','2008-03-16 05:30:01.357','HIPAA_ODS_ARCHIVE ' UNION ALL
SELECT 'EQ_SEGMENT','0','2008-03-16 05:30:01.357','HIPAA_ODS_ARCHIVE ' UNION ALL
SELECT 'FRM_SEGMENT','0','2008-03-16 05:30:01.357','HIPAA_ODS_ARCHIVE ' UNION ALL
SELECT 'GE_SEGMENT','0','2008-03-16 05:30:01.357','HIPAA_ODS_ARCHIVE ' UNION ALL
SELECT 'GS_SEGMENT','0','2008-03-16 05:30:01.357','HIPAA_ODS_ARCHIVE ' UNION ALL
SELECT 'HCP_SEGMENT','0','2008-03-16 05:30:01.357','HIPAA_ODS_ARCHIVE ' UNION ALL
SELECT 'HCR_SEGMENT','0','2008-03-16 05:30:01.357','HIPAA_ODS_ARCHIVE ' UNION ALL
SELECT 'HD_SEGMENT','0','2008-03-16 05:30:01.357','HIPAA_ODS_ARCHIVE ' UNION ALL
SELECT 'HIPAA_LOOP','0','2008-03-16 05:30:01.357','HIPAA_ODS_ARCHIVE ' UNION ALL
SELECT 'HIPAA_SEGMENT_LOOKUP','0','2008-03-16 05:30:01.357','HIPAA_ODS_ARCHIVE ' UNION ALL
SELECT 'HIPAA_TRADING_PARTNER','0','2008-03-16 05:30:01.357','HIPAA_ODS_ARCHIVE ' UNION ALL
SELECT 'HIPAA_TRANSACTIONS','0','2008-03-16 05:30:01.357','HIPAA_ODS_ARCHIVE ' UNION ALL
SELECT 'HIPAA_TRANSACTION_LOOKUP','0','2008-03-16 05:30:01.357','HIPAA_ODS_ARCHIVE ' UNION ALL
SELECT 'HIPAA_TRANSACTION_SEGMENT_LOOKUP','0','2008-03-16 05:30:01.357','HIPAA_ODS_ARCHIVE ' UNION ALL
SELECT 'HI_SEGMENT','0','2008-03-16 05:30:01.357','HIPAA_ODS_ARCHIVE ' UNION ALL
SELECT 'HLH_SEGMENT','0','2008-03-16 05:30:01.357','HIPAA_ODS_ARCHIVE ' UNION ALL
SELECT 'HL_SEGMENT','0','2008-03-16 05:30:01.357','HIPAA_ODS_ARCHIVE ' UNION ALL
SELECT 'HSD_SEGMENT','0','2008-03-16 05:30:01.357','HIPAA_ODS_ARCHIVE ' UNION ALL
SELECT 'ICM_SEGMENT','0','2008-03-16 05:30:01.357','HIPAA_ODS_ARCHIVE ' UNION ALL
SELECT 'IDC_SEGMENT','0','2008-03-16 05:30:01.357','HIPAA_ODS_ARCHIVE ' UNION ALL
SELECT 'IEA_SEGMENT','0','2008-03-16 05:30:01.357','HIPAA_ODS_ARCHIVE ' UNION ALL
SELECT 'III_SEGMENT','0','2008-03-16 05:30:01.357','HIPAA_ODS_ARCHIVE ' UNION ALL
SELECT 'INS_SEGMENT','0','2008-03-16 05:30:01.357','HIPAA_ODS_ARCHIVE ' UNION ALL
SELECT 'ISA_SEGMENT','0','2008-03-16 05:30:01.357','HIPAA_ODS_ARCHIVE ' UNION ALL
SELECT 'IT1_SEGMENT','0','2008-03-16 05:30:01.357','HIPAA_ODS_ARCHIVE ' UNION ALL
SELECT 'K3_SEGMENT','0','2008-03-16 05:30:01.357','HIPAA_ODS_ARCHIVE ' UNION ALL
SELECT 'LE_SEGMENT','0','2008-03-16 05:30:01.357','HIPAA_ODS_ARCHIVE ' UNION ALL
SELECT 'LIN_SEGMENT','0','2008-03-16 05:30:01.357','HIPAA_ODS_ARCHIVE ' UNION ALL
SELECT 'LQ_SEGMENT','0','2008-03-16 05:30:01.357','HIPAA_ODS_ARCHIVE ' UNION ALL
SELECT 'LS_SEGMENT','0','2008-03-16 05:30:01.357','HIPAA_ODS_ARCHIVE ' UNION ALL
SELECT 'LUI_SEGMENT','0','2008-03-16 05:30:01.357','HIPAA_ODS_ARCHIVE ' UNION ALL
SELECT 'LX_SEGMENT','0','2008-03-16 05:30:01.357','HIPAA_ODS_ARCHIVE ' UNION ALL
SELECT 'MEA_SEGMENT','0','2008-03-16 05:30:01.357','HIPAA_ODS_ARCHIVE ' UNION ALL
SELECT 'MIA_SEGMENT','0','2008-03-16 05:30:01.357','HIPAA_ODS_ARCHIVE ' UNION ALL
SELECT 'MOA_SEGMENT','0','2008-03-16 05:30:01.357','HIPAA_ODS_ARCHIVE ' UNION ALL
SELECT 'MSG_SEGMENT','0','2008-03-16 05:30:01.357','HIPAA_ODS_ARCHIVE ' UNION ALL
SELECT 'N1_SEGMENT','0','2008-03-16 05:30:01.357','HIPAA_ODS_ARCHIVE ' UNION ALL
SELECT 'N2_SEGMENT','0','2008-03-16 05:30:01.357','HIPAA_ODS_ARCHIVE ' UNION ALL
SELECT 'N3_SEGMENT','0','2008-03-16 05:30:01.357','HIPAA_ODS_ARCHIVE ' UNION ALL
SELECT 'N4_SEGMENT','0','2008-03-16 05:30:01.357','HIPAA_ODS_ARCHIVE ' UNION ALL
SELECT 'NM1_SEGMENT','0','2008-03-16 05:30:01.357','HIPAA_ODS_ARCHIVE ' UNION ALL
SELECT 'NTE_SEGMENT','0','2008-03-16 05:30:01.357','HIPAA_ODS_ARCHIVE ' UNION ALL
SELECT 'OI_SEGMENT','0','2008-03-16 05:30:01.357','HIPAA_ODS_ARCHIVE ' UNION ALL
SELECT 'PAT_SEGMENT','0','2008-03-16 05:30:01.357','HIPAA_ODS_ARCHIVE ' UNION ALL
SELECT 'PER_SEGMENT','0','2008-03-16 05:30:01.357','HIPAA_ODS_ARCHIVE ' UNION ALL
SELECT 'PLA_SEGMENT','0','2008-03-16 05:30:01.357','HIPAA_ODS_ARCHIVE ' UNION ALL
SELECT 'PLB_SEGMENT','0','2008-03-16 05:30:01.357','HIPAA_ODS_ARCHIVE ' UNION ALL
SELECT 'PRV_SEGMENT','0','2008-03-16 05:30:01.357','HIPAA_ODS_ARCHIVE ' UNION ALL
SELECT 'PS1_SEGMENT','0','2008-03-16 05:30:01.357','HIPAA_ODS_ARCHIVE ' UNION ALL
SELECT 'PWK_SEGMENT','0','2008-03-16 05:30:01.357','HIPAA_ODS_ARCHIVE ' UNION ALL
SELECT 'QTY_SEGMENT','0','2008-03-16 05:30:01.357','HIPAA_ODS_ARCHIVE ' UNION ALL
SELECT 'REF_SEGMENT','0','2008-03-16 05:30:01.357','HIPAA_ODS_ARCHIVE ' UNION ALL
SELECT 'RMR_SEGMENT','0','2008-03-16 05:30:01.357','HIPAA_ODS_ARCHIVE ' UNION ALL
SELECT 'SBR_SEGMENT','0','2008-03-16 05:30:01.357','HIPAA_ODS_ARCHIVE ' UNION ALL
SELECT 'SE_SEGMENT','0','2008-03-16 05:30:01.357','HIPAA_ODS_ARCHIVE ' UNION ALL
SELECT 'SLN_SEGMENT','0','2008-03-16 05:30:01.357','HIPAA_ODS_ARCHIVE ' UNION ALL
SELECT 'STC_SEGMENT','0','2008-03-16 05:30:01.357','HIPAA_ODS_ARCHIVE ' UNION ALL
SELECT 'ST_SEGMENT','0','2008-03-16 05:30:01.357','HIPAA_ODS_ARCHIVE ' UNION ALL
SELECT 'SV1_SEGMENT','0','2008-03-16 05:30:01.357','HIPAA_ODS_ARCHIVE ' UNION ALL
SELECT 'SV2_SEGMENT','0','2008-03-16 05:30:01.357','HIPAA_ODS_ARCHIVE ' UNION ALL
SELECT 'SV4_SEGMENT','0','2008-03-16 05:30:01.357','HIPAA_ODS_ARCHIVE ' UNION ALL
SELECT 'SVC_SEGMENT','0','2008-03-16 05:30:01.357','HIPAA_ODS_ARCHIVE ' UNION ALL
SELECT 'SVD_SEGMENT','0','2008-03-16 05:30:01.357','HIPAA_ODS_ARCHIVE ' UNION ALL
SELECT 'TA1_SEGMENT','0','2008-03-16 05:30:01.357','HIPAA_ODS_ARCHIVE ' UNION ALL
SELECT 'TRADING_PARTNER_CONTACT','0','2008-03-16 05:30:01.357','HIPAA_ODS_ARCHIVE ' UNION ALL
SELECT 'TRN_SEGMENT','0','2008-03-16 05:30:01.357','HIPAA_ODS_ARCHIVE ' UNION ALL
SELECT 'TS2_SEGMENT','0','2008-03-16 05:30:01.357','HIPAA_ODS_ARCHIVE ' UNION ALL
SELECT 'TS3_SEGMENT','0','2008-03-16 05:30:01.357','HIPAA_ODS_ARCHIVE ' UNION ALL
SELECT 'UM_SEGMENT','0','2008-03-16 05:30:01.357','HIPAA_ODS_ARCHIVE ' UNION ALL
SELECT 'dtproperties','0','2008-03-16 05:30:01.357','HIPAA_ODS_ARCHIVE ' UNION ALL
SELECT 'AAA_SEGMENT','0','2008-03-16 05:30:01.357','HIPAA_ODS_ARCHIVE ' UNION ALL
SELECT 'ACT_SEGMENT','0','2008-03-16 05:30:01.357','HIPAA_ODS_ARCHIVE ' UNION ALL
SELECT 'ADX_SEGMENT','0','2008-03-16 05:30:01.357','HIPAA_ODS_ARCHIVE ' UNION ALL
SELECT 'AMT_SEGMENT','0','2008-03-16 05:30:01.357','HIPAA_ODS_ARCHIVE ' UNION ALL
SELECT 'BGN_SEGMENT','0','2008-03-16 05:30:01.357','HIPAA_ODS_ARCHIVE ' UNION ALL
SELECT 'BHT_SEGMENT','0','2008-03-16 05:30:01.357','HIPAA_ODS_ARCHIVE ' UNION ALL
SELECT 'BPR_SEGMENT','0','2008-03-16 05:30:01.357','HIPAA_ODS_ARCHIVE ' UNION ALL
SELECT 'BUSINESS_EDIT_INDEX','0','2008-03-16 05:30:01.357','HIPAA_ODS_ARCHIVE ' UNION ALL
SELECT 'BUSINESS_EDIT_LOG','0','2008-03-16 05:30:01.357','HIPAA_ODS_ARCHIVE ' UNION ALL
SELECT 'BUSINESS_EDIT_MESSAGES','0','2008-03-16 05:30:01.357','HIPAA_ODS_ARCHIVE ' UNION ALL
SELECT 'BUSINESS_ERROR_LOG','0','2008-03-16 05:30:01.357','HIPAA_ODS_ARCHIVE ' UNION ALL
SELECT 'HIPAA_OB837_XMIT_LOG','27176','2008-03-16 05:30:01.277','HIPAA ' UNION ALL
SELECT 'HIPAA_OB835_LASTRUNDATE','1','2008-03-16 05:30:01.277','HIPAA ' UNION ALL
SELECT 'HIPAA_OB837I_LASTRUNDATE','1','2008-03-16 05:30:01.277','HIPAA ' UNION ALL
SELECT 'HIPAA_OB837P_LASTRUNDATE','1','2008-03-16 05:30:01.277','HIPAA ' UNION ALL
SELECT 'HIPAA_SEGMENT_LOOKUP','95','2008-03-16 05:30:01.277','HIPAA ' UNION ALL
SELECT 'HIPAA_TPA_INSNOS','10','2008-03-16 05:30:01.277','HIPAA ' UNION ALL
SELECT 'HIPAA_TRADING_PARTNER','15','2008-03-16 05:30:01.277','HIPAA ' UNION ALL
SELECT 'HIPAA_TRANSACTIONS','900','2008-03-16 05:30:01.277','HIPAA ' UNION ALL
SELECT 'HIPAA_TRANSACTION_LOOKUP','13','2008-03-16 05:30:01.277','HIPAA ' UNION ALL
SELECT 'HIPAA_TRANSACTION_SEGMENT_LOOKUP','116','2008-03-16 05:30:01.277','HIPAA ' UNION ALL
SELECT 'HI_SEGMENT','3104','2008-03-16 05:30:01.277','HIPAA ' UNION ALL
SELECT 'HLH_SEGMENT','0','2008-03-16 05:30:01.277','HIPAA ' UNION ALL
SELECT 'HL_SEGMENT','3840','2008-03-16 05:30:01.277','HIPAA ' UNION ALL
SELECT 'HSD_SEGMENT','0','2008-03-16 05:30:01.277','HIPAA ' UNION ALL
SELECT 'ICM_SEGMENT','0','2008-03-16 05:30:01.277','HIPAA ' UNION ALL
SELECT 'IDC_SEGMENT','0','2008-03-16 05:30:01.277','HIPAA ' UNION ALL
SELECT 'IEA_SEGMENT','0','2008-03-16 05:30:01.277','HIPAA ' UNION ALL
SELECT 'III_SEGMENT','0','2008-03-16 05:30:01.277','HIPAA ' UNION ALL
SELECT 'INS_SEGMENT','653811','2008-03-16 05:30:01.277','HIPAA ' UNION ALL
SELECT 'ISA_SEGMENT','238','2008-03-16 05:30:01.277','HIPAA ' UNION ALL
SELECT 'IT1_SEGMENT','0','2008-03-16 05:30:01.277','HIPAA ' UNION ALL
SELECT 'K3_SEGMENT','0','2008-03-16 05:30:01.277','HIPAA ' UNION ALL
SELECT 'LE_SEGMENT','0','2008-03-16 05:30:01.277','HIPAA ' UNION ALL
SELECT 'LIN_SEGMENT','0','2008-03-16 05:30:01.277','HIPAA ' UNION ALL
SELECT 'LQ_SEGMENT','0','2008-03-16 05:30:01.277','HIPAA ' UNION ALL
SELECT 'LS_SEGMENT','0','2008-03-16 05:30:01.277','HIPAA ' UNION ALL
SELECT 'LUI_SEGMENT','0','2008-03-16 05:30:01.277','HIPAA ' UNION ALL
SELECT 'HIPAA_OB837_LastRunDate','696','2008-03-16 05:30:01.277','HIPAA ' UNION ALL
SELECT 'LX_SEGMENT','4716','2008-03-16 05:30:01.277','HIPAA ' UNION ALL
SELECT 'MEA_SEGMENT','0','2008-03-16 05:30:01.277','HIPAA ' UNION ALL
SELECT 'MIA_SEGMENT','0','2008-03-16 05:30:01.277','HIPAA ' UNION ALL
SELECT 'MOA_SEGMENT','0','2008-03-16 05:30:01.277','HIPAA ' UNION ALL
SELECT 'MSG_SEGMENT','0','2008-03-16 05:30:01.277','HIPAA ' UNION ALL
SELECT 'N1_SEGMENT','170','2008-03-16 05:30:01.277','HIPAA ' UNION ALL
SELECT 'N2_SEGMENT','0','2008-03-16 05:30:01.277','HIPAA ' UNION ALL
SELECT 'N3_SEGMENT','658061','2008-03-16 05:30:01.277','HIPAA ' UNION ALL
SELECT 'N4_SEGMENT','658150','2008-03-16 05:30:01.277','HIPAA ' UNION ALL
SELECT 'NM1_SEGMENT','665516','2008-03-16 05:30:01.277','HIPAA ' UNION ALL
SELECT 'dtproperties','0','2008-03-16 05:30:01.277','HIPAA ' UNION ALL
SELECT 'NTE_SEGMENT','0','2008-03-16 05:30:01.277','HIPAA ' UNION ALL
SELECT 'OI_SEGMENT','3082','2008-03-16 05:30:01.277','HIPAA ' UNION ALL
SELECT 'PAT_SEGMENT','863','2008-03-16 05:30:01.277','HIPAA ' UNION ALL
SELECT 'PER_SEGMENT','360085','2008-03-16 05:30:01.277','HIPAA ' UNION ALL
SELECT 'PLA_SEGMENT','0','2008-03-16 05:30:01.277','HIPAA ' UNION ALL
SELECT 'PLB_SEGMENT','0','2008-03-16 05:30:01.277','HIPAA ' UNION ALL
SELECT 'PRV_SEGMENT','1376','2008-03-16 05:30:01.277','HIPAA ' UNION ALL
SELECT 'PS1_SEGMENT','0','2008-03-16 05:30:01.277','HIPAA ' UNION ALL
SELECT 'PWK_SEGMENT','0','2008-03-16 05:30:01.277','HIPAA ' UNION ALL
SELECT 'QTY_SEGMENT','0','2008-03-16 05:30:01.277','HIPAA ' UNION ALL
SELECT 'REF_SEGMENT','1312229','2008-03-16 05:30:01.277','HIPAA ' UNION ALL
SELECT 'RMR_SEGMENT','0','2008-03-16 05:30:01.277','HIPAA ' UNION ALL
SELECT 'SBR_SEGMENT','4606','2008-03-16 05:30:01.277','HIPAA ' UNION ALL
SELECT 'SE_SEGMENT','0','2008-03-16 05:30:01.277','HIPAA ' UNION ALL
SELECT 'SLN_SEGMENT','0','2008-03-16 05:30:01.277','HIPAA ' UNION ALL
SELECT 'STC_SEGMENT','0','2008-03-16 05:30:01.277','HIPAA ' UNION ALL
SELECT 'ST_SEGMENT','898','2008-03-16 05:30:01.277','HIPAA ' UNION ALL
SELECT 'SV1_SEGMENT','3992','2008-03-16 05:30:01.277','HIPAA ' UNION ALL
SELECT 'SV2_SEGMENT','160','2008-03-16 05:30:01.277','HIPAA ' UNION ALL
SELECT 'SV4_SEGMENT','0','2008-03-16 05:30:01.277','HIPAA ' UNION ALL
SELECT 'SVC_SEGMENT','0','2008-03-16 05:30:01.277','HIPAA '
----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?
March 27, 2008 at 2:32 pm
Query:
select c.Table_Name, c.DBName, c.Row_Count as CurrentWk, c1.Row_Count as LastWk, (c.Row_Count - c1.Row_Count) as Diff
from DataRowCounts c
LEFT OUTER JOIN
DataRowCounts c1 on
c1.Table_Name = c.Table_Name
and c1.DBName = c.DBName
and CONVERT(char,c1.Run_Date,112) = CONVERT(char,(DATEADD(wk, -1,(select MAX(c2.Run_Date) from DataRowCounts c2))),112)
where CONVERT(char,c.Run_Date,112) = (select CONVERT(char,MAX(c2.Run_Date),112) from DataRowCounts c2)
and (c.Row_Count - c1.Row_Count) <> 0
order by (c.Row_Count - c1.Row_Count) desc
Hello tosscrosby,
Query is ok, everyone has different tastes.
If it was me I like to "normalize" my queries. Like the "select MAX(c2.Run_Date) .." should return a constant no matter how many times you put it in the query so you may want to make a variable for that before the query like DECLARE @whatever
@whatever = (select CONVERT(char,MAX(Run_Date),112) from DataRowCounts)
Then you can just use that variable throughout the query. You only use it twice here so it's not really a big deal but can be useful in lengthier queries. Also you aliased " (c.Row_Count - c1.Row_Count) as Diff". I believe in your order by you can just use "order by Diff". That won't work for the (c.Row_Count - c1.Row_Count) <> 0 in your WHERE clause though.
As far as books go, I like Wrox a lot but that's just my opinion.
Thanks!!
GP
April 1, 2008 at 8:59 am
Thanks to all for your suggestions. I went with Matt's design since it'll keep the query running optimally as the data grows. Much appreciated.
-- You can't be late until you show up.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply