I'll add my voice. I LOVE DIY. I love working with wood, based on growing up with a father who was a master cabinet-maker (apprenticed in "the old...

Using "Table1, Table2 WHERE ..." is an older syntax. The ANSI standard for quite some time has been to use "Table1 INNER JOIN Table2 ON ..." (LEFT OUTER JOIN,...

With regards to light bulbs:

I have noticed that some CF bulbs work "better" than others, ie. they get brighter faster, the color spectrum is better. I don't have a...

I don't care about the point so much, but I want to see a little green check mark next to this one! (Bruises my ego to see those red...

I think Brandon Danner makes a good point. When I am in the zone, I don't even notice I have emails in my inbox until I "come out", which...

I agree with Steve's definition. I think one aspect of the Zone is that you are making progress on a problem, which is almost like bio-feedback and gains momentum....

What this question highlights is that an error is NOT thrown when you pass a parameter value that is too long into the function.

If you tried that with an INSERT,...

Maybe I mis-understood the question. If you are starting a new project, then yes, the first step would be to establish the standards, and start coding in a methodical...

I vote for quality. Two years ago, I had to tackle a whole system of code that was very consistent, but the code was a nightmare! It took...

Hmmm... I dug a little deeper in BOL and found something interesting.

On the main "clauses" page under "SELECT", it shows that the FROM clause is a required clause with almost...

Well, I checked BOL for both WHERE clause syntax and SELECT subquery, and neither shows this "feature".

Under the WHERE clause syntax, it simply shows the option to use a (subquery)...

My gut feeling is that it's not valid syntax (so you won't find it in BOL), but somehow SQL Server managed to parse it into an executable query.

I'd love to...

Yes, you would get the ambiguous reference if customerid were in both tables.

But if you look at the code that was attached to the solution, Customerid was removed from the...

I think this question was an example of some user bringing a piece of code to the DBA and saying, "This isn't working right. The program runs, but the...

I LOVE analogies, and this hits the nail right on the head!

Thanks for a smile that will last all day!