Joins vs Exists. Neither is always right. Just be flexible.

This looks promising. I'm going to give it a try.

deroby (11/12/2013)

---

Hi there,

Thx for the article about what often turns out to be a brain-breaker for a lot of people starting out with SQL.. but... (there's always a but =)

Although...

Just now getting around to this one. That seems to be to my benefit because there are a great number of ideas her from readers. Thank you all so much.

Great training piece, thanks.

Wow. This is great. Thanks. I love it already.

We've been caught by the default problems too. We now spell out some of the settings at the top of each of our stored procedures.

Thanks for the insights on this one.

Thanks for the script. I'll give it a try.

Auditing for the purpose of solving a system problem seems reasonable. But auditing for legal reasons makes me feel I am being held hostage by the crooks. We do it...

A little deep for me. I'll pass this one on to the Admin.

Great script, thanks.

Thanks for the question. Maybe there should be an AuthenticationType.

Thanks for the question.

Thanks for the question.