SQL: Why can't I set a variable to the result of a query?
dataexplorer, sql
Solution
SELECT @totalRep = SUM(Users.Reputation) FROM Users
Problem
I'm trying to run this query on the SO Data Explorer: ``` DECLARE @totalRep float SET @totalRep = SELECT SUM(Users.Reputation) FROM Users ``` And I keep getting Incorrect syntax near the keyword 'SELECT'. What am I doing wrong?