Steve,

I look forward to your QOD every day, not so much to see how much I know, but how much I DON'T know!! As a developer, I know T-SQL...

I figured "dob" was a trap to see if we were reading the choices fully.

Of course, no one would REALLY check a date field by using the like '%a%' method,...

Ok, this isn't from a book but rather from a movie, "Galaxy Quest" - but I've pulled it out and used it...

"Look, I've got one job on this ship --...

I really like Andy Warren's comments.

I don't keep track of points either at work or at home. I just give 100% to the best of my ability. I...

Matt Marston,

Thanks for the excellent examples on how the usage of the function can make a big difference! Definitely something I will keep in mind when building a query.

Agreed! I, too, really liked the garage-building analogy - I'll have to save that for future use. I also liked your comments about keeping the lines of communication...

Jeff,

Thanks for the great examples on generating running totals. Question: You mentioned that you have to include the "anchor" (or dummy) in the update statement in order for...

JJ B - You're right - I realized I was out of line, and deleted my post. I apologize.

(Your comment triggered a personal reaction from me - I have...

I also think it's morally wrong to turn a blind eye if you see it going on.

If you don't want to snitch, then you can always anonymously send a hint...

Sambo,

Stop beating yourself up over a decision you now regret. Many of us have made decisions we later regret. But you have to start making yourself happy in...

I really loved my undergraduate school (State University of New York at Fredonia), nice, small school with a pretty campus, very small town. I don't see that there would...

I totally disagree that being an in-house programmer sucks. I have been an "in-house programmer" for 14 of the last 19 years, and I have found plenty of opportunities...

An under-rated movie that I liked (although I think it came out in 2006) is "Stranger Than Fiction", with Emma Thompson, Will Ferrell, Maggie Gyllenhaal, Dustin Hoffman, Tom Hulce and...

In Barry McConnell's case, I think I would still define a primary key, using an identity column, assuming that rows are actively inserted into this table. -- well, now that...

I did work on a database where we had a table with jut one row, to hold the company's billing address, phone number, primary contact name, contact email, etc. ...