Are the posted questions getting worse?

Question

Are the posted questions getting worse?

Viewing 15 posts - 48,946 through 48,960 (of 66,738 total)

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

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

Alvin Ramard (6/19/2015)
Sean Lange (6/19/2015)
Anybody have the mind reading apparatus? I have misplaced mine and could use it over here. http://www.sqlservercentral.com/Forums/Topic1696091-2799-1.aspx
I think this is one of those threads where one should consider just walking away.

No kidding. I knew it wasn't to start well when the OP can't even be consistent with the formatting of the columns in the create table statement. It went downhill quickly from there with little to no chance of recovery. The biggest issue I see is the OP doesn't care enough about the details to lay out the problem and the code is just awful. Oh well...off the bigger and better things.

_______________________________________________________________

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/

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

Sean Lange (6/19/2015)
Alvin Ramard (6/19/2015)
Sean Lange (6/19/2015)
Anybody have the mind reading apparatus? I have misplaced mine and could use it over here. http://www.sqlservercentral.com/Forums/Topic1696091-2799-1.aspx
I think this is one of those threads where one should consider just walking away.
No kidding. I knew it wasn't to start well when the OP can't even be consistent with the formatting of the columns in the create table statement. It went downhill quickly from there with little to no chance of recovery. The biggest issue I see is the OP doesn't care enough about the details to lay out the problem and the code is just awful. Oh well...off the bigger and better things.

And there is more than one thread for the same question.

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

Lynn Pettis (6/19/2015)
Sean Lange (6/19/2015)
Alvin Ramard (6/19/2015)
Sean Lange (6/19/2015)
Anybody have the mind reading apparatus? I have misplaced mine and could use it over here. http://www.sqlservercentral.com/Forums/Topic1696091-2799-1.aspx
I think this is one of those threads where one should consider just walking away.
No kidding. I knew it wasn't to start well when the OP can't even be consistent with the formatting of the columns in the create table statement. It went downhill quickly from there with little to no chance of recovery. The biggest issue I see is the OP doesn't care enough about the details to lay out the problem and the code is just awful. Oh well...off the bigger and better things.
And there is more than one thread for the same question.

It seems to be two train wrecks in a head on collision.

_______________________________________________________________

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/

Alvin Ramard SSC-Forever Points: 41190 More actions · Answer 4

I think I'd classify it as a derailment instead.

Alvin Ramard
Memphis PASS Chapter[/url]

All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

ChrisM@Work SSC Guru Points: 186127 More actions · Answer 5

Sean Lange (6/19/2015)
Anybody have the mind reading apparatus? I have misplaced mine and could use it over here. http://www.sqlservercentral.com/Forums/Topic1696091-2799-1.aspx

I'm with Alvin on this one Sean - walk away. The OP's tardiness is Olympian to the point it almost looks deliberate. It's Friday. Beertime soon.

^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}

For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

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

ChrisM@Work (6/19/2015)
Sean Lange (6/19/2015)
Anybody have the mind reading apparatus? I have misplaced mine and could use it over here. http://www.sqlservercentral.com/Forums/Topic1696091-2799-1.aspx
I'm with Alvin on this one Sean - walk away. The OP's tardiness is Olympian to the point it almost looks deliberate. It's Friday. Beertime soon.

Agreed. I am just popping some popcorn now and watching others who may be brave to step over the stinking piles with imprints from my shoes. Beers are not nearly as close for me as they are for you.

_______________________________________________________________

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/

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

Sean Lange (6/19/2015)
ChrisM@Work (6/19/2015)
Sean Lange (6/19/2015)
Anybody have the mind reading apparatus? I have misplaced mine and could use it over here. http://www.sqlservercentral.com/Forums/Topic1696091-2799-1.aspx
I'm with Alvin on this one Sean - walk away. The OP's tardiness is Olympian to the point it almost looks deliberate. It's Friday. Beertime soon.
Agreed. I am just popping some popcorn now and watching others who may be brave to step over the stinking piles with imprints from my shoes. Beers are not nearly as close for me as they are for you.

I think I know what the OP wants, just not sure how the data is supposed to be queried to generate what the OP wants.

Alvin Ramard SSC-Forever Points: 41190 More actions · Answer 8

The Force seems to be weakening.

Alvin Ramard
Memphis PASS Chapter[/url]

All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

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

Lynn Pettis

SSC Guru

Points: 442467

June 19, 2015 at 1:01 pm

#1806805

Sorry, but I started screaming.

SQLBill SSC Guru Points: 51440 More actions · Answer 10

Lynn Pettis (6/19/2015)
Sorry, but I started screaming.

I don't blame you....too bad there isn't a virtual hammer to hit the OP over the head with.

-SQLBill

Alvin Ramard SSC-Forever Points: 41190 More actions · Answer 11

Lynn Pettis (6/19/2015)
Sorry, but I started screaming.

Lynn, get off the train tracks! 😀

Alvin Ramard
Memphis PASS Chapter[/url]

All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

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

_______________________________________________________________

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/

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

Sean Lange (6/19/2015)

I like the back of my ;BEGININATOR t-shirt, it says KEEP CALM AND SQL ON.

Any way, I gave the OP something to chew on.

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

Lynn Pettis (6/19/2015)
Sean Lange (6/19/2015)
I like the back of my ;BEGININATOR t-shirt, it says KEEP CALM AND SQL ON.
Any way, I gave the OP something to chew on.

I noticed that. Maybe it something close to what they want.

I haven't seen your ;BEGININATOR shirt. Post a pic?

_______________________________________________________________

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/

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

Sean Lange (6/19/2015)
Lynn Pettis (6/19/2015)
Sean Lange (6/19/2015)
I like the back of my ;BEGININATOR t-shirt, it says KEEP CALM AND SQL ON.
Any way, I gave the OP something to chew on.
I noticed that. Maybe it something close to what they want.
I haven't seen your ;BEGININATOR shirt. Post a pic?

I'll have to see if I have one. The t-shirt was a leaving theater present from the theater lead. He caught an ear full from me when he would start a CTE with a semicolon.

He got a kick out of my pet peeve.