Changing Rows to Columns

[Tania Louie]

Hi All,

I am trying to convert a table of data into columns (like you can in EXCEL using the copy and paste as 'transpose' button)

I have the below data:

Code Day Shift
502025 Monday Rostered
502025 Tuesday Rostered
502050 Monday Not Rostered
502050 Tuesday Rostered


And would like to make it look like this:

Code Monday Tuesday
502025 Rostered Rostered
502050 Not Rostered Rostered

Thanks!!

[Patrick Lambin]

Hello,

Please, could you have a look on this link ?

http://msdn.microsoft.com/en-us/library/ms140308.aspx

or

http://blogs.msdn.com/b/craigfr/archive/2007/07/03/the-pivot-operator.aspx

or

http://msdn.microsoft.com/en-us/library/ms177410(v=SQL.100).aspx

it is a feature which appeared with SQL Server 2005 , which is difficult to find in the SQL Server Book On Line

Have a nice day

[meabi]

Explained here , comment if needed

http://www.meabi.com/changing-a-column-in-to-a-row-in-sql/