Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
tcarnahan
Starting Member
23 Posts |
 Posted - 2007-06-07 : 07:19:41
|
I am relatively new to SQL-Server. I was working in a company that used SS2005. Now I am with a company and client where SS2K is my only option. I know SS2005 had Analysis Services which allowed building hypercubes but I never got the chance to learn about it or use it. I am not that familiar with what SS2K has.I have no access to any OLAP tools. I have MS-Access and MS-Excel. My SQL-Server database has to crunch a table with thousands of rows.Having worked with MS-Access and MS-Excel for a long time, I know how powerful creating a pivot table is. I heard that SQL2005 had a T-SQL PIVOT function but never had the opportunity to use it. Know I have the need to do this in SQL2000.I have a lot of data so the method shown in BOL for cross-tab won't help me. The client changes the "column" and "header" categories on a regular basis, so I need something that will allow me to NOT hard code them but choose them dynamically like one would do in a hypercube.I have more than 5 categories for "row headers". I have currency for the data to aggregate. I have "pay periods" (26 of them) for my "column" headers, but not all 26 will be present until Dec 31, so that part has to be dynamic.
Question: Is there any feature in the standard S2K that allows one to create anything like a pivot table without massive coding (T-SQL function or technique or something like a hypercube ability)? Can you point me to something on the web that would explain how to get started?Many thanks ahead of time from a newbie!  |
|
|
mwjdavidson
Aged Yak Warrior
735 Posts |
Posted - 2007-06-07 : 07:54:32
|
| SQL Server 2000 ships with an OLAP engine - Analysis Services, the predecessor to SSAS - and related development tools.Mark |
 |
|
|
|
|
|
"Pivot" function or Analysis Service for SS2K??