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: