or use a dynamic temp table sub-select and the HAVING and GROUP BY aggregators.

But honestly, the GREATEST() function will work a lot easier. It's a very CPU intensive function. Writing it out using the dynamic temp table/HAVING/GROUP BY will execute quicker, but will be a lot harder to maintain.

I've never fell in love with any Joss stuff. I watched the first 4 episodes of Dollhouse and was unimpressed.

You're right on the cancellations though:
      Arrested Development
      Family Guy
      That 70's Show
      New Amsterdam
      King of the Hill
      Sarah Conner Chronicles

Still not as bad as ABC canceling Pushing Daisies.
     

Wanting to buy one for someone else's child that won't shut the f*** up and quit screaming when you're out trying to have dinner or watch a movie.

I always tell people:
      There is no shame in being ignorant. The shame comes in choosing to remain ignorant.

I believe the following quotes apply here:

There is nothing to fear except the persistent refusal to find out the truth, the persistent refusal to analyze the causes of happenings.

There is nothing to fear except the persistent refusal to find out the truth, the persistent refusal to analyze the causes of happenings.

Truth springs from argument amongst friends.

The great enemy of the truth is very often not the lie -- deliberate, contrived and dishonest -- but the myth -- persistent, persuasive and unrealistic

He that never changes his opinions, never corrects his mistakes, will never be wiser on the morrow than he is today.

well, pretty much all of them.

Moving up in your own company is a shot, but never forget what you can do in your spare time counts. Getting a master's degree is one "spare time" option, but others are Project Coding (such as Elance.com), getting on a fairly large and active Open Source project, or creating your own applications under your own name and putting them out for prospective employers to see.

If you are really serious about getting into a CS development position, I recommend the Open Source route because it will teach you how to code in a group setting and deal with code reviews, QA, and the whole enterprise process.