I'm testing various alternatives. I just stripped the CTE and ran it, ended up with positive values in the flat file. I rewrote the code for determining the...

No, the names are all unique.

Thanks

Yes, I have verified the permissions on all the objects involved -- everyone who has access to the application has Select permissions on the tvf, and Execute permission on the...

Yes, and so that solves #1 - thank you. Anyone know about # 2, why the function wouldn't be working for anyone but the owner and the dba?

I have a variable in my SSIS package. When I run a procedure, I substitute the variable for the parameter: in SSIS the SQL looks like: EXECUTE...

Yes, it runs in SMS just fine: SELECT Col1, Col2

...