Select a row count to a local variable in SQL!

SELECT @X=COUNT(Id) FROM Users WHERE Id not like @Id and Email = @Email