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

Question

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?

Reputation CAN be an integer, but sometime you need it as a float :) — Yossale, Aug 27 '12 at 11:28
possible duplicate of [How to set variable from a SQL query?](http://stackoverflow.com/questions/3974683/how-to-set-variable-from-a-sql-query) — StuartLC, Jan 10 '15 at 06:31

score 6 · Accepted Answer · answered Aug 25 '12 at 11:54

6

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

answered Aug 25 '12 at 11:54

1 Answers1