Thanks for the 2012 question. Keep 'em coming.

Nice question. I have actually used with ties once in a reporting query. Glad to see a question about a rarely used piece of syntax.

Thanks for the question Steve. This one forced me to do some research.

Thanks for the question. Learned something new!

I like this editorial because I have had this same conversation with coworkers before. You can only focus so hard on a task before you get worn out. Having some...

Very tricky, I missed it since you can enforce it through a trigger and I thought that was where the author was headed. That's what I get for assuming I...

Nice question Steve, learned something new today.

The name gave it away but I almost second guessed myself because I thought it was too easy. Like most, it is something that I basically ignored and should learn...

GSquared (4/3/2012)

Would have been even better if he didn't give any points for any answers. Then...

Interesting behavior.

I actually had to think about this for a second because I went almost all day yesterday without any references at all to 'April Fool's Day'. It was nice to...

Nice and easy one to end the week on. Thanks Steve!

Nice topic Jeff. Thanks for the article. I have seen this type of query written using the having + sums method, left join and exists/not exists methods but have never...

Thanks for the question Steve. I'm learning more about 2012 features every week.

I got confused with the wording too, but I too am happy to see some 2012 questions pop up.