In the stored produces some time we need to use multiple filters. Some have value and some don’t have any value. For that we usually write different IF condition to execute the select statement. In SQL have simple way to use one select statement to use multiple where condition or multiple filter.
CREATE Procedure [dbo].[YourSP]
IF @ Empid = ''
Set @ Empid = null
IF @ Edept= ''
Set @ Edept = null
select * from Employee Where ((@Empid is null or EmpidID = @ Empid) and (@Edept is null or EDept=@Edept))