SQL Server Set Value of Select Max or Sum Into Variable

Question

I try to make a stored procedure on SQL Server but when I set the select results into one variable it returns NULL.

example:

set @myvar= select Sum(Values) from myTable

but when I make a select without a function, the variable returns the expected value.

Answer 1

You have a mixture of the two ways to set a variable here.

It should be either.

set @myvar = (select sum(Values) from myTable)

OR my preference would be

select @myvar = sum(Values) from myTable