In this case yes. That's assigning the results of a subquery to a variable. and only works with a single variable and column.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability