Logical Query Processing Filters

Question

Post reply

Logical Query Processing Filters

Viewing 15 posts - 16 through 29 (of 29 total)

You must be logged in to reply to this topic. Login to reply

Tom Uellner SSCrazy Points: 2995 More actions · Answer 1

Count me in. Every reference I've seen has HAVING after the other choices.

dale_berta Ten Centuries Points: 1322 More actions · Answer 2

Apparently it wasn't just me. I swear I clicked HAVING...

Tom Uellner SSCrazy Points: 2995 More actions · Answer 3

TUellner - Friday, September 29, 2017 6:23 AM
Count me in. Every reference I've seen has HAVING after the other choices.

And this is the very same reference that was used for the question on September 22:
https://docs.microsoft.com/en-us/sql/t-sql/queries/select-transact-sql

RonKyle SSC-Dedicated Points: 31556 More actions · Answer 4

Getting a seemingly easy question wrong is a good jolt to start the day. But I'm certain based on the explanation, percentages, and comments, that HAVING is the correct answer. Hopefully this can be corrected. There was another incorrect question a few months ago that I don't know ever got resolved.

Matt Simmons SSCrazy Points: 2846 More actions · Answer 5

c'mon man! Group By is 5th in the list and Having is 7th. 7, by my reckoning, still comes after 5. Having is the correct answer. :blink:

Regards,
Matt

Bobby Russell SSCrazy Points: 2801 More actions · Answer 6

Another question with an incorrect "correct answer". Having is after group by my friend. I want my point! 😀

Aleksandr Furman Ten Centuries Points: 1213 More actions · Answer 7

Aleksandr Furman

Ten Centuries

Points: 1213

September 29, 2017 at 7:42 am

#1961632

WOW! 10% got it right. Congrats! LOL

Steve Jones - SSC Editor SSC Guru Points: 736212 More actions · Answer 8

Sorry, wrong box checked. Points awarded back and answer corrected

Sean Lange SSC Guru Points: 286590 More actions · Answer 9

LOL there is something amiss in the math here. These two parts don't even look they are from the same question.

_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

paul s-306273 SSChampion Points: 10730 More actions · Answer 10

Steve Jones - SSC Editor - Friday, September 29, 2017 7:42 AM
Sorry, wrong box checked. Points awarded back and answer corrected

Good man!

Steve Jones - SSC Editor SSC Guru Points: 736212 More actions · Answer 11

Sean Lange - Friday, September 29, 2017 7:49 AM
LOL there is something amiss in the math here. These two parts don't even look they are from the same question.

Yeah, I suspect when I award points back, the math doesn't recalculate correctly. I'll file a bug

TomThomson SSC Guru Points: 104773 More actions · Answer 12

Well, I'm glad I didn't look at this one before it was fixed - wrong questions tend to irritate me.

Tom

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 13

You know, it happens. We are human and mistakes happen. I looked at this question after it was corrected and got it right, then decided to have a look at the discussion.

Wow, all the complaints just hit my snowflake radar and all I could think of was "suck it up, buttercup."

I don't recognize many of the posters as ones who have written QotD, so if you have this isn't meant for you. If you think you can do better, join those of us who have. I have even gotten complaints on one of mine because apparently I wasn't clear enough in my explanation of the question or left out some tidbit of information.

RonKyle SSC-Dedicated Points: 31556 More actions · Answer 14

Wow, all the complaints just hit my snowflake radar and all I could think of was "suck it up, buttercup."

You may want to consider lowering the sensitivity of your radar. I didn't see that any of the comments were over the line. No one should have to suck up a wrong answer. Even in the Army, you just had to suck up the Army answer.

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 15

RonKyle - Saturday, October 7, 2017 9:34 AM
Wow, all the complaints just hit my snowflake radar and all I could think of was "suck it up, buttercup."
You may want to consider lowering the sensitivity of your radar. I didn't see that any of the comments were over the line. No one should have to suck up a wrong answer. Even in the Army, you just had to suck up the Army answer.

Didn't say anyone went over the line, just commenting on all the complaining. One person complaining should about do it, no need to pile on. And sorry, but the sensitivity on my radar is just fine. I did keep from going full tilt on it. Of course, if Jeff doesn't mind I'll grab a beer popsicle and go visit his dust bunnies if you prefer.