I'll venture that the 'OR' clause in the join statement is the issue here. You're looking for values that are either NULL (at one end of the index range) or...

Great question. The referenced article has a really good overview of how this all hangs together, too. Definitely learned something today!

Good question - without the reversed order of the variables in the assignment of values, which was clearly designed to put a 'gotcha' into the mix. However, as many have...

Sad part is, she'll probably bust her backside and actually deliver the product by tomorrow, then be frustrated when it actually takes 3 weeks for the contract to be available...

Birthdays (as opposed to birth dates) are a surprisingly difficult data item to work with because they represent a point on a line (from January 1 through December 31) rather...

kramaswamy (8/29/2011)

---

Hm. So you're using the max of a string value. That works in all cases? Hadn't thought about trying that, 'cause I wasn't sure how SQL Server handles taking...

Since your working with what is essentially just text anyway, just continue treating it as text and do the following:

SELECT MAX(RIGHT(FourCharDate,2) + LEFT(FourCharDate,2)) FROM #TestValues

Result (from your sample data) is...

Nostalgia 😉

stars

awkward!

Like others here, I live on acreage with lots of animals, gardens and trees, few neighbors. For 12 years I worked mostly out of my home office (50 foot commute),...

Great question. Definitely learned something from this one.

Ninja's_RGR'us (7/20/2011)

---

Rob Schripsema (7/20/2011)

---

Toreador (7/20/2011)

---

My original thought was that there would be no rows returned as this was an insert.

But I then thought that was silly, and I was being...

Toreador (7/20/2011)

---

My original thought was that there would be no rows returned as this was an insert.

But I then thought that was silly, and I was being unfair on the...

parthi-1705 (5/26/2011)

---

hi this can be done like this also, no need of where condition to be joined with main table (TABLEDUPLICATE) .You can just delete CTE which will reflect in...