Are the posted questions getting worse?

Question

Are the posted questions getting worse?

Viewing 15 posts - 7,531 through 7,545 (of 66,712 total)

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

Jack Corbett SSC Guru Points: 184394 More actions · Answer 1

Barry,

Really sorry to hear about the health issues. Get well soon. And as Grant said, you need to be able to make it to PASS so we can meet.

Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question

ta.bu.shi.da.yu Hall of Fame Points: 3985 More actions · Answer 2

Barry - sorry to hear about your back 🙁 Get well soon!

Random Technical Stuff[/url]

Jeff Moden SSC Guru Points: 1004363 More actions · Answer 3

"You can lead a horse to the water..."

http://www.sqlservercentral.com/Forums/Topic774023-149-1.aspx

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

The Dixie Flatline SSC Guru Points: 53354 More actions · Answer 4

But Jeff ... What if they'd said "Pretty please, with sugar on top" ?? 😛

__________________________________________________

Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills

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

Jeff Moden (8/20/2009)
"You can lead a horse to the water..."
http://www.sqlservercentral.com/Forums/Topic774023-149-1.aspx

Persistant was she to get you to write bad code, hmm.

The Dixie Flatline SSC Guru Points: 53354 More actions · Answer 6

You gotta love it. He passes out a solution that performs faster AND (to me) reads simpler. But no, they still want him to rewrite "their" code.

__________________________________________________

Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills

spaghettidba SSC Guru Points: 105732 More actions · Answer 7

RBarryYoung (8/20/2009)
FYI, am in the hospital again, back problems (can't walk or even sit up), was admitted through the ER yesterday. as before, if you guys could cover for me here, I would be eternally grateful.

Sorry to hear you're not well, Barry.

I'm having problems with my back too (not that bad, fortunately). Damn Air Conditioning!!

All my best wishes, get well soon!

-- Gianluca Sartori

J Livingston SQL SSC Guru Points: 51550 More actions · Answer 8

Lynn Pettis (8/20/2009)
Jeff Moden (8/20/2009)
"You can lead a horse to the water..."
http://www.sqlservercentral.com/Forums/Topic774023-149-1.aspx
Persistant was she to get you to write bad code, hmm.

persistant...most defintely :w00t:

see here:

http://www.sqlservercentral.com/Forums/Topic774787-149-1.aspx

________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day

ta.bu.shi.da.yu Hall of Fame Points: 3985 More actions · Answer 9

I can't help it... I gave her a derived table with which she can do a group by on. I have no idea if it will work (no easy access to SQL Server to try it out!) but if it works I shudder to see what it does to the database... :crying:

Random Technical Stuff[/url]

Jeff Moden SSC Guru Points: 1004363 More actions · Answer 10

Bob Hovious (8/20/2009)
You gotta love it. He passes out a solution that performs faster AND (to me) reads simpler. But no, they still want him to rewrite "their" code.

It certainly makes no sense to me.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Jeff Moden SSC Guru Points: 1004363 More actions · Answer 11

ta.bu.shi.da.yu (8/21/2009)
I can't help it... I gave her a derived table with which she can do a group by on. I have no idea if it will work (no easy access to SQL Server to try it out!) but if it works I shudder to see what it does to the database... :crying:

You did? Where on that post did you do this? All I see is something about not being able to do a group by in the presence of an outer join.

I guess it really doesn't matter... she's hell bent on doing it her way.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

ta.bu.shi.da.yu Hall of Fame Points: 3985 More actions · Answer 12

Jeff Moden (8/21/2009)
ta.bu.shi.da.yu (8/21/2009)
I can't help it... I gave her a derived table with which she can do a group by on. I have no idea if it will work (no easy access to SQL Server to try it out!) but if it works I shudder to see what it does to the database... :crying:
You did? Where on that post did you do this? All I see is something about not being able to do a group by in the presence of an outer join.
I guess it really doesn't matter... she's hell bent on doing it her way.

I removed my original answer after a bit of research. Well, I learned something at least 🙂

The post is at http://www.sqlservercentral.com/Forums/FindPost774884.aspx. Who knows if it will work?

Random Technical Stuff[/url]

The Dixie Flatline SSC Guru Points: 53354 More actions · Answer 13

O Lynn, merciful patron Saint of Patience, tell us where we have failed.

Have we not asked the OP for data?

Have we not shown the OP the link to Jeff's article on forum etiquette?

Have we not written for them an example of how to provide data?

Yet still our cries and pleas go unheard.

Deliver us from the Dark Side which feeds us with frustration.

Deliver us from broken keyboards, and keyboard patterns embedded in our foreheads.

Deliver us from pork chops which fly by night.

So say we all.

__________________________________________________

Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills

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

Bob Hovious (8/21/2009)
O Lynn, merciful patron Saint of Patience, tell us where we have failed.
Have we not asked the OP for data?
Have we not shown the OP the link to Jeff's article on forum etiquette?
Have we not written for them an example of how to provide data?
Yet still our cries and pleas go unheard.
Deliver us from the Dark Side which feeds us with frustration.
Deliver us from broken keyboards, and keyboard patterns embedded in our foreheads.
Deliver us from pork chops which fly by night.
So say we all.

ROTFLMAO !! This is good Bob. I only wish I could come up with things like this! Great way to start the day, with a big smile. 😉

ta.bu.shi.da.yu Hall of Fame Points: 3985 More actions · Answer 15

You know what everyone was saying about bad answers... well, take a gander at the following Microsoft KB:

XL97: Data Not Returned from Query Using ORACLE Data Source

And I refer you to Method 2:

---

Method 2: Move Your Mouse Pointer

If you move your mouse pointer continuously while the data is being returned to Microsoft Excel, the query may not fail. Do not stop moving the mouse until all the data has been returned to Microsoft Excel.

NOTE: Depending on your query, it may take several minutes to return the results of your query to the worksheet.

Random Technical Stuff[/url]