count records t sql

Can anyone tell me how to count the number of records in an sql pull and store this as a variable in t sql

Code:

---

Declare @RowCount int
Select * from SomeTable
Set @RowCount=@@RowCount -- @@RowCount has the number of rows processed
-- in the last SQL statement

---

Is this what you meant?

perfect thanks