update syntax for same table update

[skhanal]

join the table with itself (self join) and update the columns you want with the rows you want.

look in books online for UPDATE, there are examples which can guide you.