stored procedure with params

[#1]

Hi

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]

PFA Sample.

Vikas

[#3]

hi

No example

[maxgro]

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%';

T:

load *;

sql exec sp_test '$(var)';

Example of Sql stored proc

CREATE PROCEDURE sp_test

  @p_banca varchar(10)

AS

BEGIN

  SET NOCOUNT ON;

  SELECT * from d001_banche where des_banca like @p_banca;

END

GO

[rustyfishbones]

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]

hi

chk dis may helps u

Sql Server - How To Write a Stored Procedure in SQL Server - CodeProject