How to get count in output variable using a stored procedure?

SELECT COUNT(*) 
FROM tblRequest 
GROUP BY RequestStatusID

This query return the column having total requests respective status Id.

I want to get total requests count respective to its statusId in output variables using a stored procedure.

This Query return the Column having total requests respective status Id.

I want to get total requests respective to its statusId in a output variable using store procedure. i.e. it return a column like

---

|NoNameColumn|
|-----------|
21
|-----------|
6
|-----------|
14
|------ ----|

I Want to get each row value in a output variable separately(eg. SET @pending=21, Set @Sent=6, SET Discarded=14 ), using store procedure and vb.net code.

In simple words.. How can i get that row's values in a variable by the sql store procedur?

How can I Do It..?