I have to agree that in most business organizations, the IT department is treated pretty much the same as the maintenance department. It's always seen as a cost center,...

Yet, not surprising when you consider that the parent table has 1.85M rows, the child table has 7.5M rows, and the validation table has 54K. The indexes were optimized...

Chris' solution works well in environments with low to medium data volume, but in the very high data volume environment I have it's too slow. I'm considering other alternatives.

Serg,

You are correct that it essentially transforms the INNER JOIN into a sub-query.

SELECT A.Item, B.Descr, C.Color

FROM (SELECT 1 as Item UNION ALL SELECT 2 as Item UNION ALL SELECT 3...

Unfortunately, that would filter out rows, not columns.

ChrisM@Work (1/13/2015)

---

There are two issues here which might be causing some confusion.

Firstly, the FROM list of your query, which looks like

SELECT ...

FROM parent

LEFT JOIN child to parent

INNER JOIN grandchild...

That's why I have a huge...

It is indeed a good question. However, I think the requirement of a primary key was a bit misleading as it can also occur when the field is simply...

That sounds like a fantastic idea Steve, which ironically is one of the many reasons why it will probably never happen.:ermm:

I meant that the date in the variable could have been any...

It's interesting to point out that for the correct solution the starting date did not have to be Dec 31 but could have been ANY date within 2013.

Pretty slick there,...

Thanks for the confirmation. I felt like I was getting the same run-around as well, but I arrived at the same answer you did.

I also noted the missing parentheses as well. I believe that adding a month before getting the day was simply a red herring to throw you off, but as...

Eric M Russell (9/4/2012)

---

A lot of guys at conventions tend to get drunk or for whatever reason feel free to let themselves go and behave in ways that they ordinarily...

I must admit that abuse, in any form against any victim, really gets my blood boiling! I worked alongside a really thoughtful, creative, and intelligent woman who was quite...