Mike C,

My point was that this was an editorial, not a technical article.  Yes, we need to try to help the juniors get through the death of their soul as...

I've had similar experiences as well, and I think anyone with more than 5 years of experience as a good SQL developer is going to have at least one of...

This just happened a few months ago.  It made me understand just how far removed us "IT dorks" really are sometimes from our users.

We had an all-hands meeting with all...

That worked.  Thanks for your help, Amit!

Jeff

Amit,

Thank you for your reply!  I didn't explain myself well enough in the original post though.  For example, I have 6 rows that I want to concantenate into one variable:

[UnNamed Batch].............................................:...

I've seen this exact error and every time we see it, we know we've hard-coded a path to an object within the package.  If one of the objects in the...

Ray,

That's what I was looking for.

Thanks!

Jeff

Chuck,

I wasn't making an ad hominem attack, I was addressing the people who were being religious zealots, hoping I could get them to see that they're not helping their argument.

But,...

Sean,

Good article, don't let the naysayers dissuade you from writing again.  The religious zealots that have been responding are just making your point for you. 

Religious Zealots,

I think Scott Adams...

My bad.

Topic: The practising the interview answers concept was a great idea.

Topic: swearing during an interview is a question to be dealt with as the reader sees fit. ...

I've been in interviews where the interviewer would embarrass Sam Kinnison.  Interestingly, she didn't keep her technical staff, and I've had recruiters call me about once a year asking me...

Thanks everyone for your input! We are using these suggestions to streamline the code.

KS,

It'll likely slow down your query, but try comparing UCase() = UCase (). That way you know that both are being compared equally.

It's ugly, but ...

Jeff

Wow. This has been one of those "every day I learn something new is a successful day" days.

Thanks to both of you!

Jeff

Bill,

Here is the dup checking based on your structures:

DELETE FROM cbDoNotCall

WHERE PhoneNum IN

(SELECT PhoneNum

...