Pivot 2
In regard to my last Pivot blog, Scott Prugh replied:
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.
My answer is that OLAP services are too much complicated for something simple as Pivot. I hope too that Yukon will integrate some nicer features and break the limitations of SQL server 2000. This last one suppose to be much more powerful than Access !
It seems also that for some functions, Visual foxpro is also better than SQL Server.
So Microsoft, please no more parade with the fastest SQL engine in the world, with a lot of stats on how we can deal with zillions of records in 0.2548 microseconds.
No, just now some simple nice new features.