I changed my sproc ( a C# dll ) to make a ## temp table and my fox code worked.

Now more research into best practice for our situation.

Thanks.