Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
Hi, Can Sql Server generate very complex Pivot Result?

Answered Hi, Can Sql Server generate very complex Pivot Result?

  • Friday, March 15, 2013 1:07 AM
     
     
    Sign In to Vote
    0

    This is a telerik pivotgrid for silverlight, it group the data several times in silverlight client's memory.

    sometimes with very huge data, it's really not fast.

    I'm not familiar with bi or analysis service of sql server.

    Can sql server directly query the result like this, or does sql server has some tools which can generate result like this?

    I know pivot function, But I think pivot function can only aggregate only one column.

    Please let me know which tools or functions from sql server (2012, enterprice edition) I should learn about.

    Silverlight is the best tech for enterprise programming. Of course html5+js+css3 can do it too, but only takes 5-10 more times effort to do it.

     

All Replies

  • Friday, March 15, 2013 3:46 PM
     
     Answered
    Sign In to Vote
    0

    Hi there,

    Take a look at Analysis Services (BI or Enterprise Edition) as it will create aggregates for you and is made for this style of analysis.  Otherwise you could check out WITH CUBE or WITH ROLLUP in SQL, but you would probably need to use PIVOT, dynamic SQL, or custom code on the front end for showing data in columns.  

    cheers,

    Andrew

    Andrew Sears, T4G Limited, http://www.performancepointing.com

    • Marked As Answer by Dave Solenovex Saturday, March 16, 2013 2:25 AM
    •  
     
  • Saturday, March 16, 2013 2:25 AM
     
     
    Sign In to Vote
    0
    Thank you, that helps a lot.

    Silverlight is the best tech for enterprise programming. Of course html5+js+css3 can do it too, but only takes 5-10 more times effort to do it.