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...

I have to agree with Steve's comment that "It's a mutual meeting to determine if we want to do business together" for it is indeed a partnership. Too often...

At my previous job, I had no problem convincing my boss that such time was well worth it after I was able to come up with solutions to some very...

Please correct me if I'm wrong, but it seems to me that with this service Amazon is providing the hosting service with network and system administration such that they stand...

Steve,

I cannot agree more with your editorial. A hard lesson I learned many years ago (unfortunately not soon enough) was that we work to live -- not live to...

What has always worked well for me is to create a conversion script that encompasses not only DDL changes from one version of the database to another, but also DML....