topic Re: Running a MSSQL Server stored procedure in QlikView

Running a MSSQL Server stored procedure

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Can one run a Microsoft SQL Server stored procedure from a QV application and use it to write a report? If so how can this be accomplished?

Regards.

Chris

Gysbert_Wassenaar — Sun, 13 Mar 2016 17:46:15 GMT

First you create a connection to the database and then you execute the stored procedure.

SQL Exec MyStoredProcedure(Parameter1, Parameter2, ...etc );

Anonymous — Sun, 13 Mar 2016 18:18:15 GMT

Many thanks Gysbert most appreciated

rustyfishbones — Tue, 17 May 2016 21:53:38 GMT

Example below, where the parameters are pointing to Qlikview Variables, that can be changed via an Input Box on the Qlikview front end.

Still figuring it all out!

ODBC CONNECT TO Extreme;

SQL EXECUTE dbo.spUPS

@Shipper = [$(vShipper)],

@OrderNo = $(vOrderNo),

@OrderAmount = $(vOrderAmount)

Anonymous — Wed, 18 May 2016 01:14:44 GMT

Thank you very much Alan