I had missed the fact that there was no select to return any rows. I was consentrating on what was put into the table. I tend...

Yep, I got it wrong, also. But to me I got it right because I figured out it would have inserted 5 rows, as started.

Thanks for the excellect questions recently Steve. Straight forward but makes one think.

Great question. Makes one think back to how design should be in a perfect world. And I didn't even have to use elimination becasue they were...

Thanks for the nice question. Interresting.

I saw that my answer was the same as 70% of the answers so figured I definently had it correct. Surprise, Surprise. Well we all...

Thank You sknox, wware and especially Hugo. With Hugo's explaination it all became clear.

Thanks to all,

Jerry

The discussion usually answer my questions but not this time. Doesn't "isnumeric(char(32)) as n" return 0? And if so wouldn't "select sum(n) from l" also equal...

Excellent article, makes one think about how we are doing what we do and how we come accross to everyone we work with\for. And then try to be...

That made my head swim. I was really confused after the explaination but as usual the discussion cleared it up. Thanks everyone.

Excellent question and the reference cited spells out the answers in detail.

Thanks sknox, it is clearer than it was this morning.

Jerry

Okay if any one of the rows returned by the where clause, when checked by the having clause, evaluates to true then they all are considered true? And...

honza.mf (5/25/2010)

It's another aspect of this question not mentioned yet: All characters inserted...

honza.mf (5/25/2010)

Michael Poppers (5/25/2010)

I was wondering why my SQL Query Analyzer output...