run sql stored procedure

[mrbqlik2009]

Hi,

I have a sql stored procedure with 2 parameters.

and in qlikview i have a table, button and two inputbox.

I want when user click button, stored procedure execute with inputbox as parameter and see result in table.

[kfoudhaily]

hello, sub fonction might help

but sub is a script fonction wich means you need to reload the script for the sub to be executed.

maybe there are some other solutions to your issue, please provide context information in order to suggest solution

[mrbqlik2009]

Hi,

supppose i create sql stored procedure like this:

create PROCEDURE [dbo].[mandeHesab]

@fromDate datetime,

@todate datetime

as

(select * from dbo.test where fDate = @fromDate and tDate=@todate)

I want pass the fromdate and todate from inputbox in qlikview and fetch data from sql.