----------------------

I included the WOError table data above. In all cases, the VendorID in the WOError table matches a tblVendor. In all cases, the TimesheetID refers to a valid tblTimesheetMaster row....

Selects all the tblTimesheetWOErrors correctly, but now I'm getting nulls on "e" table when the WO is invalid, and Invalid WO when the WO Is Valid.

There will always be a...

I probably wasn't clear (or else, just as likely, I didn't understand your answer...)

Each event has an event type (typically, 'Reject' or 'Approve'.) The application knows to expect, say, two...

Lowell, not quite understanding. Here's what I think you said...

SELECT * from tblEvents

WHERE (tblEvents.EventDateTime >

(Select Max(EventDateTime) from tblEvents

WHERE EventType='Rejection' and...

So, all of this runs inside an SSIS package. When the user extracts a TSV file from the mothership and places it in a folder, the SSIS package extracts and...

This is a list of Part numbers (Items) linked with their (zero or more) Sources of supply (vendors, etc.) An item could have half a dozen sources, though typically zero...

@jeff,

I had a similar idea, basically using the identity column from the input table, I can insert that value into a spare column in each of...

Why give them the same Front End Access app? Recreate the app, deleting all the linked tables except the three views. They only see the linked tables on Access, not...

Perhaps I missed something. Aren't views used in instances like this to protect the underlying (DB2) database from mistakes? A view needn't be any more overhead than a query unless...

Sorry, I'm a newbie. What's a 'LUN', and what's a 'UAT'?

Perfect, I'll go try that. One more question, if you don't mind...

I have some nulls (",,") in one or more numeric columns in the .tsv input file. Are those going...

I'd love to have that learning experience.

VBS is very unsatisfactory. No editor, No debugger. I wrote the original program in VBA and deployed it as a standalone db (with...

Lowell, I continue to struggle with this. I downloaded zip-7, and wrote a vbs script to call it. Problem is, both the source and target paths have spaces in the...

OK, figured it out. When I ran the upgrade process, I appear to have neglected to run the process "as administrator". It ran perfectly, but failed key parts as a...

Looks like SQL Server 2005....