I'm working on a stored procedure that makes a pivot table. I want to build into the stored procedure the option to save the result to a table only for this particular output. And the table must be flushed before a new query result from the stored procedure is generated.
Is that possible? Any example? :-)
It's the procedure in my other question here: 29073732/Convert-MS-Access-SQL-Pivot-code-to-MS-SQL-Server-code.html