Quote Originally Posted by mendhak
It is not you who queries the table. It is the query that tables you.

You're given a bunch of IDs, I'm assuming you know how to split them up and loop them up for the query.

For any given ID, simply query EmployeeProjectAssignment, do a

Code:
SELECT EmployeeID FROM EmployeeProjectAssignment WHERE ProjectID = '123'
Of course, since you'll be doing it in a loop, you should store the results from each iteration of the query into a temporary table.

Any further refinement on the query or resultset is a matter of your end requirements.
or you could pass it in as a comma delimited varchar parameter and convert it to comma delimeted ints

Code:
SELECT EmployeeID FROM EmployeeProjectAssignment WHERE ProjectID in (123, 312,124,125)
If you need help writing a function to convert it from varchar's to ints let me know, I think I have one laying around somewhere.

Keep in mind the varchar is limited to 8000 so it won't scale past that.