christopher_rogala (7/31/2013)
Let me start off by saying, I agree that temp tables are much more efficient that variable tables; and try to exclusively use temp tables. That said, you cannot use temp tables in table-valued functions, so what should I do now?I am struggling with either caching the data as part of my hourly job, or finding another way to access the live data. I know what you are thinking, just use a stored procedure. I wish the answer was to use a stored procedure, but Tableau doesn't play well with stored procedures.
Does anyone have a suggestion? :sick:
The need to use a table variable implies you're writing multi-statement table valued functions. My answer to that is, don't, use inline table valued functions where possible.
Regarding Tableau, that's quite a limitation for a reporting product with such a good reputation. Can you switch to using SSRS?
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato