The select construct can either assign a value or read values; it can’t do both. Pick one.

Example:

select @id = Id, Name
from ...

Decide whether we’re trying to update the local variable, or read results.