Create proc Cntct
@InternalContact int=-1,
@MyContactActivities int=-1
as
BEGIN
select * from tbl_Contact
where (isnull(@InternalContact,-1)!=-1 and EmployeeID=@InternalContact) OR
(isnull(@MyContactActivities,-1)!=-1 and EmployeeID=@MyContactActivities AND RoleType = 'ATM')
OR (isnull(@MyContactActivities,-1)=-1 and isnull(@InternalContact,-1)=-1)
END
select all records any filter are not selected
if filter is not selected then pass -1 as default or dont pass that parameter