There are two basic ways of moving data files in SQL Server 2005. You can detach the files, copy them to the new location, and then attach them back. You...

I found the reason given lacking as well and was thinking along the lines of the other comments regarding case.

Did learn about the ANY clause though.

Sorin Petcu (6/13/2008)

---

You're right Matt! Anyway, I just received a good bonus today from my company, before to go into my holiday. Exactly I would expected! So, your responses are...

I wanted to answer none of the above as well. I feel everyone should get 6 points because any answer they give is what they expect, not what others expect!

I don't remember the syntax off hand but there is a varchar(maxvarcharsize) that can be used.

My first problem is the question is too broad and I chose Yes without thinking about it as there is almost always several ways to do the same thing. The...

Just to clarify, Because I am unclear as to his original intent.

Your suggestion will return only consultants with a record that has the one selected max effective date.

My suggested tweaks...

What if you get rid of the DISTINCT as it is redundant?

Also shouldn't the group by match the fields, so change the group by c fields to the same value...