No problem. 🙂

If you need all possible months between two dates you could use something like this:

DECLARE @STRING VARCHAR(500),

@DATE1 DATETIME,

...

You're talking about only two dates?

If yes, the following should work for you:

DECLARE @STRING VARCHAR(500),

@DATE1 DATETIME,

...

Wow, that's odd.

Thank you for the information.

Interesting behaviour.

Best regards,

SQLRNNR (10/27/2011)

---

Ha - I...

Wouldn't a distributed partitioned view help achieve that?

Best regards,

Such an easy question since you are allowed to create columns of type GEOMETRY.

I'm amazed that 41% got it wrong.

Maybe it's because of the answer #4 that can lead to...

Yes, you're right. I was so sure that there were five values being passed.

Thanks for...

As Paul White would say, this is one of those questions that turns us into a T-SQL parser. 😀

But nice question.

Almost got it wrong because I couldn't see the error...

Ah, I see.

Try this:

SELECT * FROM dbo.TblTemp AS TMP1

INNER JOIN (SELECT MAX(Date) AS Date, Vendor FROM dbo.TblTemp

...

nfpacct (10/24/2011)

---

Sorry Andre,

I omitted one key item in the request. I would like the max date for by a field in my table called vendor.

The suggested query works as it...

You could use something like this:

SELECT Fields FROM dbo.MyTable

WHERE MyDate = (SELECT MAX(MyDate) FROM dbo.MyTable);

Best regards,

Hugo Kornelis (10/24/2011)

---

In the relational model, there is no order of a table. Without an ORDER BY, rows can be returned in any order the optimizer sees fit. So while...

wware (10/24/2011)

---

OK, I just got it, thanks to mtassin's explanation and my reread of Hugo's original explanation ("there are no other columns in the table.") In this scenario, because...

Oh, but they do teach us a lot. 🙂

Sometimes a QoTD followed...

caspersql (10/23/2011)

---

A prompt for password appears, however the cmd window no longer allows me to type in any text. Hitting keys on my keyboard does not have any effect...