Simple update

[irehman]

I have a table T1 with following columns and data

ID----Name-----Salary-----Dept
1.....Joe
2.....Kelly
3.....Sam........300.......10
4.....Joe........500.......20
5.....Kelly......700.......20

Now I want to run update so Joe's salary and dept should be equal to other Joe which is 500 and 20, and Kelly's salary should be equal to other kelly's salary and dept.

I Have over 2000 rows that needs to be update, so I have to to run single statement.

Thanks in Advance