Implement simple SQL Server Pivot table

[MrPeds]

Hi,

I have been asked to produce a database table,but to pivot the information.

Is a SQL Server Pivot table the same as in Excel?e.g. summarising all the information, or are there any special TSQL statements or commands that I can use?

The reason that I have been asked to do this is so that we can use some of the data as dimensions in a cube.

Has anybody else done this? Are there any useful guides or tutorials that people have found useful.


Thanks,

MrPeds