Stored Procedure to QVD - Urgent

[rajeshvaswani77]

Hi All,

     I have one question as to how we can execute a stored procedure that returns a resultset (many no. of rows). This has to be stored in to a QVD file.

example

exe mysp par1,par2,par3

returns

val1a,val2a...

val1b,val2a...

.

.

.

I will be including this in my QVD script generation file(QVW)

thanks,

Rajesh Vaswani

[#2]

once connected, just use:

SQL mysp par1,par2,par3;

that is.

tested on sybase and mssql with success (OLEDB)

be sure you only have one and only one resultset