kak.mca (11/8/2012)

---

RowId EName Project Time part Hours
Worked [14 Jan] [15 Jan] [16 Jan]
1 Emp 1 Project 1 14/1/2010 7.0
2 Emp 2 Project 2 15/1/2010 8.0
3 Emp 1 Project 1 16/1/2010 8.0

From the above table:
The above table is showing like
Emp 1 has worked for 7.0 hours on Project 1 on 14/1/2010.
Emp 2 has worked for 8.0 hours on Project 2 on 15/1/2010.
Emp 1 has worked for 8.0 hours on Project 1 on 16/1/2010.

I want to update the above table like below:
I want to update the column [14 Jan] column first row with 7.0 for Emp 1
I want to update the column [15 Jan] column second row with 8.0 for Emp 2
I want to update the column [16 Jan] column third row with 8.0 for Emp 1

Hence the result should be:
RowId EName Project Time part Hours
Worked [14 Jan] [15 Jan] [16 Jan]
1 Emp 1 Project 1 14/1/2010 7.0 7.0
2 Emp 2 Project 2 15/1/2010 8.0 8.0
3 Emp 1 Project 1 16/1/2010 8.0 8.0


Can anybody please suggest me how to write the query for the same in SQL Server 2005?