SET Versus SELECT

For a single variable value assignment, SET is the preferred method as it has a marginal performance advantage and is recommended by Microsoft. However, for multiple simultaneous variable assignments, a single SELECT statement is more efficient that multiple SET and/or SELECT statements.