I ended up being away from this project for a while, but I found a workaround for the specific problem I described. However, I ran into a somewhat similar...

On the stored function side, I tried this:

CREATE FUNCTION rbperm

(@project_id int = 0,

@empid int = 0)

RETURNS INT

AS

BEGIN

declare @rbq nvarchar(1000)

set @rbq = (SELECT pj_role_based_query FROM projects WHERE pj_id = @project_id)

set @rbq...

What I'm after is to use query text that is already stored in the database, not to exec a stored procedure. (I'm doing this as part of an implementation...