Jeff Moden

Forum Replies Created

Viewing 15 posts - 48,676 through 48,690 (of 59,095 total)

RE: GOTO vs WHILE

DB_Andrew (8/19/2008)
Instead of preaching your “RBAR” cliché and putting people down for doing it the wrong way why don’t you get off your soap box and make yourself helpful for...
--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)

August 19, 2008 at 8:36 pm

#860372
RE: The Basics of Sizing a SQL Server Database

Martin Goebbels (8/19/2008)
Gentlemen, that discussion is very interesting, but I'd like to post another issue:
Now I know the the disk space I need, but and the rest? I mean, 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)

August 19, 2008 at 7:22 pm

#860351
RE: Cross Tabs and Pivots, Part 1 – Converting Rows to Columns

There's a bunch of good folks that took the time to "drop in" with some GREAT encouragement and tips on what I'm doing right that I haven't responded to personally......
--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)

August 19, 2008 at 7:00 pm

#860346
RE: Cross Tabs and Pivots, Part 1 – Converting Rows to Columns

Slope (8/19/2008)
Nicely written article, Jeff! I'm new to this forum so don't know if you've covered it already, but it might be nice to see a counterpart to this...
--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)

August 19, 2008 at 6:56 pm

#860343
RE: Cross Tabs and Pivots, Part 1 – Converting Rows to Columns

JJ B (8/19/2008)
Once again, such good explanations/teaching.
I'm like an earlier poster. I haven't been able to find an advantage to the pivot syntax. (Though unpivot came in handy...
--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)

August 19, 2008 at 6:41 pm

#860340
RE: Cross Tabs and Pivots, Part 1 – Converting Rows to Columns

Jack Corbett (8/19/2008)
Thanks Jeff. My blog is http://www.wiseman-wiseguy.blogspot.com. It's also at the bottom of all my posts on the little button that says "blog". 😛
That's where I put...
--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)

August 19, 2008 at 6:35 pm

#860339
RE: Cross Tabs and Pivots, Part 1 – Converting Rows to Columns

Nicole Bowman (8/19/2008)
Thanks for a very clear article. I have been wondering what the differences might be between cross tab and pivot but haven't found the time to investigate. Now...
--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)

August 19, 2008 at 6:23 pm

#860335
RE: Cross Tabs and Pivots, Part 1 – Converting Rows to Columns

Jeffrey Williams (8/19/2008)
However, if you want dynamic number of years then you are going to need to use dynamic SQL to generate the query. I believe Jeff is going...
--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)

August 19, 2008 at 6:21 pm

#860334
RE: Cross Tabs and Pivots, Part 1 – Converting Rows to Columns

ruben ruvalcaba (8/19/2008)
Great Article! pivots are great because it exposes the same information in many ways very usefull ....
In your sample you build a pivot when you already now...
--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)

August 19, 2008 at 6:19 pm

#860333
RE: Cross Tabs and Pivots, Part 1 – Converting Rows to Columns

s.c.simmons (8/19/2008)
I was pleased as punch to see that in SQL Server 2005 when my company upgraded. Then I wrote my first queries using it, and saw the performance hit....
--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)

August 19, 2008 at 6:16 pm

#860332
RE: Cross Tabs and Pivots, Part 1 – Converting Rows to Columns

Jeffrey Williams (8/19/2008)
Hey Jeff, good article - reminds me of a fairly recent discussion we had on this forum 😀
Nice to see that you put what we learned in that...
--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)

August 19, 2008 at 6:12 pm

#860330
RE: Cross Tabs and Pivots, Part 1 – Converting Rows to Columns

sunjiulu (8/19/2008)
hi Richard,
that xml code works like a charm, thanks for sharing.
jiulu
Richard Fryar (8/19/2008)
In response to sunjiulu's query, you don't need a cross-tab.
A bit of magic with XML is all...
--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)

August 19, 2008 at 5:51 pm

#860329
RE: Cross Tabs and Pivots, Part 1 – Converting Rows to Columns

Jack Corbett (8/19/2008)
Hey Jeff, good article. It's funny I have answered several forum questions recently using a Case embedded in an aggregate. They weren't crosstabs exactly, but similar....
--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)

August 19, 2008 at 5:41 pm

#860328
RE: Cross Tabs and Pivots, Part 1 – Converting Rows to Columns

Peter Smith (8/19/2008)
Jeff, I've copied your code. Maybe it will reduce the bad language as the upscaling to SQL takes place. Thanks for the article.
Heh... been there, done that, don't...
--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)

August 19, 2008 at 5:31 pm

#860327
RE: Cross Tabs and Pivots, Part 1 – Converting Rows to Columns

Chris Morris (8/19/2008)
Really nice to read, Jeff, and absolutely spot on.
I've had to do pivots in the last couple of weeks, with an unknown number of output (transposed) columns with...
--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)

August 19, 2008 at 5:29 pm

#860326

Viewing 15 posts - 48,676 through 48,690 (of 59,095 total)