LIKE the question on INTERSECT. Basic, but very useful. Thanks Ron!

Good question. Thanks Igor.

If you want numbers for your records in a SELECT, why not use:

ROW_NUMBER ( ) OVER ( <partition_by_clause> <order_by_clause> )

in the query?

Isn't this a repeat of the question Steve posted 02/22/2012?? (Or at least the first part of Steve's question.)

My experience is that $ spent on Valentine's Day, or any odd Wednesday, on flowers/jewelry/chocolate/stuffed animals/etc. provides a...

My old boss thought I was being too neat when I put each join criteria on a separate line and each...

I like the oddball questions. I think well outside the box. (My current boss once said, "You're so good at thinking outside the box, you don't even know there's a...

Doctor Who 2 (2/3/2014)

---

Interesting article. I agree that networking is probably the best thing (it's never worked for me, but that's more likely because I'm not as good at it...

Two out of three from a pdf file I downloaded from Microsoft. Good question. But a little rough for a Monday after I drank 4 sodas (high fructose corn syrup!)...

My resume is a patchwork of a broad spectrum of experience and training. I have a demonstrated history of being able to do a lot of things well, and to...

Jeff Moden (1/30/2014)

---

Thank you for the kind words, Thomas. :blush: If I ever need a couple of PR guys for something really important, you'll definitely be one of them....

Jeff Moden (1/30/2014)

---

Thank you for the kind words, Thomas. :blush: If I ever need a couple of PR guys for something really important, you'll definitely be one of them....

When I went to review this spackle, I found the current rating was "Good". Can't agree. Jeff has, as usual, taken a problem of some import, broken it down into...

Thanks for the question Igor. I thought it was pretty much common sense. Although I note that quite a few went for answer C. I assume this is mostly due...

Michael Meierruth (1/30/2014)

---

I suppose Amazon's 1-click technology is more of an idea and cute name than a technology. And maybe Amazon really wants to hold on to that term '1-click'...

Others have noted some small errors in the article. However, I think that on balance it does a good job of educating people about different ways to use sub queries....