If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

The above sample is provided for conveying the concept I am trying to achieve.
In the above sample I am updating only 2 field but in the real query I am
updating 20 fields. I want to take fltLabor and fltMatl from record with
ID 559639 and update fltLabor and fltMatl record with ID 1001. The record
structure is identical as the two records reside in the same table (tblCostCodeDetl2).

I do not want to use a #temp table if possible (I already know how).
I do not want to use multipe select statement (I already know how).
I would like a solution that would do the update in one shot.