SQL Procedure Data in QlikView

[sona_sa]

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.

[Gysbert_Wassenaar]

See this post: Re: Store procedure with parameters

[sona_sa]

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