Finally I got an answer for this result. I write the query to update one row by row.

UPDATE EC SET Old_Store = ( SELECT TOP 1 New_Store FROM Employee_Change As EC1 WHERE EC1.Staff_Id = EC.Staff_Id And EC1.Transaction_Date < EC.Transaction_Date ORDER BY EC1.Transaction_Date DESC ) FROM Employee_Change As EC