Low priority bugs? With users, there is no such thing! High priority is as low as it goes.

I am glad the bread crumb is there.

Speaking of bread crumbs, to those...

RANT:  We are 9 post into page 4.351 of this post.  But the link from the 'Active Threads' still takes me to the top of page 4,350.  Does...

it creates a new table every week when they import the file. The ceo wanted the server to not be on a network so the text file is placed...

Accidental is indeed a gentle description. Looks like the OS is the same, and the file being loaded, and everything else differs.

Finish your coffee before taking a peek....

Accidental is indeed a gentle description. Looks like the OS is the same, and the file being loaded, and everything else differs.

Finish your coffee before taking a peek. Or there...

Block the source - brilliant!

DBA is not a job that should be a title bestowed on someone lightly. They are indeed trusted to protect valuable information.

I can remember 20 years...

The client time system - if they had a trigger to write new time records to a file, that you had access to, would simplify a lot.

We used triggers to...

Each system likely has it’s own unique key for a Therapist and Student. Your system likely has a Client key.

If a Therapist is entering a record into your system, is...

A data warehouse is used to enforce business rules. It also normalizes the data.

Like Jeff points out, entry into one system, then populating the other, insures it is both done...

Time spent working with something does not always reflect how well you have mastered it.

You might want to write a simple Exists / Not Exists query and add something like...

Think carefully about updating.

A Chemical ID tells what it is. The part number is unique, very possibly tied to a vendor. Losing the status by updating them to be the...

You have better options you can see moving forward.

Even though you work in a small shop, security is important. They do not want uncontrolled access as they have a process...

No. But as a six year old, it was odd seeing the new neighbor have a one biting him, and then capture it in a test tube. He waited for...

Male mosquitoes do not suck blood anyways, so that statement means nothing. Why don’t they just experiment in the UK?

Hope it gets blocked. If something goes wrong, or horribly wrong,...

I had my own OU, to which I could create groups and add users. There was still a documented, audited process that was followed. Role in the business was part...