topic Re: stored procedure with params in QlikView

stored procedure with params

Fri, 14 Mar 2014 09:24:29 GMT

I have a SQL stored proc which has three parameters that are user driven. What is the best way to send params to the stored procedure by the user?

Thanks

vikasmahajan — Fri, 14 Mar 2014 10:21:54 GMT

PFA Sample.

Vikas

Fri, 14 Mar 2014 10:40:29 GMT

No example

maxgro — Fri, 14 Mar 2014 20:08:20 GMT

you can define an input box, let the user set the 3 variables in input box and then reload data using the 3 input box variables as parameter

example of Qlik script (just one parameter, add the other 2)

//set var = '%AAA%';

load *;

sql exec sp_test '$(var)';

Example of Sql stored proc

CREATE PROCEDURE sp_test

@p_banca varchar(10)

BEGIN

SET NOCOUNT ON;

SELECT * from d001_banche where des_banca like @p_banca;

END

rustyfishbones — Tue, 17 May 2016 21:48:25 GMT

Hi,

The user can simply apply the same parameters in Qlikview, so I created 3 Params in SQL Server

called

@Shipper

@OrderNo

@OrdAmount

And how it would look in Qlikview

ODBC CONNECT TO Extreme;

SQL EXECUTE dbo.spUPS

@Shipper = 'UPS',

@OrderNo = 1200,

@OrdAmount = 10000

Chanty4u — Wed, 18 May 2016 05:44:18 GMT

chk dis may helps u