I have a fairly complex SP which produce a pivot table with dynamic columns.
I was wondering if there is a way to copy that result table to another one with same columns/rows/data, except that the second table is actually stored in the database rather than just produced at runtime.
I tried something like:
SELECT * FROM (runtime_generated_PIVOT_Table) INTO (new_Table)
but that did not work.... (probably didn't work because of the PIVOT table query, not sure)Steve
View Complete Post