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...

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...

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......

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...

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...

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...

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...

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...

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...

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....

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...

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...

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....

Heh... been there, done that, don't...

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...