This is a very strange problem, but maybe someone else is having it.
When I run a stored procedure that has a temp #Output table (where I have run inserts and calculations). for some reason, Period (Datetime) and Revenue (Money) refuses to appear, whereas all the fields from the ⌗Header table that I joined has appeared as well as some from #Output.
Another problem I get on occasion is Insert Data:Unbound field
No idea what this means. Seems to generate on the select from #output
Running all this through Sql Server 2008R2. When I run on Sql Server, I get no issues running any of the data, and get the results as expected.
Thank you!
Take a look at this - Calling a ⌗temp table inside a stored procedure from #Tableau | Tableau Love
Maybe SET NOCOUNT ON will solve your problems
