SQL Procedure Data in QlikView

sona_sa — Tue, 04 Nov 2014 10:15:46 GMT

Hello,

I have a procedure and I want to pull the data with some input parameter. So Can you suggest me how I can do the same.

These are the following input parameters :

@LotID Bigint,

@FromDate varchar(50),

@ToDate varchar(50),

@Diff varchar(50),

@colours varchar(50) ,

@clarity varchar(50) ,

@JewlexRapPriceDate datetime ,

@GIARapPriceDate datetime,

@VendorDate datetime

Now How I will define this in QlikView and How I will fetch the data from SQL Database. My SP name is : [usp_EPCM_Get_FinalPolish_Report_bck]

Thanks Team.

Re: SQL Procedure Data in QlikView

Gysbert_Wassenaar — Tue, 04 Nov 2014 10:48:06 GMT

sona_sa — Tue, 04 Nov 2014 11:02:01 GMT

I tried the same but it is not providing me any single no. of rows. No any output.