Are the posted questions getting worse?

Question

Are the posted questions getting worse?

Viewing 15 posts - 55,831 through 55,845 (of 66,712 total)

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

jasona.work SSC Guru Points: 50117 More actions · Answer 1

Thom A (9/16/2016)
ThomasRushton (9/16/2016)
These posts offering ways to get rid of weight loss? What? Eat more SPAM. Eat more pies. Icecream. Cakes.
All works for me... 😉
I never thought there'd be a day where I wished for a CAPTCHA field where there wasn't one 😛

Nah, the spammers have ways to beat CAPTCHA fields...

We need a SQL-specific method to weed out the spammers...

Something like this:

Write a SELECT query to join the following two tables, returning only data fields that exist in each
Table A
ID Data
1 A
2 B
4 D
Table B
PK Data
0 A
1 C
2 B

:hehe:

Neil Burton SSC-Insane Points: 23002 More actions · Answer 2

jasona.work (9/16/2016)
Thom A (9/16/2016)
ThomasRushton (9/16/2016)
These posts offering ways to get rid of weight loss? What? Eat more SPAM. Eat more pies. Icecream. Cakes.
All works for me... 😉
I never thought there'd be a day where I wished for a CAPTCHA field where there wasn't one 😛
Nah, the spammers have ways to beat CAPTCHA fields...
We need a SQL-specific method to weed out the spammers...
Something like this:
Write a SELECT query to join the following two tables, returning only data fields that exist in each
Table A
ID Data
1 A
2 B
4 D
Table B
PK Data
0 A
1 C
2 B
:hehe:

Or we could ask how to get the current time and date....

On two occasions I have been asked, "Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?" ... I am not able rightly to apprehend the kind of confusion of ideas that could provoke such a question.
—Charles Babbage, Passages from the Life of a Philosopher

How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537

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

BWFC (9/16/2016)
jasona.work (9/16/2016)
Thom A (9/16/2016)
ThomasRushton (9/16/2016)
These posts offering ways to get rid of weight loss? What? Eat more SPAM. Eat more pies. Icecream. Cakes.
All works for me... 😉
I never thought there'd be a day where I wished for a CAPTCHA field where there wasn't one 😛
Nah, the spammers have ways to beat CAPTCHA fields...
We need a SQL-specific method to weed out the spammers...
Something like this:
Write a SELECT query to join the following two tables, returning only data fields that exist in each
Table A
ID Data
1 A
2 B
4 D
Table B
PK Data
0 A
1 C
2 B
:hehe:
Or we could ask how to get the current time and date....

No that would eliminate entirely too many people that actually need help. 😀

_______________________________________________________________

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/

Thomas Rushton SSC-Insane Points: 22649 More actions · Answer 4

Sean Lange (9/16/2016)
BWFC (9/16/2016)
jasona.work (9/16/2016)
Thom A (9/16/2016)
ThomasRushton (9/16/2016)
These posts offering ways to get rid of weight loss? What? Eat more SPAM. Eat more pies. Icecream. Cakes.
All works for me... 😉
I never thought there'd be a day where I wished for a CAPTCHA field where there wasn't one 😛
Nah, the spammers have ways to beat CAPTCHA fields...
We need a SQL-specific method to weed out the spammers...
Something like this:
Write a SELECT query to join the following two tables, returning only data fields that exist in each
Table A
ID Data
1 A
2 B
4 D
Table B
PK Data
0 A
1 C
2 B
:hehe:
Or we could ask how to get the current time and date....
No that would eliminate entirely too many people that actually need help. 😀

What about setting it up as one of the QotDs?

"You must answer this question to proceed..."?

Thomas Rushton
blog: https://thelonedba.wordpress.com

Thom A SSC Guru Points: 99130 More actions · Answer 5

