how do you get just one result when you have a single group by a different dimension?

Looks like you want top(1)

 SELECT top(1) *
 FROM STORAGE_MOVEMENT 
 WHERE object_id = 43500 AND current_location != 6411 AND object_class = 'SAMPLE'
 ORDER BY move_number DESC