This code is wildly open to SQL injection. If you don't know what I'm talking about, please google it.
Scratch that.
This code has no reason to be dynamic. It also has no reason to use NOT IN.
It just needs a simple approach:SELECT title, titleofcourtesy FROM employees WHERE employeeid <> @employeeid;
Now, if the code is more complex that what you have shown in here, unscratch the first part and read about SQL injection.