Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

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

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

1 Reply
MVP
MVP

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

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.