ThomasRushton (9/16/2016)
Sean Lange (9/16/2016)
BWFC (9/16/2016)
jasona.work (9/16/2016)
Thom A (9/16/2016)
ThomasRushton (9/16/2016)
These posts offering ways to get rid of weight loss? What? Eat more SPAM. Eat more pies. Icecream. Cakes.
All works for me... 😉
I never thought there'd be a day where I wished for a CAPTCHA field where there wasn't one 😛
Nah, the spammers have ways to beat CAPTCHA fields...
We need a SQL-specific method to weed out the spammers...
Something like this:
Write a SELECT query to join the following two tables, returning only data fields that exist in each
Table A
ID Data
1 A
2 B
4 D
Table B
PK Data
0 A
1 C
2 B
:hehe:
Or we could ask how to get the current time and date....
No that would eliminate entirely too many people that actually need help. 😀
What about setting it up as one of the QotDs?
"You must answer this question to proceed..."?

Apart from an attempt to make me feel stupid everyday, what happens on the weekends (or when Steve runs out of question ideas :P)?

Thom~

Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk

Thomas Rushton SSC-Insane Points: 22649 More actions · Answer 6

Thom A (9/16/2016)
ThomasRushton (9/16/2016)
Sean Lange (9/16/2016)
BWFC (9/16/2016)
jasona.work (9/16/2016)
Thom A (9/16/2016)
ThomasRushton (9/16/2016)
These posts offering ways to get rid of weight loss? What? Eat more SPAM. Eat more pies. Icecream. Cakes.
All works for me... 😉
I never thought there'd be a day where I wished for a CAPTCHA field where there wasn't one 😛
Nah, the spammers have ways to beat CAPTCHA fields...
We need a SQL-specific method to weed out the spammers...
Something like this:
Write a SELECT query to join the following two tables, returning only data fields that exist in each
Table A
ID Data
1 A
2 B
4 D
Table B
PK Data
0 A
1 C
2 B
:hehe:
Or we could ask how to get the current time and date....
No that would eliminate entirely too many people that actually need help. 😀
What about setting it up as one of the QotDs?
"You must answer this question to proceed..."?
Apart from an attempt to make me feel stupid everyday, what happens on the weekends (or when Steve runs out of question ideas :P)?

I was thinking more of a single QotD that all new users would be directed to. Think of it as a gateway question - one query to rule them all, or something...

Question: "Are you a spammer? (select valid query)"

Answer A: "SELECT 'Yes'"

Answer B: "SELECT 'No'"

Maybe even that would be too difficult for some.

Thomas Rushton
blog: https://thelonedba.wordpress.com

Steve Jones - SSC Editor SSC Guru Points: 736270 More actions · Answer 7

rodjkidd (9/16/2016)
Steve Jones - SSC Editor (9/15/2016)
Hugo Kornelis (9/15/2016)
Anyone here planning to (or thinking about) going to Live! 360 Orlando?
As a speaker, I have been given a special registration code that triggers a cheaper price $500 off the standard registration price (or $100 off the current Super Early Bird price).
See my blog if you want to know more, or register diectly using this link (with the code pre-populated).
I'll see you there. I was sure that I hadn't submitted, but somehow I'm on the schedule.
And that that right there Steve, is proof that you have done too much this year and need a break 😉
Rodders...

You are correct. I have two open calls for 2017 that I've decided to pass on because I don't want to travel this much next year.

Eirikur Eiriksson SSC Guru Points: 182912 More actions · Answer 8

ThomasRushton (9/16/2016)
Thom A (9/16/2016)
ThomasRushton (9/16/2016)
Sean Lange (9/16/2016)
BWFC (9/16/2016)
jasona.work (9/16/2016)
Thom A (9/16/2016)
ThomasRushton (9/16/2016)
These posts offering ways to get rid of weight loss? What? Eat more SPAM. Eat more pies. Icecream. Cakes.
All works for me... 😉
I never thought there'd be a day where I wished for a CAPTCHA field where there wasn't one 😛
Nah, the spammers have ways to beat CAPTCHA fields...
We need a SQL-specific method to weed out the spammers...
Something like this:
Write a SELECT query to join the following two tables, returning only data fields that exist in each
Table A
ID Data
1 A
2 B
4 D
Table B
PK Data
0 A
1 C
2 B
:hehe:
Or we could ask how to get the current time and date....
No that would eliminate entirely too many people that actually need help. 😀
What about setting it up as one of the QotDs?
"You must answer this question to proceed..."?
Apart from an attempt to make me feel stupid everyday, what happens on the weekends (or when Steve runs out of question ideas :P)?
I was thinking more of a single QotD that all new users would be directed to. Think of it as a gateway question - one query to rule them all, or something...
Question: "Are you a spammer? (select valid query)"
Answer A: "SELECT 'Yes'"
Answer B: "SELECT 'No'"
Maybe even that would be too difficult for some.

