Sean, that's another great idea. I tried it this morning, and actually have everything modularized and tidy.

My view performs the necessary unions, and I only need to add ONE LINE to all the existing procs... a line that is instantly evident in its purpose as well:

JOINvAccess a ON a.EmployeeID = e.EmployeeID AND a.UserID = @user-id

Thanks for helping me think through this and for your excellent suggestions.

Now, off to establish some usage patterns and begin looking at some indexes 🙂