Jeff Moden

Forum Replies Created

Viewing 15 posts - 46,801 through 46,815 (of 59,095 total)

RE: Convert Rows to columns so...

Heh... No matter where it's done, I'll still like to know why the BA thinks that listing an unknown number hospital rooms horizontally is the right thing to do on...
--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)

December 4, 2008 at 5:43 pm

#908029
RE: Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs

mtassin (12/4/2008)
However, the Cross-tab tool in it allows for incredibly flexible cross-tabs and is as easy as using Excel's Pivot table stuff.
Does that mean you're using the cross-tab tool in...
--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)

December 4, 2008 at 3:53 pm

#907987
RE: Convert Rows to columns so...

The question is still important because it will determine how the columns in the table are named and a couple of other things like whether to use A VARCHAR(8000) or...
--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)

December 4, 2008 at 6:57 am

#907548
RE: Recommended path for advanced training?

Oksana March (12/4/2008)
Dear Jeff Moden,
Please reveal the secret to me! What is the RBAR/Cursor question??? 🙂
When is it ok to use it... correct answer is NOT "When you think there's...
--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)

December 4, 2008 at 6:27 am

#907510
RE: Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs

IntellectYog (12/3/2008)
Jeff Moden (12/2/2008)
Comments posted to this topic are about the item
Hello Jeff,
Thansk for a nice articles on Cross-Tab.
I have one report format which is related to Dynamic...
--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)

December 3, 2008 at 11:02 pm

#907367
RE: Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs

ZA_Crafty (12/3/2008)
Well Indexes I still do in the procedures. Mostly our procs are just glorified selects, and we let sql decide which indexes to use, but on a few reports...
--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)

December 3, 2008 at 10:55 pm

#907363
RE: Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs

As usual, one'n'all, I'm humbled by your great feedback and suggestions. The exchange of ideas in these article discussions is the thing I look forward to the most.
With 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)

December 3, 2008 at 10:22 pm

#907345
RE: Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs

ZA_Crafty (12/3/2008)
Great Article.
Mostly we youngsters like to do the cross tabs in crystal. Yep, Crystal can be a pain with all it's bugs and "funny'isms", but a crosstab like...
--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)

December 3, 2008 at 10:13 pm

#907343
RE: Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs

Nicole Bowman (12/3/2008)
Jeff, thanks for another great article. Your articles are easy to understand and fun to read. I too would like an article on Analysis Services. I haven't used...
--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)

December 3, 2008 at 9:53 pm

#907337
RE: Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs

LSAdvantage (12/3/2008)
I have been getting my daily SQLServerCentral.com emails and ashamedly skipping by them lately. I just had other stuff going on and hadn't lurked here in a while....
--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)

December 3, 2008 at 9:35 pm

#907330
RE: Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs

rbarryyoung (12/3/2008)
Great article, Jeff. Like The Return of the King, it was well worth the wait! 🙂
Heh... that has a familiar "ring" to it. 😛 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)

December 3, 2008 at 9:15 pm

#907328
RE: Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs

jcraddock (12/3/2008)
I've had better luck writing code that writes my SQL. I wrote a set of code that you point at any table, it accepts any column within 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)

December 3, 2008 at 9:07 pm

#907327
RE: Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs

dphillips (12/3/2008)
Thank you for your efforts here Jeff. An article of this level takes hours to prepare, and the effort shows. Although I am an Analysis Server and...
--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)

December 3, 2008 at 8:57 pm

#907326
RE: Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs

mtassin (12/3/2008)
My favorite way to do cross-tabs is to cheat..
Put the data into a cross tab friend format (measures and values to break it out by)
and feed it into crystal...
--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)

December 3, 2008 at 8:47 pm

#907324
RE: Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs

mtassin (12/3/2008)
That was just an amazing read... learned some neat tricks that I didn't even think were possible (but in retrospect should have known)... very informative...
Thanks for the great...
--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)

December 3, 2008 at 8:45 pm

#907322

Viewing 15 posts - 46,801 through 46,815 (of 59,095 total)