I have a stored procedure (which is overly complex and written by someone else) that I need to take the results of and put them into tables. The stored procedure uses Dynamic SQL to build and then run 5 SELECT statements based on literally
hundreds of variables. I need to take the results of these SELECT statements and put them into tables in a different database. Rewriting or re-creating the logic of the stored procedure is NOT AN OPTION as the logic may change over time and
maintaining it in multiple places would be nightmarish. Can anybody help me with this? I've googled extensively, but have only been able to find examples of using one result set not multiple ones.
View Complete Post