T-SQL, updating more than one variable in a single select

March 25, 2023 by Tarik

Something like this:

select @var1 = avg(someColumn), @var2 = avg(otherColumn) 
from theTable