How do convert rows into columns

See more:

SQL

server

i have emp table as follows

Empid Empname Month Salary

1 A 1 3000
2 B 2 5000
3 C 3 8000
4 D 4 9000
5 E 5 7000


from the above i want the output as follows


Empid Empname 1 2 3 4 5

1 A 3000 5000 8000 9000 7000


from getting a above output how to write the query in sql server

What I have tried:

i have emp table as follows

Empid Empname Month Salary

1 A 1 3000
2 B 2 5000
3 C 3 8000
4 D 4 9000
5 E 5 7000


from the above i want the output as follows


Empid Empname 1 2 3 4 5

1 A 3000 5000 8000 9000 7000


from getting a above output how to write the query in sql server