Sql server pivot rows to columns

select Firstname, Amount, PostalCode, LastName, AccountNumber
from
(
  select value, columnname
  from yourtable
) d
pivot
(
  max(value)
  for columnname in (Firstname, Amount, PostalCode, LastName, AccountNumber)
) piv;

Similar codes

1 vote279 views1 answer
Rows to comma separated values in mssql
SQL
0 vote267 views1 answer
Example of sql querry result sepapreted by comma
SQL
0 vote265 views1 answer
Sql find table by name
SQL
1 vote288 views1 answer
Sql insert for each distinct value
SQL
0 vote301 views1 answer
Work around for mutating problem in Oracle Triggers. Please check it out.
SQL
0 vote302 views1 answer
Mysql edit trigger
SQL
5 votes291 views1 answer
How to get all table names in sql query
SQL
11 votes288 views6 answers
Distinct sql
SQL
1 vote274 views3 answers
How to get date in sql
SQL
1 vote284 views1 answer
How to start with sql
SQL