table selection and place in to another table only selected records with out stored procedures.

see the following snippet

Declare @regcount int
Set @regcount=(Select Count(EmpNo) From TableName Where EmpNo=@empno)
if(@regcount is null)
Set @regcount=0
else if(@regcount<2)//will give only 2 records selection you can change it
// Your operation

else
Raiserror('message',15,1)