Pivot


OK now I sorted out my problem with pivoting tables.

Thanks Access, no thanks to SQL Server :-((

It's a pity that you can do a so nice SQL Transform and Pivot function with Access and not be able to do it natively in T-SQL !

Other problem, and I reckon it was my first time on the matter, if you have to deal with stats, and I mean huge stats, it would be nicer to have a bigger number of columns, whatever the tool, Access, SQL or Excel.

By the way, if somebody know a spreadsheet application able to accept 3000 columns and 10000 rows, please let me know.

1 Comment

  • Yes. It is a shame that TSQL doesn't have crosstab. I'm hoping for support like this in Yukon(plus a lot of over cool TSQL enhancements).





    I don't know the specifics about what you are trying to solve but.....





    Anyways, if you are doing a lot of sophisticated analysis, you may want to look at OLAP services. You can build a cube that allows you to pivot on dimensions in your data.


Comments have been disabled for this content.