When is it ok to use it... correct answer is NOT "When you think there's...

IntellectYog (12/3/2008)

---

Hello Jeff,

Thansk for a nice articles on Cross-Tab.

I have one report format which is related to Dynamic...

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

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

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

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

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

Heh... that has a familiar "ring" to it. 😛 Thanks for the...

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

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

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

Thanks for the great...

Now, there's a tag line I...

Carla Wilson (12/3/2008)

---

Awesome! Having spent years using all sorts of languages to prepare cross-tabs, I really love the results here.

I, too, went back and read the discussion on the...

Paul DB (12/3/2008)

---

I also enjoyed the article. I like that you include applications and explanations of best some practices, e.g. the discussion on using a SELECT instead of an...