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

Question

I have an output parameter `@Counter` and a temporary table `#tmpUsers` Is it possible to assign the value of ``` SELECT COUNT(*) FROM #tmpUsers ``` To the `@Counter` output parameter? I have tried ``` SET @Counter = SELECT COUNT(*) FROM #tmpUsers ``` But this doesn't work for me

Accepted Answer

Try this way:

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

or

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

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

Solution

Problem