LOAD a store procedures in a table

[#1]

HI Again;

Thanks for your helps i executed a store procedures from Qlikview this way;

ODBC

CONNECT TO mgtmexbaan6 (XUserId is PeCUMcRNTLbIXcVK, XPassword is KAJINZVMBDZcJ);


SQL EXEC dbo.rmmMtyBom010Fill;

IT IS POSSIBLE TO LOAD the result of this store procedures in a table of Qlik View????

can you help???

[calvindk]

Depending on how the Sproc works, these options are available

If it just returns a data set then:

ODBC

CONNECT TO mgtmexbaan6 (XUserId is PeCUMcRNTLbIXcVK, XPassword is KAJINZVMBDZcJ);

QVTableName:
SQL EXEC dbo.rmmMtyBom010Fill;

Disconnect;

If it creates tables then:

ODBC

CONNECT TO mgtmexbaan6 (XUserId is PeCUMcRNTLbIXcVK, XPassword is KAJINZVMBDZcJ);

SQL EXEC dbo.rmmMtyBom010Fill;

TableName:

Selec * FROM OoutputTableName;

TableName2:

Select * FROM OoutputTableName2;

Disconnect;

[#3]

ok perfect thanks for your help !!!!