When no records means ALL records : SQLServer

I have a performance problem that goes like this: HR users may view employees from certain locations. Something like: SELECT…