I have an accounting degree and passed the CPA exam. Worked as an accountant who knew computers, and discovered that relational database concepts were obvious. I've switched between accounting and...

We generally use DTS to place the raw data in a SQL table, then use a stored procedure to covnert the flat file data into relational data. The original feed...

Profiler is probably the most valuable tool I use for troubleshooting, especially with vendor provided applications. With Profiler, I can frequenetly determine the cause of an nissue and the fix...

And, to make it a bit faster, let's skip all of the even numbers after 2 (I suspect I've chosen a less than desirable way to do that)

DECLARE

@i INT,

@a INT,

@count...

One reason Americans drive bigger vehicles is the perception that they are safer, and will protect Mom and the soccer playing little ones better. I know a lot of folks...

If you have issues with employees logging in simultaneously on multiple machines, you may want to add another field to the login tracking table to track machine name using the...

That's a good point, and is pretty much our philosphy for a variety of reasons...

Change the insert statement to something like INSERT table UPPER(string). we do this in many of the apps we support.

Jeff has summed up the main role of a CEO in one word. I've seen CEO's that were great leaders, and I've seen CEO's that were mediocre leaders, but managed...

FORTRAN? I would have thought something like MUMPS would have been more appropriate. Or maybe FORTH (that would be a challenging development process).

I think the old data files used with BASIC could be considered flat files. They didn't really have anything in them except data, the definitions were in the programs that...

Without knowing the structure of your bitmaps, but assuming there is a product ID or something similar for each row, can you change the table to have a row for...

A developer who encrypts data, uses passwords to hide code, etc. will never get another engagement from me. That's just evil.

Jeff is correct, as usual, the duties of the contractor...

What happens whe you have the same application running several instances in different databases, which is how all of the apps I support work (same database structure many times, one...

I have colleagues who use GROUP BY clauses without aggregation in place of a SELECT DISTINCT. The results appear to be the same. I've always used a DISTINCT if I...