Executing the same stored procedure multiple times

[#1]

Hi,

I was wondering if it was possible to create a table that has the records from the same stored procedure executed multiple times?  I've tried to create a table and fill it with the statement below:

ProposedBudgetIncome2013:

LOAD cmpcode,

    el1,

    el2,

    el3;

SQL

CREATE TABLE #MyTable (cmpcode char(50),

    el1 char(50),

    el2 char(50),

    el3 char(50))

INSERT #MyTable

EXEC reportprocs.P_Return_CODAReportingBudgetIncomeStatement 'ACTUAL',2011

INSERT #MyTable

EXEC reportprocs.P_Return_CODAReportingBudgetIncomeStatement 'ACTUAL',2012

INSERT #MyTable

EXEC reportprocs.P_Return_CODAReportingBudgetIncomeStatement 'ACTUAL',2013;

But I get an error.  Any solutions?