• Eirikur Eiriksson, I read the info and it does not give a reason.

    technet

    It is recommended that SET @local_variable be used for variable assignment rather than SELECT @local_variable. For more information, see SET @local_variable.

    It most likely is because of the multiple rows, but it does not say that.