GSquared, thanks for the suggestion. I agree that one learns more when one takes the time to explore on ones own. I will certainly try to do that within the...

Thanks, G-Squared. That's what I thought, but I wasn't positive. And yes, I was only asking if this was true if they were in the same update statement. I'm glad...

I agree that a high percentage of the population here has been involved in music at some point in their lives. But I believe that many of the points mentioned...

Steve Jones - Editor (5/14/2008)

---

I've seen queries similar, and people would write them. The fact that it compiles is a bad thing in my mind.

Someone submitted this and I think...

LOL. I love analogies, too. Finding the right one (as you did) is fantastic.

I believe answer 2 is incorrect. If customerid is a column in BOTH tables, you get an error of ambiguous column name.

Since I'm not a DBA and have no aspirations to become one, my knowledge is insufficient to write articles or join in on very many discussions. I work in higher...

Thanks, Kirk for a well-written explanation of CTEs.

Great discussion, too. Thanks!

At our institution, we no longer distinguish between sick, personal, vacation, etc. It's just PTO (personal time off). It really eliminates the issue of taking "sick" days for recreation plus...

Fascinating. PBS could have used him in their "Secrets of the Dead" series.

Thanks Jeff. Great article and...

Thanks for a helpful article. Good discussion, too!

Julie

IF one deals with multiple vendors for SQL databases (i.e. software that uses SQL databases), one may need to receive approval from the vendor that the patch has been tested...

Janet Evanovich's Stephanie Plum stories (One for the Money, Two for the Dough, etc.) are laugh out loud funny. Light reading. Great escapism.

The Spirit Catches You and You Fall Down...

For work, I'd like SQL Prompt and training with SQL 2005. With friends, we recently starting contributing to charities in their honor rather than buying each other gifts. We look...