sql server - sql copy data in column from one row to all others -

i have sql table column need copy data 1 specific row other rows. how can this?

ie: update table set other rows in column = row1 column2 = unique identifier. hope makes sense.

data example of table user:

code     pass         joe      degree1 sue      degree2 pat      degree3 

basically, want take data in column pass joe , copy other users (sue , pat), when said , done, pass should equal "degree1" 3 users.

declare @updatevalue <yourcolumndatatype> select @updatevalue = updatecolumn yourtable uniquecolumn = uniqueidentifier  update yourtable set updatecolumn = @updatevalue uniquecolumn <> uniqueidentifier