SQL guru question -- MIDRANGE-L

× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.

I have a file called headcount which gets data pumped to each month on
the 5th of the month.

FILEDATE EMPLOYEEID
EMPLOYEESTATUS LASTNAME

Jun 5 2008 11:36PM 110886
Active Wong

Filedate is a CHAR(26) Field.

EmployeeID is a Char(41) Field

EmployeeStatus is a CHAR(50) Field

LastName is a CHAR(30) Field

I also have a file called HCARCHIVE

With the same exact definition which has all the data from previous
months in it.

(on the 5th of the month...that Headcount file gets overwritten with a
new version)

What I am looking to do is automate a daily process that says something
like

Insert into HCARCHIVE

Only the records from headcount if max(filedate) in headcount >
max(filedate) in hcarchive.

So that way the hcarchive file gets updated with the latest data
automatically w/o me having

To remember to do it.

Hoping there is some sort of conversion to take a text like that

And convert it into a date that SQL will like.

I've been dabbling with CASE statements...and views...but not making
much headway.

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.