在SQL Server中使用与INTERSECT交叉的条件操作

I trying to write a stored procedure where I would like to test a passed in argument for certain value through an IF/Else statement and ultimately INTERSECT the result with another table. Something like the following as a non-working pseudo example.I trying to write a stored procedure where I wo