I would like to store the stored procedure along with the parameters. How do I do that?
I know I have to create a temp table.
I can use a insert statement as follow to insert result into a tempable
insert into #temptable EXEC MyStoreProcedure Parm1 Parm2
I am hoping to get the result temptable in the following format:
Parm1, Parm2, StoredProcedureResultColum1, StoredProcedureResultColum2, ...
Any help will be appreciated.