My First Stored procedure

create proc mentee
@Type int=0,
@domainName varchar(90)=''
as
begin

if @Type=1
begin
Select empName from empDetails  where empCode in(Select empReportingMgrId from  empDetails) and empDomainame LIKE '%'+@domainName+'%';
end
end