Agree, I must, with Gail. Hard it is to help with what has been provided.

It would help if you show us what you are doing. Provide us with the DDL for the table(s) (CREATE TABLE statements) involved, some sample data the demonstrates what...

Agree I must with Chris. Help it would if OP would provide table DDL, sample data, and expected results.

I still think it would help us if you showed us the whole problem. We can't see what you see from here and as much as we try, we...

kaspencer (1/5/2010)

---

I couldn't see the answer to this question, and so I guessed "C" which happened to be correct.

However, when I tried the three options on my system, "C" returned...

It would help if you would show us everything instead of just small pieces. Also, what is the expected results you are looking for in the end?

It's a long way to Taragon.

Article you really should read. The more you do for us, the more we will do for you.

Agree I do with John.

For better answers to your question, read you might the first article referenced below I have regarding asking for assistance.

Table structures, sample data, expected results would...

A true master knows when they know less than others think they know.

The trick is knowing where and how to find the answers to the questions where your knowledge lacks.

PhilPacha (1/4/2010)

---

There's a problem with lmu's solution if your RecordedTime column contains a time component. If you run his logic at 3:00 PM on Jan 1, it will pick...

Okay, now THAT is a Scary DBA (with apologies!).

But please remember, certification is not a replacement for hard earned experience.

How Savory!

That is a Myrrh detail.