question

SuadShamsi avatar image
SuadShamsi asked

Transpose Rows to Columns

I have the table with this information. No. CPR Name Modules 1 80000 SS TT1 1 80000 SS TT2 1 80000 SS TT3 2 52222 MM TTMd 2 52222 MM TTGH 3 6666 BB YUH 3 6666 BB BBG I want the data to be transpose as the following: No. CPR Name Modul1 Modul2 Modul3 1 80000 SS TT1 TT2 TT3 2 52222 MM TTMd TTGH 3 6666 BB YUH BBG please help me to find a way for doing this. Note that all columns are Varchar type.
sql-server-2005
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.