call SQL Stored Procedure in srcipt and use the result set in sheet

[#1]

Hi All,

I have a SP in SQL. I want directly call that SP in the QV edit script and want to use the return result of the SP in the sheet.

Thanks,

Tej

[Miguel_Angel_Baeyens]

Hello Tej,

You can use the SQL ... EXECUTE sentence in the loading script. You will find some useful and detailed examples here and here. The code is not mine, but both are in my favorites for some time.

Hope that helps.