How about something elementary like

"Select the number which is the smallest number expressible as the sum of two cubes in two different ways"

Options:

1) 1024

2) 1729

3) 2048

4) 36

5) 35

Phil Parkin SSC Guru Points: 246965 More actions · Answer 9

Someone has been watching 'The Man Who Knew Infinity'.

The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin

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

Eirikur Eiriksson (9/16/2016)
ThomasRushton (9/16/2016)
Thom A (9/16/2016)
ThomasRushton (9/16/2016)
Sean Lange (9/16/2016)
BWFC (9/16/2016)
jasona.work (9/16/2016)
Thom A (9/16/2016)
ThomasRushton (9/16/2016)
These posts offering ways to get rid of weight loss? What? Eat more SPAM. Eat more pies. Icecream. Cakes.
All works for me... 😉
I never thought there'd be a day where I wished for a CAPTCHA field where there wasn't one 😛
Nah, the spammers have ways to beat CAPTCHA fields...
We need a SQL-specific method to weed out the spammers...
Something like this:
Write a SELECT query to join the following two tables, returning only data fields that exist in each
Table A
ID Data
1 A
2 B
4 D
Table B
PK Data
0 A
1 C
2 B
:hehe:
Or we could ask how to get the current time and date....
No that would eliminate entirely too many people that actually need help. 😀
What about setting it up as one of the QotDs?
"You must answer this question to proceed..."?
Apart from an attempt to make me feel stupid everyday, what happens on the weekends (or when Steve runs out of question ideas :P)?
I was thinking more of a single QotD that all new users would be directed to. Think of it as a gateway question - one query to rule them all, or something...
Question: "Are you a spammer? (select valid query)"
Answer A: "SELECT 'Yes'"
Answer B: "SELECT 'No'"
Maybe even that would be too difficult for some.
How about something elementary like
"Select the number which is the smallest number expressible as the sum of two cubes in two different ways"
Options:
1) 1024
2) 1729
3) 2048
4) 36
5) 35

I think I just got kicked off the forums. Either this is not expressed clearly or I am entirely too clueless because any answer by me on this would be a total shot in the dark.

_______________________________________________________________

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/

Thom A SSC Guru Points: 99130 More actions · Answer 11

Sean Lange (9/16/2016)
Eirikur Eiriksson (9/16/2016)
How about something elementary like
"Select the number which is the smallest number expressible as the sum of two cubes in two different ways"
Options:
1) 1024
2) 1729
3) 2048
4) 36
5) 35
I think I just got kicked off the forums. Either this is not expressed clearly or I am entirely too clueless because any answer by me on this would be a total shot in the dark.

I had to get an Excel Spreadsheet and formula up my "Cube Times Table" until I found the answer. I think Eirikur just obliterated 99% of the community. :hehe:

Thom~

Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk

Eirikur Eiriksson SSC Guru Points: 182912 More actions · Answer 12

