Home Forums Article Discussions Article Discussions by Author Discuss Content Posted by Jeff Moden Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs RE: Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs

  • December 3, 2008 at 11:04 am

    #907044

    mlandry (12/3/2008)

    Whoa, using SQL to do cross-tabs really is "old school" (circa mid-90's or before.) It just wasn't designed for this.

    Do yourself a BIG favor and try Analysis Services. The MDX language is everything the SQL "select-groupby" ever wanted to be when it grew up. And it's far more expressive in terms of business reporting than SQL will ever be.

    I am sure that a similar article on how to use Analysis Services/MDX to do this for those of us who are T-SQL wonks only, would be very well received.

    [font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
    Proactive Performance Solutions, Inc.     [/font]    [font="Verdana"] "Performance is our middle name."[/font]