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:
You'll probably get a better response if you start a new thread in the appropriate topic and include details about what exactly you're trying to do. The members of this forum tend to be incredibly good at suggesting ways to accomplish tasks without using temp tables/table variables.
Jason Wolfkill