Sean Lange (9/16/2016)
Eirikur Eiriksson (9/16/2016)
ThomasRushton (9/16/2016)
Thom A (9/16/2016)
ThomasRushton (9/16/2016)
Sean Lange (9/16/2016)
BWFC (9/16/2016)
jasona.work (9/16/2016)
Thom A (9/16/2016)
ThomasRushton (9/16/2016)
These posts offering ways to get rid of weight loss? What? Eat more SPAM. Eat more pies. Icecream. Cakes.
All works for me... 😉
I never thought there'd be a day where I wished for a CAPTCHA field where there wasn't one 😛
Nah, the spammers have ways to beat CAPTCHA fields...
We need a SQL-specific method to weed out the spammers...
Something like this:
Write a SELECT query to join the following two tables, returning only data fields that exist in each
Table A
ID Data
1 A
2 B
4 D
Table B
PK Data
0 A
1 C
2 B
:hehe:
Or we could ask how to get the current time and date....
No that would eliminate entirely too many people that actually need help. 😀
What about setting it up as one of the QotDs?
"You must answer this question to proceed..."?
Apart from an attempt to make me feel stupid everyday, what happens on the weekends (or when Steve runs out of question ideas :P)?
I was thinking more of a single QotD that all new users would be directed to. Think of it as a gateway question - one query to rule them all, or something...
Question: "Are you a spammer? (select valid query)"
Answer A: "SELECT 'Yes'"
Answer B: "SELECT 'No'"
Maybe even that would be too difficult for some.
How about something elementary like
"Select the number which is the smallest number expressible as the sum of two cubes in two different ways"
Options:
1) 1024
2) 1729
3) 2048
4) 36
5) 35
I think I just got kicked off the forums. Either this is not expressed clearly or I am entirely too clueless because any answer by me on this would be a total shot in the dark.

Elementary my dear Sean,

1729 = 1^3 + 12^3

1729 = 9^3 + 10^3

😎

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

Eirikur Eiriksson (9/16/2016)
Sean Lange (9/16/2016)
Eirikur Eiriksson (9/16/2016)
ThomasRushton (9/16/2016)
Thom A (9/16/2016)
ThomasRushton (9/16/2016)
Sean Lange (9/16/2016)
BWFC (9/16/2016)
jasona.work (9/16/2016)
Thom A (9/16/2016)
ThomasRushton (9/16/2016)
These posts offering ways to get rid of weight loss? What? Eat more SPAM. Eat more pies. Icecream. Cakes.
All works for me... 😉
I never thought there'd be a day where I wished for a CAPTCHA field where there wasn't one 😛
Nah, the spammers have ways to beat CAPTCHA fields...
We need a SQL-specific method to weed out the spammers...
Something like this:
Write a SELECT query to join the following two tables, returning only data fields that exist in each
Table A
ID Data
1 A
2 B
4 D
Table B
PK Data
0 A
1 C
2 B
:hehe:
Or we could ask how to get the current time and date....
No that would eliminate entirely too many people that actually need help. 😀
What about setting it up as one of the QotDs?
"You must answer this question to proceed..."?
Apart from an attempt to make me feel stupid everyday, what happens on the weekends (or when Steve runs out of question ideas :P)?
I was thinking more of a single QotD that all new users would be directed to. Think of it as a gateway question - one query to rule them all, or something...
Question: "Are you a spammer? (select valid query)"
Answer A: "SELECT 'Yes'"
Answer B: "SELECT 'No'"
Maybe even that would be too difficult for some.
How about something elementary like
"Select the number which is the smallest number expressible as the sum of two cubes in two different ways"
Options:
1) 1024
2) 1729
3) 2048
4) 36
5) 35
I think I just got kicked off the forums. Either this is not expressed clearly or I am entirely too clueless because any answer by me on this would be a total shot in the dark.
Elementary my dear Sean,
1729 = 1^3 + 12^3
1729 = 9^3 + 10^3
😎

I figured you meant something along those lines but since I didn't know the answer I have no idea how I would go about solving it. :w00t:

_______________________________________________________________

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/

Jacob Wilkins One Orange Chip Points: 27976 More actions · Answer 14

Sean Lange (9/16/2016)
Eirikur Eiriksson (9/16/2016)
Sean Lange (9/16/2016)
Eirikur Eiriksson (9/16/2016)
ThomasRushton (9/16/2016)
Thom A (9/16/2016)
ThomasRushton (9/16/2016)
Sean Lange (9/16/2016)
BWFC (9/16/2016)
jasona.work (9/16/2016)
Thom A (9/16/2016)
ThomasRushton (9/16/2016)
These posts offering ways to get rid of weight loss? What? Eat more SPAM. Eat more pies. Icecream. Cakes.
All works for me... 😉
I never thought there'd be a day where I wished for a CAPTCHA field where there wasn't one 😛
Nah, the spammers have ways to beat CAPTCHA fields...
We need a SQL-specific method to weed out the spammers...
Something like this:
Write a SELECT query to join the following two tables, returning only data fields that exist in each
Table A
ID Data
1 A
2 B
4 D
Table B
PK Data
0 A
1 C
2 B
:hehe:
Or we could ask how to get the current time and date....
No that would eliminate entirely too many people that actually need help. 😀
What about setting it up as one of the QotDs?
"You must answer this question to proceed..."?
Apart from an attempt to make me feel stupid everyday, what happens on the weekends (or when Steve runs out of question ideas :P)?
I was thinking more of a single QotD that all new users would be directed to. Think of it as a gateway question - one query to rule them all, or something...
Question: "Are you a spammer? (select valid query)"
Answer A: "SELECT 'Yes'"
Answer B: "SELECT 'No'"
Maybe even that would be too difficult for some.
How about something elementary like
"Select the number which is the smallest number expressible as the sum of two cubes in two different ways"
Options:
1) 1024
2) 1729
3) 2048
4) 36
5) 35
I think I just got kicked off the forums. Either this is not expressed clearly or I am entirely too clueless because any answer by me on this would be a total shot in the dark.
Elementary my dear Sean,
1729 = 1^3 + 12^3
1729 = 9^3 + 10^3
😎
I figured you meant something along those lines but since I didn't know the answer I have no idea how I would go about solving it. :w00t:

As worded, the correct answer is actually 91 (missing the usual restriction to cubes of positive integers) 🙂

Cheers!

Eirikur Eiriksson SSC Guru Points: 182912 More actions · Answer 15

Jacob Wilkins (9/16/2016)
Sean Lange (9/16/2016)
Eirikur Eiriksson (9/16/2016)
Sean Lange (9/16/2016)
Eirikur Eiriksson (9/16/2016)
ThomasRushton (9/16/2016)
Thom A (9/16/2016)
ThomasRushton (9/16/2016)
Sean Lange (9/16/2016)
BWFC (9/16/2016)
jasona.work (9/16/2016)
Thom A (9/16/2016)
ThomasRushton (9/16/2016)
These posts offering ways to get rid of weight loss? What? Eat more SPAM. Eat more pies. Icecream. Cakes.
All works for me... 😉
I never thought there'd be a day where I wished for a CAPTCHA field where there wasn't one 😛
Nah, the spammers have ways to beat CAPTCHA fields...
We need a SQL-specific method to weed out the spammers...
Something like this:
Write a SELECT query to join the following two tables, returning only data fields that exist in each
Table A
ID Data
1 A
2 B
4 D
Table B
PK Data
0 A
1 C
2 B
:hehe:
Or we could ask how to get the current time and date....
No that would eliminate entirely too many people that actually need help. 😀
What about setting it up as one of the QotDs?
"You must answer this question to proceed..."?
Apart from an attempt to make me feel stupid everyday, what happens on the weekends (or when Steve runs out of question ideas :P)?
I was thinking more of a single QotD that all new users would be directed to. Think of it as a gateway question - one query to rule them all, or something...
Question: "Are you a spammer? (select valid query)"
Answer A: "SELECT 'Yes'"
Answer B: "SELECT 'No'"
Maybe even that would be too difficult for some.
How about something elementary like
"Select the number which is the smallest number expressible as the sum of two cubes in two different ways"
Options:
1) 1024
2) 1729
3) 2048
4) 36
5) 35
I think I just got kicked off the forums. Either this is not expressed clearly or I am entirely too clueless because any answer by me on this would be a total shot in the dark.
Elementary my dear Sean,
1729 = 1^3 + 12^3
1729 = 9^3 + 10^3
😎
I figured you meant something along those lines but since I didn't know the answer I have no idea how I would go about solving it. :w00t:
As worded, the correct answer is actually 91 (missing the usual restriction to cubes of positive integers) 🙂
Cheers!

My bad, 91 should have been there as one of the invalid options

😎