Setting the output parameter to count () in the sql stored procedure

Question

I have an output parameter @Counter and a temporary table #tmpUsers

Is it possible to assign a value

 SELECT COUNT(*) FROM #tmpUsers 

To the output parameter of @Counter ?

I tried

 SET @Counter = SELECT COUNT(*) FROM #tmpUsers 

But this does not work for me

Answer 1

Try as follows:

 SELECT @Counter = COUNT(*) FROM #tmpUsers 

or

 SET @Counter = (SELECT COUNT(*) FROM #tmpUsers)