Executing the same stored procedure multiple times

Tue, 31 Jan 2012 15:17:53 GMT

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?

topic Executing the same stored procedure multiple times in QlikView

Executing the same stored procedure multiple times