Excellent, thanks for posting back.

Without sample DDL or test data, I've had to 'make something up'. This may or may not work as a result 🙂

select *

from employee e1

where ...

OK....

GilaMonster (3/16/2015)

---

The worst comment I've ever seen (as opposed to one I wrote) was in MS Access. The previous developer had written a lot of profanity-filled comments. Anyone who's worked...

Hi Dave, did this happen? If so,...

Michael.Ramirez (3/13/2015)

---

The only thing wrong w/ bad comments is no comments at all.

On a number of occasions I have found that various co-workers will add a comment that...

Maddave (3/13/2015)

---

Thanks all for your help. I didn't want to run the job all the time as it can be quite intensive and users could be searching historical data whilst...

Going off on a slight tangent, what about bad error messages?

I've just had this one in SSIS:

Executing the query "exec ..." failed with the following error: "Package execution failed...

Gary Varga (3/13/2015)

---

Yes!!! Commented out code. That's what source code control is for. If you need to leave a reference to old code then just leave a comment WHY it...

Superfluous comments are worse than no comments. You know the type:

--Find the average

select @avg = avg(x)

Reminds me of those people who, when doing presentations, just recite what is written on...

One simple solution is to schedule the package to run frequently and process any files it finds. If it finds no files, it completes without doing anything.

Might that work?

Nice work Stephanie. Are you involved in QA by any chance? If not, you should be:-)

You cannot 'ignore' this. You need to refine your match criteria to avoid it.

Brandie Tarvin (3/11/2015)

---

Ummm... That's a good question. Where would I look to find that information? (Someone else...

What sort of C# app is this? Windows forms, console, web etc?