I also assumed that the question was mistyped, that 2008 was intended, rather than the answers being wrong. Maybe the question should be updated to read 2008 rather than 2005?

It's not working because you're including the score which can differ. Think about your groupings as concatenations so 80Mike is different to 90Mike. What you need is exactly one row...

I did even worse, I went into Access, opened the design of a table, saw that my character type fields are formatted "text" so opted for "text."

I have to admit...

Leo Hesen (5/27/2009)

---

Made the obvious mistake myself.

My assumption:

1 Not correct

2 Not correct

So it had to be 3 without examining this answer properly.

Reminded me to not jump to conclusions to...

Steve, you have my sympathy - back ache is horribly inhibitive and the only way to "ease it out" is to use it which is the last thing you want...

I agree that the version should be stated in the question.

This works fine in 2000 so long as you create the table defining the column as varchar. To get the...

Is the problem with a blanket set of rules not that DBAs work in varying industries? Many of these industries, particularly those with personal data, are covered by their own...

I don't know if this is the answer, but the first thing I would check is the format in the data source. Excel's quite clever at showing things that look...

I also had to move a lot of existing queries into SQL and, at the start, ended up tying myself up in knots. My advice, from experience, would be to...

There's not really enough information here to answer specifically.

If it's a filter, you'll know this because it is a table with a drop down box on every column header, go...

Hi, I am making an assumption here that cast works the same in 2000 and 2005 so forgive me if I'm wrong, but casting as numeric or decimal will produce...