hello can anyone tell me the code to unpivot the table
(comments are locked)
|
It would really help if you provided the dataset that you want to UNPIVOT but here is a simple example for this set of data... Which is generated with the following CTE SQL...
The UNPIVOT command would then look something like...
This would output a resultset like so... I hope that helps you out.
(comments are locked)
|
The first place to look is BOL - PIVOT and UNPIVOT are explained here : http://msdn.microsoft.com/en-us/library/ms177410.aspx
(comments are locked)
|
to unpivot which table? I think you will need to be more specific with your question to get an answer that will help you in detail.