Today I got to know the most effective way to query the result from WHERE condition in a special scenario.
If you want to get the result set from Employee table
When Select All Department or When Select One Department (only two options are there)
You have to consider only WHERE column = <some value>
If select All no need to worry about WHERE column IN (<all values>) or else IF ELSE or SWITCH Conditions
Just simple you can get the result via OR logic
Remember only one statement or both statement has to be TRUE to return in OR gate.
WHERE DepartmentId in (@Dep) OR @Dep in (0)
when select all no value passes. So if pass 0 the logic change as
WHERE DepartmentId in (0) OR @Dep in (0) -> TRUE OR TRUE
Look how it simple. :)