Search code examples
sqldataexplorer

SQL: Why can't I set a variable to the result of a query?


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?


Solution

  • SELECT @totalRep = SUM(Users.Reputation) FROM Users