I have a Department source filter set up that works great on standard views. Some managers have multiple entries in the filter since they manage multiple departments.

I'm having trouble getting this to work correctly on a stored procedure. Only the first result from the source filter table is returned. So if a manager is in multiple departments, only one of those departments is returned to the stored procedure. Is there anyway I can get this to work?

I tried creating a table parameter in my stored procedure in the hope that YF would pass a table of values back to the procedure; however, it doesn't appear that YF accepts a parameter type of "Table". When creating a view based on this idea, I get an "Operand Type Clash" error on the parameter.

Thank you for your help,

Jason