How to use select * into Table from exec Stored_Procedure

Transact-SQL
21

Thank you jeffw8713,
I'm using SSRS for the reports. The Pivot result runs well with the S-P. But, I'll try to add the lookup info to the dataset from your suggestion.

Best,
lw