Ah ok, so you want to update a value to a new value and then back to it's old value.
It seems rather pointless, are you sure that's what the interviewer meant?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP