Jeff Moden

Forum Replies Created

Viewing 15 posts - 53,926 through 53,940 (of 59,089 total)

RE: Forum Etiquette: How to post data/code on a forum to get the best help

Having the test data in a ready to use format is great, but even if they provide it in a tabular format, it is better than nothing
Hi Lynn,
Thanks for the...
--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)

November 27, 2007 at 9:42 am

#754637
RE: Forum Etiquette: How to post data/code on a forum to get the best help

-=JLK=- (11/27/2007)
Nice article Jeff. Great "how to" without being to pushy. Nothing puts me off answering a post like having to much "up front" work so I can...
--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)

November 27, 2007 at 9:38 am

#754633
RE: Forum Etiquette: How to post data/code on a forum to get the best help

Andy Warren (11/27/2007)
Good write up and I agree there are lots of things users can do to help get their questions answered more effectively, and I do agree that there...
--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)

November 27, 2007 at 9:28 am

#754627
RE: Forum Etiquette: How to post data/code on a forum to get the best help

Loner (11/27/2007)
Actually I tried to answer that question, it was quite a challenge !!!
Sometimes it is hard to write a question, I read a question that is a page long...
--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)

November 27, 2007 at 9:08 am

#754614
RE: Forum Etiquette: How to post data/code on a forum to get the best help

Jeffrey Schmidt (11/27/2007)
I have only recently joined the forum and consider myself an intermediate sql developer (I'm getting back in the game after an hiatus).
I thought that this input was...
--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)

November 27, 2007 at 9:06 am

#754610
RE: Forum Etiquette: How to post data/code on a forum to get the best help

Kenneth Fisher (11/27/2007)
Great article Jeff. I much prefer to spend my time answering a question and not coming up with test cases.
Now its been awhile but as I recall...
--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)

November 27, 2007 at 8:58 am

#754604
RE: Forum Etiquette: How to post data/code on a forum to get the best help

Marie Wilkinson (11/27/2007)
I've never posted a problem because I have been too intimidated so this was a wonderful 'how-to'. Thanks.
Marie... you've just made this article worthwhile in my eyes. ...
--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)

November 27, 2007 at 8:37 am

#754595
RE: Forum Etiquette: How to post data/code on a forum to get the best help

Steve Jones - Editor (11/27/2007)
We can recommend it, but not sure many people will read it. Lots of people want to get an answer, post quickly, don't think about reading...
--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)

November 27, 2007 at 8:25 am

#754588
RE: Forum Etiquette: How to post data/code on a forum to get the best help

Doug Wittich (11/27/2007)
My pet peeve besides those given already: Poor choice of subject. So many "Newbie needs help" and "help me" threads abound. I'd much rather see a topical subject.
Spot...
--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)

November 27, 2007 at 8:17 am

#754584
RE: Forum Etiquette: How to post data/code on a forum to get the best help

GilaMonster (11/27/2007)
Nice. I'm also a little tired of people looking for a free lunch. Problem is, those who need it most will likely not be the people who read...
--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)

November 27, 2007 at 8:09 am

#754580
RE: Forum Etiquette: How to post data/code on a forum to get the best help

I suspect that the very process of presenting and describing a problem often makes the solution suddenly pop into the head.
Well said and absolutely true... the "Old School" method...
--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)

November 27, 2007 at 8:01 am

#754575
RE: Forum Etiquette: How to post data/code on a forum to get the best help

You raise a point that goes beyond just posting on forums - In the general office situation this is also common:
Funny that you should mention that, Bad Dog... We've...
--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)

November 27, 2007 at 7:52 am

#754564
RE: Forum Etiquette: How to post data/code on a forum to get the best help

Thanks for the feedback, Mike.
Yep... folks on news groups could learn a thing or two about how to post questions, as well. Some folks just don't understand how much...
--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)

November 26, 2007 at 11:04 pm

#754387
RE: Can this be done without cursors?

Was reviewing the results of the code above, and found a small boo-boo on the "Dense Percentile"... corrected in the following code... it did take it up from 28 to...
--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)

November 26, 2007 at 10:45 pm

#754374
RE: Forum Etiquette: How to post data/code on a forum to get the best help

Heh... guess I hit someone's "sweet" spot... got 1 vote with 1 star so far and they didn't even take the time to post what their complaint was 😀
--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)

November 26, 2007 at 10:09 pm

#754359

Viewing 15 posts - 53,926 through 53,940 (of 59,089 total)